Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / yuvaevergreen
IN DCLGEN,
>>"INDICATOR VARS .. ===> NO" indicates the presence of
null variables for the fields in the tables.
>>indicator variable should be declared of type s9(4) comp.
77 DAY-IND PIC S9(4) BINARY.
Move -1 to the indicator variable and use in sql.
exec sql
insert into employee(name)
values(:ws-name:ws-name-ind)
end-exec;
ws-name-ind is the indicator variable which inserts null in
the field ws-name.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How is the value function used?
Explain db2.
How do you pull up a query which was previously saved in qmf?
What is the meaning concurrency in the db2 database?
How is a typical db2 batch pgm executed?
How many types of page locks can be held in db2?
What is deadlock in db2?
What is release/acquire in bind?
What is the physical storage length of timestamp data type?
Can one database have multiple instances?
What is db2 command?
What are the uses of db2 optimizer?
What does a deadlock mean in DB2?
How can we read records for specific member in CL? AND rpg?
How will you return the number of records in table?
