Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Increase the column length and upload db2 table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
venkatm99

New User


Joined: 01 Jun 2006
Posts: 23
Location: Sinagpore

PostPosted: Tue Oct 21, 2008 9:06 am    Post subject: Increase the column length and upload db2 table
Reply with quote

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
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Oct 21, 2008 10:07 am    Post subject:
Reply with quote

Hi,

How do you "upload" your table, using BMCADM ?
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Tue Oct 21, 2008 10:27 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
venkatm99

New User


Joined: 01 Jun 2006
Posts: 23
Location: Sinagpore

PostPosted: Tue Oct 21, 2008 10:53 am    Post subject:
Reply with quote

Hi vini_srca

How to unload the data as dec(6,0) when the coloumn lenght is dec(4,0)?
Back to top
View user's profile Send private message
venkatm99

New User


Joined: 01 Jun 2006
Posts: 23
Location: Sinagpore

PostPosted: Tue Oct 21, 2008 10:54 am    Post subject:
Reply with quote

@ Anuj ,

We are using "IKJEFT1A" to "load" the data.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Oct 21, 2008 3:09 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts column with count of rows within dist... ronald wouterson DB2 4 Sun Sep 17, 2017 9:48 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
This topic is locked: you cannot edit posts or make replies. Selecting two copybooks of different ... Vignesh Sid COBOL Programming 8 Tue Sep 05, 2017 7:28 pm
No new posts Convert rows and column into JSON for... Dinesh Manivannan DB2 2 Sun Sep 03, 2017 6:50 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us