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 11429Suppose 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 6328i 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 6707Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
2 4763Can 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 6164How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
IBM,
2261DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
IBM,
1 6175in 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 4898Parm 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 8283
What are the contents of a dclmgen?
Which component is responsible for db2 startup and shutdown?
How to execute stored procedures?
What is copy pending and check pending in db2?
Explain how can you do the explain of a dynamic sql statement?
What is blu acceleration in db2?
Give a brief description of db2 isolation levels?
Is db2 a database?
How can you do the explain of a dynamic sql statement?
What is a buffer in memory?
What is the use of value function?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is db2 bind process?
How to get the ddl of a table in db2?
How do I add a column to an existing table in db2?