Now I have problem specifying NULL indicator while uploading data into LUW.
In LUW the load utility syntax as follows :
Code:
load from D:\db2V11Express\load\department.txt of asc method l modified by striptblank nullindchar=x'FF' (1 3,4 34,36 41,42 44,46 61) null indicators (0,0,35,0,45)
insert into DEPARTMENT;
But as per db2luw 11.1 manuals
Quote:
nullindchar must specify symbols included in the standard ASCII set between code points x20 and x7F
which means I cannot mention x'FF' while loading data into table.
Is there any way to specify values between code points x20 and x7F as null indicator in unloaded data in z/Os unload utility DSNUTILB.
I have an other method as optional of creating a dynamic sort card with the use syspunch output to overlay X'FF' with ASCII set between code points x20 and x7F, but reading and editing all the downloaded code with take much time and cpu.
Please help me out, if there is a way to specify null values indicator other than x'FF' in unloaded file thru utility itself.
Thanks for the replay, When I read LUW load manuals I found below.
Quote:
If there is a Y in the column's null indicator position for a given record, the column will be NULL. If there is an N, the data values in the column's data positions of the input record (as defined in L(........)) are used as the source of column data for the row.
or we can use nullindchar to specify the null indicator
Quote:
nullindchar must specify symbols included in the standard ASCII set between code points x20 and x7F
So, when I unload using DSNUTILB I get X'FF' in my file to specify the columns as NULL or not.
If I want to just upload without doing any changes to my data I need to use nullindchar=x'FF' in my LUW load statement - but nullindchar will not accept X'FF'
otherwise, I need to edit data X'FF' overlay with Y or N or other valid nullindchar between X20 and X7F.
Goal is I need a way to upload data into LUW without having to edit the data.
That is I need to change the null indicator during DSNUTILB itself.
Please correct me if I am missing any other options of nullindcahr from LUW manuals, kindly let me know if there are any other options.