Adding a new column to an existing table what will be the im



Adding a new column to an existing table what will be the im

Postby karthi_ind » Tue Nov 04, 2008 2:45 pm

Hi All,

The following are the questions which have been asked in one of the interview

1. There are 'n' no. of fields in a table and by using file-aid we need to view only 2 fields (columns) in that
table. How to view that ?

2. If we are adding a new column to an existing table what will be the impact ? How can we identify that ?

3. Is there any skip command which we can use in the jobcard for skipping a particular step while executing.
I came to know this in one of the interview. Please explain about this command.

Thanks in advance...

Karthik
karthi_ind
 
Posts: 12
Joined: Tue Nov 04, 2008 2:37 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Adding a new column to an existing table what will be the im

 

Re: Adding a new column to an existing table what will be the im

Postby dick scherrer » Wed Nov 05, 2008 3:57 am

Hello Karthik and welcome to the forum,

1. I don't have FileAid for db2, but i would imagine you would select only those 2 columns.

2. The impact to programming code? If the table is properly designed/defined, only code that uses the new column(s) need be impacted. Existing code should run as-is.

3. "I came to know this in one of the interview." If you post the command you learned of, someone here will be able to clarify.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Adding a new column to an existing table what will be the im

Postby karthi_ind » Wed Nov 05, 2008 12:10 pm

Hi disk,

Thanks for your reply for my questions. but my questions are

1. In file aid for Db2 how to view only selected columns from the table ?

2. Can't we generate the DCLGEN again, Is it required ? Can't we recompile all the programs using
the table if DCLGEN has been generated again.

3. I asked about Skip command in JCL. In the interview he told there is a skip command which can be
used for skipping the steps. I want to know is there any such command available in jcl ?

Thanks.
karthi_ind
 
Posts: 12
Joined: Tue Nov 04, 2008 2:37 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Adding a new column to an existing table what will be the im

Postby dick scherrer » Wed Nov 05, 2008 1:19 pm

Hello,

1. my answer remains the same
but i would imagine you would select only those 2 columns.

unless this is a trick question and you cannot do that. . . maybe someone who has fileaid for db2 will reply.

2. i read your post as a programmer/developer set of interview questions.
Can't we generate the DCLGEN again, Is it required ?
Yes, this would be something the dba would do (rather than the developer).

3. there are multiple ways to control which steps exdecute when a job is submitted. . .
I asked about Skip command in JCL.
And i told you to post the command you learned of. There is no SKIP command in JCL. If you more clearly explain what this about, someone may be able to offer additional detail.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Adding a new column to an existing table what will be the im

Postby Bill Dennis » Wed Nov 05, 2008 7:42 pm

Perhaps karthi came to know of the question during an interview, not the solution.

One method is the COND.stepname=ONLY parameter so the step is bypassed, unless the JOB happens to ABEND first! Not very reliable.
Regards,

Bill Dennis

Disclaimer: My comments on this forum are my own and do not represent the opinions or suggestions of any other person or business entity.
Bill Dennis
 
Posts: 278
Joined: Thu May 15, 2008 9:45 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Adding a new column to an existing table what will be the im

Postby karthi_ind » Thu Nov 06, 2008 12:24 pm

Thanks Dick and Bill.
karthi_ind
 
Posts: 12
Joined: Tue Nov 04, 2008 2:37 pm
Has thanked: 0 time
Been thanked: 0 time


Return to Interview Questions

 


  • Related topics
    Replies
    Views
    Last post