Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
1 7062How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
2 9108In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
1 10312
Tell me how many alternate indexes you can have on a dataset?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is the function of the dd avgrec keyword in sms datasets?
What is the difference between lds and esds?
in a cobol select statement for a ksds can you tell me what are the 3 possibilities for access?
What do you mean by an alias?
Explain the mdt in cics?
How many root segments do we have per database record?
how to convert the recors form vsam file to db2 table tru file aid
I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK
What is the quality process in development?
What are the different types of table spaces?
What does the sample library of uni-rexx consist of?
What is the use of db2 optimizer?
What is the term bms in cics?