sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 19th, 2008

Collection means grouping of db2 packages.

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 18th, 2008

Collection is generally used for grouping of db2 packages.For each collection there is one collection id should be created.

Answer Question  Select Best Answer

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 19th, 2008

For performance tuning for your COBOL/DB2 program you need to follow COBOL & DB2 standrads along with your organization standards.

Raja

• Aug 22nd, 2006

1. Make sure the SQL query is coded as simply and efficiently as possible.Make sure that no unused columns are selected and that there is nounneeded ORDER BY or GROUP BY. 2. Indexable predicates:...

Answer Question  Select Best Answer

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 18th, 2008

Reuse means you can use the same cluster for further use. Remember it alternate index doesn't support for reuseble cluster.Upgrade means when the base cluster is opened for processing then the alternate index is updated automatically.

Answer Question  Select Best Answer

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 18th, 2008

Yes you should do recompile otherwise you will get n abend -818.

mail_mathewsonyc

 Profile Answers by mail_mathewsonyc Questions by mail_mathewsonyc

• Sep 1st, 2007

Hi,when you first compile a cobol-db2 program the cobol precompiler seperates all your cobol statements and DB2 statements into two seperate modules.The module containing the DB2 statements is ca...

Answer Question  Select Best Answer

What are the flavours of DB2?

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 17th, 2008

Oracle, Siebel like all relational databases are flavours of db2.

Answer Question  Select Best Answer

When using DB2 Connect, which of the following commands specifies the protocol information on how to connect to the host or to the server? A. CATALOG DCS B. CATALOG NODE C. CATALOG DATABASE D. CATALOG ODBC DATA SOURCE

betsysam

 Profile Answers by betsysam Questions by betsysam

• Aug 5th, 2008

Catalog Node

Answer Question  Select Best Answer

sainathkb

 Profile Answers by sainathkb Questions by sainathkb

• Jul 25th, 2008

This error related to db2 table access, please check you have access to all?the table which are using in your program.I face this problem in my exp and? i resolved this by communicating with on-site and DBA

Answer Question  Select Best Answer

The clause avoids closing the cursor and repositioning it to the last row processed when the cursor is reopened.

prasenjit_in

 Profile Answers by prasenjit_in Questions by prasenjit_in

• Jul 18th, 2008

To explain it let us take an example....Suppose we have a query that updates a table once the task is complete the table gets updated(commit), and all the relevant resources acquired by the task is re...

Answer Question  Select Best Answer

A54. The WHENEVER statement is coded once in the host program to control program actions depending on the SQL-CODE returned by each sql statement within the program.

DB2MAN

 Profile Answers by DB2MAN Questions by DB2MAN

• Jul 1st, 2008

IT IS USED TO PERFORM THE SPECIFIC USER DIFINED FUCNTION FOR THE PARTICULAR SQL RETURN CODE..For Ex ,Whenever sqlcode = 100  Display "whenever condition returncode is 100"whenever sqlco...

Answer Question  Select Best Answer

i) Cursor should always be Opened before Fetching ii) Fetch Operation cursor retrieves Only ONE row for every execution. Of the Statement.Which are true?1 Both are True2 i) is only True3 ii) is False Both are True

a_barwa1

 Profile Answers by a_barwa1 Questions by a_barwa1

• Jun 27th, 2008

Both are true.

Answer Question  Select Best Answer

Deadlock occurs when transactions executing at the same time lock each other out of data that they need to complete their logical units of work. What are the four lockable units for DB2?

chpastor3

 Profile Answers by chpastor3 Questions by chpastor3

• Jun 12th, 2008

The 4 lock units are Row, Page, Table (if segmented), and Table space. Christine Pastor 

burelamanohar

• Feb 6th, 2007

Two transactions A & B enter into dthe DEADLOCK state whan a transaction A which has locked an object X , waits on an object Y locked by transaction B which itself is waiting for X.

Answer Question  Select Best Answer

a.Database definitionb.Database descriptorc.Data buffer definitiond.Database dependencee.Direct buffer definitionDatabase descriptor

sdresh

 Profile Answers by sdresh Questions by sdresh

• Apr 11th, 2008

DBD stands for database descriptor

Answer Question  Select Best Answer

a.TSOb.CICSc.IMSd.BATCHe.All the above can access DB2.
All the above can access DB2.

sdresh

 Profile Answers by sdresh Questions by sdresh

• Apr 3rd, 2008

All the given environments caln access db2

Answer Question  Select Best Answer

a.No rows were selected.b.DB2 not operationalc.SQL completed successfully.d.SQL cannot be executed because program not bound.e.No SQL statements were input.SQL completed successfully.

bittumadhu

 Profile Answers by bittumadhu Questions by bittumadhu

• Mar 6th, 2008

Sql completed successfully

Answer Question  Select Best Answer

sumit_tumba

 Profile Answers by sumit_tumba Questions by sumit_tumba

• Jan 16th, 2008

select * from table_name sample nn:1,2...100..that is used in Teradata....

xyz

• Aug 13th, 2007

We write the query as follows:SELECT * from table_namefetch first n rows onlywhere n is an integer value.

Answer Question  Select Best Answer

DB2 is aa.Database/Data Communication Systemb.Databasec.Relational Database Management Systemd.Programming Languagee.Operating systemRelational Database Management System

sumit_tumba

 Profile Answers by sumit_tumba Questions by sumit_tumba

• Jan 16th, 2008

C)Relational Database Management System

Answer Question  Select Best Answer

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