What is the error code -803 ?
Answers were Sorted based on User's Feedback
Answer / anurag singh
Inserted or updated value is not valid ( Duplicate )
| Is This Answer Correct ? | 6 Yes | 2 No |
how can u retrieve the data from null values using applicaion program.
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is cursor stability?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What is lock escalation?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
What is ibm db2 connect?
What is the difference between cursor and select statement?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?