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

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

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

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

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

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

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

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

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

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

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

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

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

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

javid

• Mar 20th, 2006

Cascade rule is one of the RI constraint. Which allows deletion of FK from the Dependent table if the PK from the parent is deleted. If we try to delete record from the parent that is not in the child we will see abend code -532.

Answer Question  Select Best Answer

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 19th, 2006

Keep it simple. The DB2 catalog is under the schema SYSIBM (along with a whole lotta other stuff as well).

Krishna

• Nov 14th, 2005

Meta data information is stored in the sysibm schema. sysibm schema holds the database information and this schema exists for each database and holds the tables, columns, procedures and others that a user creates under that database.

Answer Question  Select Best Answer

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 19th, 2006

To answer the original question, for many releases only one column could appear in the result table of a subquery.  As of Version 7 of DB2 the result of a subquery is equivalent to a fullselect which means that 750 columns can appear.

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 19th, 2006

Sorry guys but those are not DB2 metrics. In DB2 Version 8 the max length of a row is 32K not 64K. The max number of tables in a join is 225 (for many releases 15 tables was the max but not any more, ...

Answer Question  Select Best Answer

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 19th, 2006

I think what you mean is the DB2 catalog. Since the catalog database (DSNDB06) is a relational database made up of tables you "handle" it with SQL.

Answer Question  Select Best Answer

muthukumar.R

• Mar 3rd, 2006

Record will be appeand in the file.

Answer Question  Select Best Answer