IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

can we hardcode a value in db2 load card instead of position


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ram_vizag

Active User


Joined: 21 Aug 2008
Posts: 112
Location: hyd

PostPosted: Wed Feb 28, 2018 11:04 pm
Reply with quote

HI All,

Can we hard code a value instead of giving position?

I have a input file which needs to be loaded into a db2 table of which only few columns to be loaded from file and remaining columns to be hard coded( instead of mentioning starting/ending positions of input file) ?

is this possible and may I know how?
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2567
Location: NYC,USA

PostPosted: Thu Mar 01, 2018 1:01 am
Reply with quote

Quote:
I have a input file which needs to be loaded into a db2 table of which only few columns to be loaded from file and remaining columns to be hard coded( instead of mentioning starting/ending positions of input file) ?


Can you not able to produce the load DS by using DFSORT , just take the input and BUILD it according to your syspunch and do a load?
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Thu Mar 01, 2018 1:54 am
Reply with quote

ram_vizag wrote:
is this possible and may I know how?
Ram,

Take a look at the CONSTANT keyword in the LOAD statement. This might be possible if your DB2 version allows it.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. Parsing more than 1000 columns in a s... SYNCSORT 10
No new posts Job is loading load modules several t... COBOL Programming 12
No new posts Group selective VB records - Trailer ... DFSORT/ICETOOL 16
No new posts Position BSAM file on multi volume PL/I & Assembler 3
No new posts Need help on DB2 load in Mainframe DB2 5
Search our Forums:

Back to Top