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 to create backup table in db2?
What is a predicate?
Do we need cursor for Count(*)?
When the like statement is used?
explain about index with examples
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
what is the difference between declaring the cursor in WS section and Procedure division?
Which isolation level provides highest data integrity?
Once you create a view, where would information about the view be stored?
Are views updatable ?
What is the difference between cursor and select statement?