|
View previous topic :: View next topic
|
| Author |
Message |
Daniel Prosser
New User
Joined: 05 Nov 2010
Posts: 57
Location: Amsterdam
|
|
|
|
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.  |
|
| Back to top |
|
 |
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
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 |
|
|
Daniel Prosser
New User
Joined: 05 Nov 2010
Posts: 57
Location: Amsterdam
|
|
|
|
| Thanks Sushanth, I guess I'll be sorting the file. |
|
| Back to top |
|
|
|
|
