IBM Mainframe Forum

[karthi_ind]

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

[dick scherrer]

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.

[karthi_ind]

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.

[dick scherrer]

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.

[Bill Dennis]

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.

[karthi_ind]

Thanks Dick and Bill.