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
 

 

Columns not matching while loading

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
chennai

New User


Joined: 12 Jun 2008
Posts: 26
Location: chennai

PostPosted: Tue Jul 28, 2009 2:57 pm    Post subject: Columns not matching while loading
Reply with quote

Hi,
I have a table with 4 which recently updated the table with 5 columns..now I need to test the table...I unloaded the table data(which contains only 4 columns information) from production..if I try to load the data in development table(which is modified with 5 columns) with that file will the job be successful...?

Asked me in interview question...
Thanks
ajay
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Jul 28, 2009 3:07 pm    Post subject:
Reply with quote

The idea of interview questions is that you answer them and the forum members help you if you have problems.

Please give us your answer.
Back to top
View user's profile Send private message
bhairon singh rathore

New User


Joined: 19 Jun 2008
Posts: 91
Location: banglore

PostPosted: Thu Jul 30, 2009 11:59 am    Post subject: Reply to: Columns not matching while loading
Reply with quote

A whole lot of things depends for you to answer this question
1) Is new column in DEV is nullabe field
2) How is your insert query used ..

Please specify all this condition
Back to top
View user's profile Send private message
chennai

New User


Joined: 12 Jun 2008
Posts: 26
Location: chennai

PostPosted: Mon Aug 03, 2009 12:29 pm    Post subject: Reply to: Columns not matching while loading
Reply with quote

we run the loading of the table using JCL...I dont get u why u r talking abt Insert command...I have a file with 4 colums...and I am tring to load to a table of 5 columns...assume that 5th column is not null..then if I try to load what would happen...
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Mon Aug 03, 2009 12:40 pm    Post subject:
Reply with quote

Hello Chennai,

Is 5th column is defined as nOt null with default value?If yes it will contain default value for all the existing rows.
Back to top
View user's profile Send private message
chennai

New User


Joined: 12 Jun 2008
Posts: 26
Location: chennai

PostPosted: Mon Aug 03, 2009 1:25 pm    Post subject:
Reply with quote

oh ...ok thanks ...you mean there will not be any abend if I execute the job...hope my understanding is correct
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts loading a Modified Mapset Susanta CICS 2 Tue Mar 14, 2017 5:43 pm
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts Matching and unmatching records scdinesh DFSORT/ICETOOL 11 Tue Feb 07, 2017 12:41 am
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts Matching with Key at different postions. rajatbagga DFSORT/ICETOOL 12 Wed Nov 09, 2016 10:58 am


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