View previous topic :: View next topic
|
Author |
Message |
ram_vizag
Active User
Joined: 21 Aug 2008 Posts: 112 Location: hyd
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3049 Location: NYC,USA
|
|
|
|
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 |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
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 |
|
|
|