in GDG: is it poosible to copy records from a file which
utilizes some 100 cylinders to a gdg whose model is defined
as trk(1,0) and also it possible to copy 100 bytes file to
80 bytes file?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
what is the maximum number of tables that can be joined ?
What is an instance database?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is a view? Why use it?
What are union and union all?
How to check table size in db2 sap?
What does the sqlcode of -818 pertain to?
How are write I/Os from the buffer pool executed?
What is sqlca’s maximum length?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?