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 10149Suppose 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 5290i 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 5576Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
2 3437Can 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 5169How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
IBM,
1696DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
IBM,
1 5279in 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 4002Parm 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 6632
What is blu acceleration in db2?
What is bind in db2?
Explain what are the various isolation levels possible?
What is db2 plan table?
How do you find the maximum value in a column in db2?
What does db2 blu stand for?
What is copy pending and check pending in db2?
can all users have the privilage to use the sql statement select * (dml)?
What is innodb buffer pool?
What is isolation level in db2?
What is package in cobol db2?
What is a bind in db2?
What is image copy in db2?
What are iseries servers?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?