Increase the column length and upload db2 table

venkatm99 · New User Joined: 01 Jun 2006 Posts: 23 Location: Sinagpore

Hi,

I have a table A.

col1 - lenght dec(4,0)
col2 - lenght dec(2,0)
col3 - lenght dec(3,0)

I need to change the col1 length from 4 to 6.Iam unloading the table A data. Drop and recreate the table A with col1 length as dec(6,0).

But while uploading the table A, i hv a problem coz length of col1 in syspunch is 4.In my new table col1 length is dec(6,0).

How to upload the data into the new table ?

Thanks in Advance

Anuj Dhawan · Posted: Tue Oct 21, 2008 10:07 am

Hi,

How do you "upload" your table, using BMCADM ?

vini_srcna · Posted: Tue Oct 21, 2008 10:27 am

1. you could have unloaded data as DEC(6,0). Its not UPLOAD. It sounds good to say LOAD.!!

I would say load back the data and again unload data as dec(6,0). I dont know if there are otherways to convert the data.

venkatm99 · New User Joined: 01 Jun 2006 Posts: 23 Location: Sinagpore

Hi vini_srca

How to unload the data as dec(6,0) when the coloumn lenght is dec(4,0)?

venkatm99 · New User Joined: 01 Jun 2006 Posts: 23 Location: Sinagpore

@ Anuj ,

We are using "IKJEFT1A" to "load" the data.

Anuj Dhawan · Posted: Tue Oct 21, 2008 3:09 pm

I'm not on Mainframes, so can't check how to do it with IKJEFT1A. However, you can try two options..

1. If you have QMF, load a records using QMF in the new table (one with length 6)
2. Unload this new value, this will give a Load card with desired length.

And, this process seems to be an ad-hoc requirement, if so, you can edit the SYSPUNCH values, update it & use for new table.