Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Clarification in SYSIN card parameter for load utility

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Khwairakpam Raju Singh

New User


Joined: 05 Dec 2007
Posts: 29
Location: Bangalore

PostPosted: Tue Jun 14, 2011 1:48 pm    Post subject: Clarification in SYSIN card parameter for load utility
Reply with quote

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
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1722
Location: UK

PostPosted: Tue Jun 14, 2011 2:47 pm    Post subject:
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Jun 14, 2011 3:48 pm    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Tue Jun 14, 2011 3:55 pm    Post subject: Reply to: Clarification in SYSIN card parameter for load uti
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DDNAME parameter mistah kurtz JCL & VSAM 6 Mon Dec 19, 2016 4:41 pm
No new posts Execessive parameter issue Sumeendar JCL & VSAM 5 Mon Dec 19, 2016 4:35 pm
No new posts TAPE VERIFY utility?? MrExtraordinare JCL & VSAM 3 Fri Dec 09, 2016 10:57 pm
No new posts TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
This topic is locked: you cannot edit posts or make replies. How to use 2 input files in control c... Gunapala CN DFSORT/ICETOOL 23 Thu Oct 13, 2016 3:42 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us