seema nair

• Apr 4th, 2006

The command TSO XPED should take you to Xpediter main screen

Azahar

• Dec 15th, 2005

For Xpediting a program first a cmnddio load should be created.Then give xp where u can give the load lib and xped ur program

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

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

gokul

• Jun 13th, 2006

could u pls expalin a little more on locationcollectionpackage versionregardsGokul.

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 19th, 2006

A package has a 4 part name:location: collection id: package name: versionThe collection id is not a place but rather a qualifier that allows a group of packages (i.e. those bound to that collection) ...

Answer Question  Select Best Answer

gokul

• Jun 13th, 2006

hi folks,collection: set of packages with a collection idversion: it refers to a package created at a particular time.(ie) if the same package is created at a later time with no changes it will be a d...

javid

• Apr 10th, 2006

Hi Sataya!My Question is What is Collection and Version.I know both are associated with packages.But am in confusion.plz clear me.

Answer Question  Select Best Answer

rupesh

• Feb 22nd, 2007

Select constrint_name,constraint_type,search_condition from user_constraintswhere table_name='name of table in upper case';

hemant

• Apr 18th, 2006

SELECT * FROM SYSIBM.SYSCOLUMNS WHERETBNAME=table-name AND TBCREATOR=' creator-name';orto see column names, types and lengthsSELECT NAME,COLTYPE,LENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBNAME=table-name AND TBCREATOR=' creator-name';  the above queries can be used 

Answer Question  Select Best Answer

SHANKAR

• Dec 31st, 2006

BY USING HANDLE AID.

kaushikee

 Profile Answers by kaushikee Questions by kaushikee

• Jun 7th, 2006

Hi,   I am little confused, to find this ques. in DB2 section. If it is for CICS the ans. is as follows:   The Execution Interface Block(EIB) has a field called EIBAID which contai...

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

They are the opposite of root pages. Leaf pages are the lowest level index pages - the pages that contain index entries and information to the corresponding table rows.

MB

• Jan 11th, 2007

Leaf pages are used in context of indexes and contain data.

Answer Question  Select Best Answer

The opposite of a leaf page; it is the highest level index page. An index can contain only the one root page; all other index pages are associated to the root.

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 9th, 2012

The indexes of DB2 are represented using b-tree,the b-trees top page is called as the root page.The root page entries represent the upper range limits of the index and are referenced first in a search.

Answer Question  Select Best Answer

A thread is the connection between DB2 and some other subsystem, such as CICS or IMS/DC.

burelamanohar

• Feb 6th, 2007

A thread is a control structure used by DB2 to communicate with an application programme. Every programme must communicate with DB2 by means of Thread.

Answer Question  Select Best Answer

This is a key concept for any relational database. Isolation level is the manner in which locks are applied and released during a transaction. For DB@ a 'repeatable read' holds all locks untile the transaction completes or a syncpoint is issued. For transactions using 'cursor stability' the page lock releases are issued as the cursor 'moves', i.e. as the transaction releases addressability to the...

burelamanohar

• Feb 6th, 2007

Isolation level means the extent to which the transaction isolates the data is accessed

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

Static sql is hard-coded in a program when the programmer knows the statements to be executed. For dynamic sql the program must dynamically allocate memory to receive the query results.

Yash Rajput

• Aug 15th, 2017

Static SQL: 1) SQL statements are compiled at compile time.
2) more efficient.

Dynamic SQL: 1) SQL statements are compiled at run time.
2) Less efficient.

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

It is a data structure that must be included in any host-language program using SQL. It is used to pass feedback about the sql operations to the program. Fields are return codes, error messages, handling codes and warnings.

ajay ajjur

• Dec 19th, 2006

SQLCA is t communication area wher v can check t return codes, no of updated , deleted records it contains SQLCODE, SQLERRD, SQLERRM etc.....

Answer Question  Select Best Answer

The three types are shared, update and exclusive. Shared locks allow two or more programs to read simultaneously but not change the locked space. An exclusive lock bars all other users from accessing the space. An update lock is less restrictive; it allows other transactions to read or acquire shared locks on the space.

ajay ajjur

• Dec 19th, 2006

3 types of locks are SHARE EXCLUSIVE UPDATE

Answer Question  Select Best Answer

SQL statements may return any number of rows, but most host languages deal with one row at a time by declaring a cursor that presents each row at a unique isolation level.

ramanatcs

 Profile Answers by ramanatcs Questions by ramanatcs

• Dec 24th, 2008

Isolation  Level determines the duration of the lock over a page.3 level are there.1. Cursor Stability : lock is retained when untill the cursor moves from one record in one page to the next reco...

Answer Question  Select Best Answer

The common aggregate, built-in functions are AVG, SUM, MIN, MAX, COUNT and DISTINCT.

ramanatcs

 Profile Answers by ramanatcs Questions by ramanatcs

• Dec 24th, 2008

STDDEV ( Standard Deviation )VARIANCE These are used in stastical calculations.

Answer Question  Select Best Answer

The three data types are DATE, TIME and TIMESTAMP. CHAR can be used to specify the format of each type. The DAYS function calculates the number of days between two dates. (It's Y2K compliant).

burelamanohar

• Feb 6th, 2007

DATE PIC X(10)TIME PIC X(8)TIMESTAMP PIC X(26)

Answer Question  Select Best Answer