javid

 Profile Answers by javid Questions by javid

• Apr 3rd, 2006

Thank u for clearing me this.

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 28th, 2006

Remember: dedicated threads are dedicated to a particular application. This information is in a table called the Resource Control Table. It's not a CICS table and it's not a DB2 table.The RCT is owned...

Answer Question  Select Best Answer

seema nair

• Apr 4th, 2006

Use IDCAMS DELETE utility in first step of JCL to delete all the files as shown below//STEP0005 EXEC PGM=IDCAMS               ...

Saradha

• Oct 13th, 2005

Use IEFBR14 with DISP=(MOD,DELETE,DELETE). This is a dummy utility, just to make sure that atleast one EXEC statement is present in the JOB. DISP=(MOD,DELETE,DELETE) will delete the dataset, if i...

Answer Question  Select Best Answer

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

hemant

• Apr 18th, 2006

i think only one clustering index ll be created for any table in DB2. This clustering index is created on the primary key of the table. for all other index(es) created on the table they ll be nonclustering index(es) .

pradipta

• Feb 3rd, 2006

As many no of column's that table is having that many no. of indexs we can pass.

Answer Question  Select Best Answer

amit

• May 29th, 2006

Also QUERY TABLE command will tell  you if load is complete or not

Saleem Kidwai

• May 23rd, 2006

Use DB2I command. Option 7.TO CHECK STATUS OF DATABASE (IT IS READ or READ/WRITE ETC)-DIS DB(*) SPACE(*) For eg,to check whether TABLESPACE PXXXXXXX.PZZZZZZZ IS IN CHECK PENDING, GIVING FOLLOWING :-DIS DB(PXXXXXXX) SPACE(PZZZZZZZ)       

Answer Question  Select Best Answer

Kishore

• Jun 11th, 2006

If it is the number of DASDs you want to know, then it is 133 DASDs.

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

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

kaviarasu

• Jun 13th, 2006

DIFFERENCE BETWEEN SPUFI AND QMF : SPUFI : 1.you can execute more queries at a time. 2. In SPUFI result of the query will be in PS or in PDS member will store but3.you know the sqlcode after exec...

KAVIARASU

• Jun 13th, 2006

DIFFERENCE BETWEEN SPUFI AND QMF : SPUFI : 1.you can execute more queries at a time. 2. In SPUFI result of the query will be in PS or in PDS member will store but3.you know the sqlcode after exec...

Answer Question  Select Best Answer

Navaneetha krishnan

• Jun 21st, 2006

Do u want the the list of error codes in Cobol or jcl or Vsam of Db2 or cics?

Answer Question  Select Best Answer

The explain statement provides information about the optimizer's choice of access path of the sql.

Prasanth

• Jun 28th, 2006

The EXPLAIN statement obtains information about access path selection for an explainable statement. A statement is explainable if it is a SELECT or INSERT statement, or the searched form of an UPDATE ...

Answer Question  Select Best Answer

srini1

 Profile Answers by srini1 Questions by srini1

• Jul 3rd, 2006

You should use cobol defined variable RETURN-CODE in you cobol program

srini

• Jul 3rd, 2006

Hi,you should move the value to cobol defined variable RETURN-CODE

Answer Question  Select Best Answer

umapathi

• Jul 21st, 2006

hi the above said answer is correct  but selection criteria to usage should be T

pradipta

• Sep 9th, 2005

Go to file-aid copy option.Enter the from dataset to be copied and to dataset to which you want to copy.go to options. Enter 0 at Initial records to skip field.Then enter 3 at the no of records to skip field and 1 to no of records to select.press enter and PF3.

Answer Question  Select Best Answer

Tapastapu

 Profile Answers by Tapastapu Questions by Tapastapu

• Aug 11th, 2006

hi everybody,i am new member of this group.what r the compiler options we use?the compiler options are:for COBOL: IGYCRCTLfor COBOL-DB2: IKJEFT01where the compiler option will be?IGYCRCTL: this is use...

Answer Question  Select Best Answer

Referential integrity refers to the consistency that must be maintained between primary and foreign keys, ie every foreign key value must have a corresponding primary key value.

Tapastapu

 Profile Answers by Tapastapu Questions by Tapastapu

• Aug 11th, 2006

The relation of the primary key of  a base table with foreign key of the reference table is known as referential integriety.

Answer Question  Select Best Answer

Sandeep

• Oct 16th, 2006

 Hi,   BMC S/w has provided this facility to us,   Rather than i explain it will be better u refer   http://documents.bmc.com/products/documents/02/43/60243/60243.pdf thnx, Sandeep

Answer Question  Select Best Answer

A view is a virtual table made up of data from base tables and other views, but not stored separately.

chandra kanth ganga

• Nov 10th, 2006

View is a vitual table, which do not have physical storage.we can create a view from one or more than one table(s) or view(s).if any modification is done on the base table the view is also get effected.but they are some limitations while creating views while using joins.

vijay saxena

• Oct 24th, 2006

A view table is virtual or logical table which depends on base table by using this the filtered records may be accessed frequently.

Answer Question  Select Best Answer

Prasad

• Nov 22nd, 2006

Hi,Both the above ways can be selected.If u want to load the table with some data u can use load utility.If u want to move some value in the prog then u can go for the host variables. 

javid

• Mar 21st, 2006

By utilising Load Utility.

Answer Question  Select Best Answer

sangramkc

• Nov 28th, 2006

for both -911 or -913 , you can check further SQLERRD(3) also contains the reason-code which indicates whether a  deadlock or timeout occurred. The most common reason codes are:   ...

bnirmalraj

• Sep 26th, 2006

911 - THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO      DEADLOCK OR TIMEOUT. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name &...

Answer Question  Select Best Answer

arivu

• Dec 1st, 2006

How does you get record no from 5 to 15 from a dataset of 100 records?        

SreeHari

 Profile Answers by SreeHari Questions by SreeHari

• Nov 15th, 2005

Hi,From File-Aid Main  Menu Choose option Browse or Edit and press enterWhere we suppose give physical file name and copybook name and copy book path and also At the bottom there is option '...

Answer Question  Select Best Answer