This was related to -811 sqlcode, In a COBOL DB2 program
which accesses employee table and selects rows for employee
'A', it should perform a paragraph s001-x if employee 'A'
is present. In this case it gets -811 sqlcode, but still it
process the paragraph s001-x. What could be wrong in my
code.
Answer Posted / sangeethas1985
anybody who has an idea about this, please post answer.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How would you find out the total number of rows in a db2 table?
What is null value in db2?
What is the meaning concurrency in the db2 database?
Explain the function of data manager.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Is schema the same as database?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is cursor in dbms?
What is the latest version of ibm db2?
What are the prerogatives?
What is runstats and reorg in db2?
What are the contents of dclgen?
What is the usage of open cursor command?
Give the name of some fields form sqlca.