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 |
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
How to find last record before record through SQLRPGLE?
What is innodb buffer pool?
how do we solve soc 7 and soc4 ?
List down the data types in the db2 database.
How can you quickly find out the number of rows updated after an update statement?
Q4. How will you get the count of record without using COUNT verb in query?
How could one combine a set of incremental image copies into a single copy?
Explain the use of the WHERE clause?
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
What is an intent lock?
Mention some fields that are a part of sqlca.