My DB2 program first read the data from a file and then it
look into a table with the data it got from the file.If we
did not bind the program , should the file read before SQL
execution be success??
Answers were Sorted based on User's Feedback
Answer / reddy
Program successfully reads the file as the Bind is only for
DB2 queries and it would give an abend(-805) once it
reaches the SQL statement.
Any comments
| Is This Answer Correct ? | 11 Yes | 1 No |
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
what is parm utility
When is the skeleton cursor table created?
What is db2 instance?
Name the different types of Table spaces.
Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam
what is dynamic cursor?gives syntax for this?
Is ibm db2 free?
What is iseries database?
Explain various types of locks in db2?
What is load utility in db2?
can any one expalin check point with an example?