|
View previous topic :: View next topic
|
| Author |
Message |
germanyrajesh
New User
Joined: 09 May 2023
Posts: 17
Location: Norway
|
|
|
|
Hi,
There exist table with 5 columns and data in it.
I need to add a new column in between not at the end. Before DROP/RE-CREATE. I have taken the copy and unload of the table.
Now, new column has been added to the table. Total number of columns is 6.
However, what is the easiest and best way to load back the data into the new table using unload which was taken before the changes.
New column (CHAR - datatype) should have default value SPACES.
Thanks |
|
| Back to top |
|
 |
Pete Wilson
Active Member
Joined: 31 Dec 2009
Posts: 582
Location: London
|
|
|
|
| You may be able to modify a copy ofthe unload data to match the requirement using DFSORT |
|
| Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada
|
|
|
|
| If the new column is not null with default, all you need to do is use LOAD utility control cards that match the old data. |
|
| Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada
|
|
|
|
| If the new column is not null with default, all you need to do is use LOAD utility control cards that match the old data. |
|
| Back to top |
|
|
germanyrajesh
New User
Joined: 09 May 2023
Posts: 17
Location: Norway
|
|
|
|
| don.leahy wrote: |
| If the new column is not null with default, all you need to do is use LOAD utility control cards that match the old data. |
Thank you  |
|
| Back to top |
|
|
germanyrajesh
New User
Joined: 09 May 2023
Posts: 17
Location: Norway
|
|
|
|
| don.leahy wrote: |
| If the new column is not null with default, all you need to do is use LOAD utility control cards that match the old data. |
Thank you |
|
| Back to top |
|
|
germanyrajesh
New User
Joined: 09 May 2023
Posts: 17
Location: Norway
|
|
|
|
| Pete Wilson wrote: |
| You may be able to modify a copy ofthe unload data to match the requirement using DFSORT |
Thank you |
|
| Back to top |
|
|
|
|
