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 Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am


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