View previous topic :: View next topic
|
Author |
Message |
raman.k
New User
Joined: 26 Feb 2007 Posts: 24 Location: chennai
|
|
|
|
Hi
how to set the null value in perticular field?
bye |
|
Back to top |
|
|
bhaskar80
New User
Joined: 12 Apr 2007 Posts: 7 Location: bangalore
|
|
|
|
Dear Ramana,
move -1 to null indicator field which is associated with ur host variable. so that column value is set to null. |
|
Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Hi ramana,
I never came across this equirement, even though i know it theriotically, can u please explain me, in which situation u face this probelm.
Thanks in advance. |
|
Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
Check the below one if it makes some sense...
1. This is just to understand DDL:
INSERT INTO REXXTEST (USERID, ROW_NO, "NAME")
VALUES (
-- ENTER VALUES BELOW COLUMN NAME DATA TYPE LENGTH NULLS
, -- USERID CHAR 8 NO
, -- ROW_NO INTEGER NO
) -- NAME CHAR 20 YES
*** END ***
2. INSERT INTO REXXTEST VALUES('A',6,NULL)
3. UPDATE REXXTEST SET NAME = NULL
4. if its with embedded SQL
NAME_IND = -1
EXEC SQL
UPDATE REXXTEST SET NAME = :MYNAME :NAME_IND ;
Hope this is self explanatory. Let me know if you have anymore questions. |
|
Back to top |
|
|
|