sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 19th, 2008

It does not make any difference that you are defining cursor in working storage section or in procedure division. You can define it in both places. If you are defining a cursor in procedure division it doesn't affects at all of your Cobol/db2 program.
Regards,
Pradeep

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

There is no difference in declaring a cursor in working storage or procedure division.  The only constraint with declaring a cursor is that it should be done before any OPEN CURSOR statement.

Answer Question  Select Best Answer

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

If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table is in LOAD PENDING. D. The table is a replicated table. E. The table was created by a different user.

If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table is in LOAD PENDING. D. The table is a replicated table. E. The table was created by a different user.

Which of the following DB2 components allows references to Oracle and DB2 databases in a single query? A. DB2 Query Patroller B. DB2 Warehouse Manager C. DB2 Relational Connect D. DB2 Connect Enterprise Edition

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