Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 2 Sun Nov 06, 2016 8:11 pm
No new posts Joinkeys operation when key1 and key2... Susanta DFSORT/ICETOOL 5 Wed Nov 02, 2016 5:35 pm
This topic is locked: you cannot edit posts or make replies. Checking wether a string starts from ... sundaram.naveen CLIST & REXX 9 Thu Oct 06, 2016 11:56 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us