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
 

 

BMC Unload/Load issue

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
alluri12

New User


Joined: 15 Aug 2006
Posts: 44
Location: Virginia, USA

PostPosted: Wed Jun 04, 2008 9:46 am    Post subject: BMC Unload/Load issue
Reply with quote

Hi,
I am having problem in unload and load process
Before unload
I had a table abcd with
col1 char(4) not null with default
col2 char(3) not null with default
col3 char(3) not null with default
col4 varchar(49) not null with default
TABLE EFGH
col1 char(4) not null with default
col2 char(3) not null with default
col3 char(3) not null with default
col4 char(9) not null with default
col5 char(10) not null with default
col6 char(10) not null with default

All these days I tried to unload data from ABCD table and used to
load replace data into EFGH table. It worked fine.

But now due to new requirements we got to ALTER the table to add 4
new columns to both the tables ABCD and EFGH.
Now the new table looks like

I had a table abcd with
col1 char(4) not null with default
col2 char(3) not null with default
col3 char(3) not null with default
col4 varchar(49) not null with default
col5 char(3) nulls with default
col6 char(3) nulls with default
col7 char(3) nulls with default
col8 varchar(50) nulls with default
TABLE EFGH
col1 char(4) not null with default
col2 char(3) not null with default
col3 char(3) not null with default
col4 char(9) not null with default
col5 char(10) not null with default
col6 char(10) not null with default
col7 char(3) nulls with default
col8 char(3) nulls with default
col9 char(3) nulls with default
col10 varchar(50) nulls with default

I tried to unload data from abcd.what is happening is if the col4 varchar(49)
has data until 30 bytes and remaining is spaces, then data from col5, col6,
col7 and col8 coming into this spaces. Because of that i am not able to load the data
into other table. The error i am getting is
BMC51502E FIELD 'COL7' EXTENDS BEYOND END-OF-RECORD, START POSITION = 66
END POSITION = 69, RECORD NO. 1 OF SYSREC01, LENGTH = 68
Table abcd has data
Code:
col1 col2 col3 col4                                             col5 col6 col7 col8
1111 033  109  035200902033106010MIMIGUELO01                    ...? ...? ...? ..?         
1111 033  109  035200902033106010MIMIGUELO01AAABBB11122233344455...? ...? ...? ..?   


This is the unloaded data
Code:
1111033109035200902033106010MIMIGUELO01...?...?...?..?
1111033109035200902033106010MIMIGUELO01AAABBB11122233344455...?...?...?..?


The unloaded data i am expecting is
This is the unloaded data
Code:
1111033109035200902033106010MIMIGUELO01                    ...?...?...?..?
1111033109035200902033106010MIMIGUELO01AAABBB11122233344455...?...?...?..?


Could anybody please help me in getting the expected output to load into the other table
Code:
Back to top
View user's profile Send private message

Santoshdorge

New User


Joined: 27 Jun 2006
Posts: 48
Location: Pune

PostPosted: Wed Jun 04, 2008 10:55 am    Post subject:
Reply with quote

Hi Alluri,
My Primary guess is atfer altering the table abcd you don't have the proper values in the newly added columns due to 'with default' caluse.
You may need to initialize all newly added column according to the data type. And then try unload the same and loading into EFGH table.

Thanks,
Santosh.
Back to top
View user's profile Send private message
alluri12

New User


Joined: 15 Aug 2006
Posts: 44
Location: Virginia, USA

PostPosted: Wed Jun 04, 2008 7:13 pm    Post subject:
Reply with quote

Hi Santhosh
This has nothing to do with the initializing. We are expecting nulls new the new columns. The actual problem is at varchar, just before the new column starts i.e at col4. If the data in the VARCHAR is less than 49 and it has spaces after that then the new column data i.e col5 data is coming into that. This messes up when u try to load data into other table.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    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 Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
No new posts Execessive parameter issue Sumeendar JCL & VSAM 5 Mon Dec 19, 2016 4:35 pm
No new posts DFHRESPONSE returns issue divated CICS 3 Wed Nov 02, 2016 6:32 pm
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm


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