1 Declare / fetch / open / close2 Open / Declare / fetch /close3 Declare / open / fetch /close4 None of the aboveDeclare / open / fetch /close

srinu_ramu

 Profile Answers by srinu_ramu Questions by srinu_ramu

• Dec 18th, 2007

3. Declare/open/fetch/close

Answer Question  Select Best Answer

DCLGEN stands for declarations generator; it is a facility to generate DB2 sql data structures in COBOL or PL/I programs.

RamehNaiduKVA

• Oct 25th, 2007

In COBOL DB2 programs the host variables are needed for the column names of the tables. This can be done by a DB2 utility called DCLGEN Declaration Generator. This is primarily a copybook of host vari...

sunil bansal

• Sep 11th, 2007

It is the place where the complete data field of the table is present and it is easy to use the data name when ever required. Without dclgen also one can run the program but he has to declare all the things in the working-storage section.

Answer Question  Select Best Answer

Uma mahesh

• Oct 22nd, 2007

After binding you can use IKJEFT01 utility in stepname and specify db2 system name, program, library and parm in sysin dd *

sangramkc

• Dec 28th, 2006

We use IKJEFT1BAnd pass the follwing in the SYSTSIN DD *DSN SYSTEM(your DB2 system name)RUN PROG(DB2 program name) -PLAN(the plan name to which the program is bound) -PARM(' vale to be passed') -ENDWe need a corresponding SYSTSPRT DD parameter just like SYSOUT or SYSPRINTJai sai ram

Answer Question  Select Best Answer

Apurbita Roy Majumder

• Oct 16th, 2007

It is similar to the sequential read but here first a pointer is set and then the file is read from that particular record. For example:START file name KEY >= file key ( Ke...

manoj

• Sep 29th, 2006

 VSAM files can be read and write same like cobol files. But only difference is you have to give the dsn path of your vsam file in jcl step while compile time.  select empfile assign to dd1  dd1 will have the dsn parameter with vsam file path.try it manoj.

Answer Question  Select Best Answer

Table1 has the following data – Book Chapter ---------------------------- DB2 Retrieval DB2 Updates DB2 Locking COBOL File processing COBOL Working storage JCL Job statement CICS Maps What will be the result of the querySELECT BOOK FROM TABLE1 GROUP BY BOOK HAVING COUNT(*) > 1a.DB2, COBOL, JCL, CICSb.DB2, COBOLc.JCL, CICSd.DB2, CICSe.JCL, COBOLDB2, COBOL

A NULL value takes up one byte of storage and indicates that a value is not present as opposed to a space or zero value. It's the DB2 equivalent of TBD on an organizational chart and often correctly portrays a business situation. Unfortunately, it requires extra coding for an application program to handle this situation.

arijit.seth

• Sep 29th, 2007

A NULL value is different from a blank or a zeroA NULL value can be inserted into columns of any data typeA NULL value will evaluate to NULL in any expression (e.g.NULL multiplied by 10 is NULL)If a c...

burelamanohar

• Feb 6th, 2007

A NULL value indicates the absence of a column value in a row.A NULL value is not the same as ZERO or all BLANKS.

Answer Question  Select Best Answer

B L Praveen

• Sep 21st, 2007

You keep track of changes you have done to the row later on update back to your orginal data.Col1------0Update tbl1 set col1 = 1where key1 = 111Col1-----1Update tbl1set col1 = 0where key1 = 111Col1If you have update many rows then you need to load the table again.-----
0

Answer Question  Select Best Answer

B L Praveen

• Sep 21st, 2007

You will declare the Cursor with "WITH HOLD " Option when you?want the cursor to be pointing to the next row even after the fetch from the db2 table and you exit from the program until expilicit commit is performed to updated to Db2 and Close cursor command is executed.

subbu

• Feb 20th, 2006

 hi,We use cursor only when we updating existing records or Inserting Some Records to the Table.When you Using commit, in DB2 every single row will be commited after the process. If abend oc...

Answer Question  Select Best Answer

A lock is the mechanism that controls access to data pages and tablespaces.

Raghunathan Asari

• Jul 23rd, 2007

Lock is a DB2 mechanism by which DB2 can provide Concurrency and Consistency at  the same time(not exactly).  Based on the SQL statement DB2 provides diffe...

Sukanya Srinivas

• Apr 20th, 2007

Lock is one of the component of DB2. IRLM(IMS-DBe Resource lock Manager) used for data locking and unlocking. Lock is of two types. 1) Share lock 2) Exclusive?Lock?????? A) Share lock...

Answer Question  Select Best Answer

A synonym is used to reference a table or view by another name. The other name can then be written in the application code pointing to test tables in the development stage and to production entities when the code is migrated. The synonym is linked to the AUTHID that created it.

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

Also, a Synonym is specific to the DB2 subsystem.  Synonym can only access the table or view in the subsystem in which it is defined.   A synonym is dropped when the table is dropped.An...

Answer Question  Select Best Answer

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

During precompilation of a COBOL program with SQL queries, the SQL statements and COBOL codes are separated. The timestamp during precompilation helps in identifying the corresponding versions of thes...

Answer Question  Select Best Answer

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

Search for the table name in the DB2 table SYSIBM.SYSINDEXESSELECT * FROM SYSIBM.SYSINDEXES WHERE NAME = 'tablename'  OR CREATOR = 'creator name' ;

Answer Question  Select Best Answer

It is a DB2 facility for static SQL statements - it replaces these statements with calls to the DB2 language interface module.

Raghuram

• Jul 17th, 2007

During Pre-compilation : 1. The embedded SQL statements are stripped out.  In the source code they are commented out and instead CALL statements are inserted.2. Based on the DECLARE TABLE st...

Sukanya Srinivas

• Apr 20th, 2007

Precompiler: 1) Checks for SQL syntax in application prgram 2) Copies all the?SQL statements into a sepearte member known as DBRM(DataBase Request Module) 3) Comment all the SQL statements 4)...

Answer Question  Select Best Answer

Raghuram

• Jul 17th, 2007

In the process of DB2 program preparation, it is necessary to have the DB2 subsystem up during Bind process.It is during Bind, that the Stripped out SQL statements are checked for any errors and ...

javid

• Mar 21st, 2006

DB2 mustbeup at  Bind Stage.

Answer Question  Select Best Answer

These are attributes of one table that have matching values in a primary key in another table, allowing for relationships between tables.

neha

• Jul 6th, 2007

Foreign Keys are keys used in a table as an attribute and are primary keys of some other table

Answer Question  Select Best Answer

kckinney

 Profile Answers by kckinney Questions by kckinney

• Jun 8th, 2007

Could you provide some more information? Your question assumes we know what you've asked previously.

Answer Question  Select Best Answer

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

DB2 supports index with the help of leaf pages, non-leaf pages, and root pages.Leaf pages - Contains indexed values followed by Record Identifiers (RIDs).Non-leaf pages- Contains the upper range val...

Answer Question  Select Best Answer

AR

• Mar 16th, 2007

Its not a tool. Its REPAIR utility.

kp

• Jun 8th, 2006

By using tool called REPAIR.

Answer Question  Select Best Answer

No. The table and its view are created anew, but the programs accessing the view do not need to be changed if the view and attributes accessed remain the same.

rayadurgamsudha

 Profile Answers by rayadurgamsudha Questions by rayadurgamsudha

• Mar 11th, 2007

No the view need not be redone. the changes done in base table will be seen in the view too this is the feature of a view. any manipulations, adding , deleting is done to the base table the changes are seen in the view without being redone.

Answer Question  Select Best Answer