|
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: 3109
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: 2482
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 |
|
|
|
|
