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 |
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
How to resolve -504 sql code in DB2?
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 utility for parm lib
wt is view ? wht r the restrictions for view ?
Explain the benefits you can get from mainframe connect?
cobol-db2 runjcl please?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
The only place of VSAM KSDS in DB2 is?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What is DCLGEN ?
Can I use LOCK TABLE on a view?