1. what if null values retrived from database and no null
indicator mentioned in query. What is sql code.
Answer / santy
we will get the sql code "-305".
-305:- The NULL value cannot be assigned to output host
variable number because no indicator variable is specified.
| Is This Answer Correct ? | 8 Yes | 0 No |
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
If I have a view which is a join of two or more tables, can this view be updateable?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What are the contents of a DCLGEN?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
Mention the location where the output received from explain statement is stored.
Is it possible to precompile if db2 goes down?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
What is the syntax for creating a table in the db2 database?
What is a view? Why use it?
What are the abend codes occour in ur latest PROJECT in DB2
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?