How to resolve -407 sql code in DB2?
- 9 Answers
- 29542 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vikram and mangesh
yes but what are the different ways to resolve this
error.where will we check???
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / sathish kumar.b
hi.............
while retrieving data if any null values found in this
case -407 will occur.
how to resolve -407 is declare the null indicator variables.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / king
This error occures when you are assigning NULL value to NOT
NULL column.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / lu
u have to check in DCLGEN if this column is null or not.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / vishal
The Error is not -407 for Null indicator but it is -307.
It should be handled carefully using host varaible in Pgm.
| Is This Answer Correct ? | 0 Yes | 1 No |
Mention the definition of cobol in varchar field.
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
How can we retrieve the total number of records in RPG & CLLE?
How to execute stored procedure in db2 command editor?
What parameters are used to control the free space in DB2?
What is the latest version of ibm db2?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
Differentiate between cs and rr isolation levels? Where do you specify them?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What is alias in db2?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What is db2 optimizer?
COBOL 
