what is + sign and -ve sign for sql code ?
Answer / amarnadh reddy
In SQL CODE, + sign means wornings.
In SQL CODE, - sign means unsuccessful execution.
| Is This Answer Correct ? | 21 Yes | 1 No |
can any one give the list of some important sql abend codes which r frequently asked in interviews?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
how can u understand the end of the table ?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is dclgen in db2?
How is deadlock resolved?
What is explain in db2?
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
What is dbrm? What it contains? When it will be created?
If I have a view which is a join of two or more tables, can this view be updatable?
What is the difference between base table and view?
What is cursor stability?