what is check pending option

Answer Posted / rama krishna reddy

The check pending option is used when the bulk data is
loaded into tables.
if you use the check pending option with load utility
then it will temporarly disable all the constraints that
are defined on that table.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What statement marks the beginning of an in-stream or cataloged procedure in jcl and assigns default values to parameters defined in the procedure?

816


What is 'mounting' of volumes ? Is there anything that a programmer can do in it ? How to find currently mounted volume ?

1996


how do you access an uncataloged dataset in a jcl?

839


Describe the various parameters utilized in the creation of a gdg?

682


What is the motivation behind coding class parameter in job statement?

686






how do you create a dataset in a jcl with the same file organisation as that of another existing dataset?

801


How can return codes be tested before execution of a job step?

923


define cond parameter in jcl?

773


in ways data can be passed to a COBOL program from JCL?

665


Explain about ISPF/TSO Commands

1311


1) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat

7084


if we want to use a gdg which is already created by some job, then how to use the reference of the last generation in a jcl?

1613


How do you submit a job for execution?

638


have in 100 records in a file i want to read first 3 records and skip next 3 records and agan i want to read 3 records and again i want to skip 3 records... run a loop from record one to 10 evaluate i/3 if comes even then skip else write to output file

923


How does jcl act on code(if you take a cobol program)?

707