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
 

 

LOAD a hard coded value in SYSPUNCH

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Daniel Prosser

New User


Joined: 05 Nov 2010
Posts: 41
Location: Amsterdam

PostPosted: Fri Nov 09, 2012 7:52 pm    Post subject: LOAD a hard coded value in SYSPUNCH
Reply with quote

Hi,

I have what I think must be a pretty simple request, yet I'm finding it hard to get it done.

I have changed a table definition - added a sequence number to the primary identifier.

I want to load the data (from the old definition) and assign the value 1 to this sequence number.

I know I could SORT the data and add in the value 1 for the SYSP to pick up which will work fine, but it is going to get much more complicated when I have to load the child tables so I would rather try and do it within the LOAD syspunch.

Is it possible?

Dan. icon_rolleyes.gif
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Nov 12, 2012 10:52 am    Post subject:
Reply with quote

Hi Dan,

Loading a constant value into a column in DB2 table using a standard load utility is not possible. But, if you have "Utilities Enhancement Tool V2.1", its possible. Check this link.

If you have BMC Load utility, you can specify the below(VALUE option) in the field specification.
Code:
,ACTIVITY_FLAG  VALUE('I')     


Thanks,
Sushanth
Back to top
View user's profile Send private message
Daniel Prosser

New User


Joined: 05 Nov 2010
Posts: 41
Location: Amsterdam

PostPosted: Mon Nov 12, 2012 1:19 pm    Post subject:
Reply with quote

Thanks Sushanth, I guess I'll be sorting the file.
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 Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Copybook structure in Load module Vai123 COBOL Programming 7 Fri Sep 16, 2016 8:29 pm
This topic is locked: you cannot edit posts or make replies. ERROR WHILE SUBMITTING LOAD JOB ANURADHA NEELAKANTAN JCL & VSAM 12 Thu Aug 25, 2016 11:50 am
No new posts Execute multiple DB2 Load commands in... faizm DB2 4 Wed Aug 03, 2016 12:53 pm


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