|
|
| Re: Urgent : Setting Null value of a COBOL variable [message #93790 is a reply to message #93657] |
Mon, 20 January 2003 08:56  |
Thotakura
Messages: 9
Registered: January 2003
|
Junior Member |
|
|
Yes,
U can set null values. for that u have to pass an indicator variable along with the host variable.
if that indicator value is '0' then the value of that coloumn will be set to NULL and it will ignore the value in the host variable.
ex:
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR hostvar;
int indvar;
EXEC SQL END DECLARE SECTION;
EXEC SQL INSERT INTO SOMETABLE VALUES(:hostvar,:indvar);
if u have any problem with this mail me
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
