NULLIF statement in a load parm dataset

bibek24 · New User Joined: 14 Aug 2007 Posts: 35 Location: Hyderabad

Hi all,

Can anybody explain the following NULL IF statement in a load parm dataset used to laod a DB2 table:

FIELD1 POSITION (655) SMALLINT
NULLIF (35:36)=X'FFFF' ,
FIELD2 POSITION (657) SMALLINT
NULLIF (37:38)=X'FFFF' ,
FIELD3 POSITION (659) CHAR (1)
NULLIF (39:40)=X'FFFF' ,

What I know is this is being added to take care of the nullable fields in the table.
What is the significance of (35:36)?

dbzTHEdinosauer · Posted: Fri Jun 13, 2008 1:01 pm

have no idea, but will guess:

FIELD1 POSITION (655) SMALLINT
NULLIF (35:36)=X'FFFF' ,

At position 655 there is a value for a SMALLINT column FIELD1, but if position 35 and 36 contains x'FFFF' then the value is to be treated as NULL.

position 35 and 36 contains the NULL Indicator for FIELD1.

bibek24 · New User Joined: 14 Aug 2007 Posts: 35 Location: Hyderabad

I have the requirement to make a field as null in a table wherever the value for the field in the load file is 0.

I mean the table has to be loaded through a load file.For a particular field ,wherever it is 0 in the file, I need to palce null for the same field in the table.

Any suggestions?

Craq Giegerich · Posted: Fri Jun 13, 2008 4:46 pm

Is the column (field) defined as nullable?

enrico-sorichetti · Posted: Fri Jun 13, 2008 4:51 pm

stop carrying on the same discussion in two threads ...
post which one You want to keep going and I' ll lock the other one

bibek24 · New User Joined: 14 Aug 2007 Posts: 35 Location: Hyderabad

Finally I got it by coding

FIELD1 POSITION (655) SMALLINT
NULLIF (655)=X'0000' ,

bibek24 · New User Joined: 14 Aug 2007 Posts: 35 Location: Hyderabad