Khwairakpam Raju Singh New User Joined: 05 Dec 2007 Posts: 29 Location: Bangalore
I am trying to load a table using DSNUTILB utility. The requirement is, the input file has only one record. That record has to be added without deleting existing rows in the table. I am using following SYSIN card.
LOAD DATA RESUME YES
INTO TABLE qual.table_name
WHEN(00001:00002) = X'0023'
POSITION( 00003:00004) CHAR(00002)
POSITION( 00005:00008) CHAR(00004)
POSITION( 00009:00012) CHAR(00004)
POSITION( 00013:00020) CHAR(00008)
POSITION( 00021:00046) TIMESTAMP EXTERNAL
POSITION( 00047:00304) VARCHAR
Here is my question:
Q1. What is the meaning of EBCDIC CCSID(00037,00000,00000).
Q2. Is there any possible error in the SYSIN card, I want to confirm it as I can not test the code in test enverontment as of now.
Nic Clouston Global Moderator Joined: 10 May 2007 Posts: 2002 Location: UK
And why is this in JCL and not DB2? You have not mentioned ANYTHING to do with JCL at all apart from the fact that these cards are input via the SYSIN ddname.
Regarding CCSID the manual should explain what is happening there.
expat Global Moderator Joined: 14 Mar 2007 Posts: 8657 Location: Back in jolly old England
As for not testing, that is the worlds worst thing to do is to ask someone a question like that.
Something might work perfectly on my system but go belly up on yours.
enrico-sorichetti Global Moderator Joined: 14 Mar 2007 Posts: 10457 Location: italy
IMHO just to insert a row into an existing table a SPUFI or a DSNTEP2/4
should be more than enough
All times are GMT + 6 Hours