what are the utilities for load and unload the DB2 tables
Answer / anupam das
There are many utilities available but most commonly used
are IKJEFT01, IKJEFT1A and IKJEFT1B. Also need to use
DSNTIAUL program.
You can generate Unload/Load utility from DB2 Admin tool.
| Is This Answer Correct ? | 14 Yes | 0 No |
HOw can I get the negative sign while deduct high value from low value
In COBOL CALL-CALLING,if a program A is calling 3 sub- programs, dynamically, then it is said sub-programs will always will always in Initial Mode. My question is : Do we need to code CANCEL or (IS INITIAL) for dynamically called sub-programs or it is the property of Dynamically called pgms so every time sub-pgms are called they will be in initial mode. ***This question is only Dynamic call****, Please reply. Thank you in advance.
What are different data types in cobol?
how would you resolve sb37 and SE37?
In an array processing what is the thing that can be done by using subscripts but not by using index
what are the paramater we cannot use in procedure?how many instream we can write in single jcl?can we call instream to catalog and ctalog to instream?
What are the differences between COBOL and COBOL II?
How do pass the values to the parameters in cobol
What is the difference between PIC 9.99 and PIC9v99?
How will you find the currepted records in a file
Following questions were asked in Capegemini on 8th sep,2012 mainframe test 1.)Condition code for dul recors in VSAM- 2.) Is NULL or =NULL in Select statement 3.)max size of CI 4.)What happens after CI is full 5.)Ques on COND parameter 6.)which among following can not be rolled back a)delete table b.)droptable c)Update d.)insert 7.)groupby and orderby sql querries 8.)Max extents in VSAM file 9.)quesn on DPRTY=(1,10) 10.)range of condition codes in COBOL 11.)occurs clase can not be used at which level? 12.)delimiter in jcl 13.)sort card for file in PGM=SORT 14.)PIC(6) value 120056 possible? 15)question on BLKSIZE Is (20,20) and (20,10) possible? 16.)number of bytes in RDF 17.)Can we use index in WS-section or LK-section 18.)Verify command in IDCAMS used for? 19.)question on Alternate Index 20.)Return code of file attribute mismatch 21.)In which format COBOL variables stored? 22.)what is Alternate of HANDLE? 23.)can SUM,AVG,MIN,ROUND used in numeric and char variable data types? 24.)What is the datatype of FILE STATUS codes in WS-section?
Whats the use of Examine command? can someone help me?