What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
2 11333Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
IBM,
1 6247i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
2 6609Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
2 4682Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
UST,
1 6074How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
IBM,
2214DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
IBM,
1 6098in 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?
IBM,
1 4818Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
IBM,
3 8165
Define buffer pool.
What db2 400?
Is the primary key a clustered index?
How to find schema of a table in db2?
What is the difference between db2 and oracle?
What are types of indexes?
What is the use of with ur in db2?
what is db2 restart?
What are the prerogatives?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the picture clause of null indicator variable?
Which command is used to remove all rows from a table?
What is concurrency?
How to execute stored procedure in db2 command editor?
Explain about dbrm.