|
View previous topic :: View next topic
|
| Author |
Message |
Khwairakpam Raju Singh
New User
Joined: 05 Dec 2007
Posts: 29
Location: Bangalore
|
|
|
|
HI All,
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.
| Code: |
LOAD DATA RESUME YES
INDDN SYSREC
LOG NO
NOCOPYPEND
EBCDIC CCSID(00037,00000,00000)
INTO TABLE qual.table_name
WHEN(00001:00002) = X'0023'
NUMRECS 137
( "Field_1"
POSITION( 00003:00004) CHAR(00002)
, "Field_2"
POSITION( 00005:00008) CHAR(00004)
, "Field_3"
POSITION( 00009:00012) CHAR(00004)
, "Field_4"
POSITION( 00013:00020) CHAR(00008)
, "Field_5"
POSITION( 00021:00046) TIMESTAMP EXTERNAL
, "Field_6"
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.
Thanks you.
Regards,
Raju Kh |
|
| Back to top |
|
 |
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2455
Location: Hampshire, 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. |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
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. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
IMHO just to insert a row into an existing table a SPUFI or a DSNTEP2/4
insert .....
should be more than enough |
|
| Back to top |
|
|
|
|
