Question { IBM, 5962 }

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS
USED IN FILES CONCEPT? HOW DO WE USE IT?

Answer

We use Null Indicator to fetch the Null Values from the
database through the application Program.
If we don't mention Null Indictor, in that case Null Values will not be retrieved by application program.


THANKS

Question { Cap Gemini, 4272 }

How can you display the current date & current time ?

Answer

SELECT CURRENT DATE, CURRENT TIME FROM SYSIBM.SYSDUMMY1;

Question { IBM, 10516 }

what is the use of aix in vsam why do we go for aix and wht
is build index in vsam?

Answer

Hi...........

we use AIX to extend the limit of Keys.

Suppose i have following records with key(5,0)

00001 Ravindra Uttaranchal
00002 Reena Uttaranchal

And We got new records from Client as following

00001 Manmohan New Delhi
00002 Gaurav New Delhi

So there may be confliction
To resolve this we create AIX on KSDS/ESDS.

Thanks & Regards.

Question { IBM, 10516 }

what is the use of aix in vsam why do we go for aix and wht
is build index in vsam?

Answer

Sorry I mistaken.
I given wrong answer.

Question { Fidelity, 9954 }

what is the difference between vsam and dataset how do u
create vsam dataset which file you r used?

Answer

Hi....................

Vsam is a collections of 4 types of files(KSDS,ESDS,RRDS,LDS)
which can be accessed Sequentialy,Randomly & Dynamicaly.

While Dataset can be a Type of VSAM, QSAM OR NON-VSAM.


THANKS.

Question { IBM, 12228 }

By seeing the file itself how can we identify whether it is
A vsam file or flat file

Answer

Hi..............
Sweta & Rajeev.
Please read the question carefully.
He is saying 'By seeing the file we have to identify the
type of file'

It's mean we can't give any command.


I think it may possible through tools.

Thanks & Regards.

Question { IBM, 12228 }

By seeing the file itself how can we identify whether it is
A vsam file or flat file

Answer

Hi...........Ananth.

I think it's installation defined.

In the right hand side of the file
it gives some info...like volume serial no.

we can change it to file type.


Thanks & Regards.

Question { IBM, 23527 }

the command to open a dataset directly from the JCL instead
of opening it separately using 3.4 option.

Answer

Hi................

U can also open a file using dslist
as following.

DSLIST 'COOL.TOP.JCL'


Thanks.

Question { 7141 }

Can a Db2 table data be retrived through JCL?

Answer

Hi...............

Use the Following jcl to retrived the Db2 table data.

//SYSREC00 DD DSN=COOL.UNLOAD.SYSREC02,
// UNIT=SYSDA,SPACE=(32760,(1000,500)),DISP=(MOD,CATLG)
//SYSPUNCH DD DSN=COOL.UNLOAD.SYSPUNC1,
// UNIT=SYSDA,SPACE=(800,(15,15)),DISP=(MOD,CATLG)
//SYSIN DD *
SELECT * FROM SYSIBM.SYSTABLES WHERE OWNER = 'COOL123';
/*
//


THANKS

Question { IMS, 8353 }

My JCL has 4 steps that execute PROC’s P1, P2, P3 and P4 as
shown below

//P1 EXEC PROC=P1
//P2 EXEC PROC=P2
//P3 EXEC PROC=P3
//P4 EXEC PROC=P4

There are four steps S1, S2, S3 and S4 in each PROC’s (i.e.
P1, P2, P3 and P4)

I want to execute only step S2 of PROC P2 and no other
steps or PROC’s. How do you achieve this?

Answer

Hi...........
We can do like dis:

//COOLJCL JOB NOTIFY=&SYSUID,RESTART=P2.S2
//P1 EXEC PROC=P1
//P2 EXEC PROC=P2
//

WE NEED ALSO TO CODE COND PARAMETER FOR S3,S4
LIKE THIS

//S3 EXEC PGM=PGM1,COND=(0,LE)
//S4 EXEC PGM=PGM2,COND=(0,LE)

THIS WILL CAUSE EXCUTION OF JOB WILL START FROM
S2(STEP) OF P2(PROC) AND THAN REMAINIG STEP(S3,S4)
WILL BYPASS.

THANKS
REGARDS
RAVINDRA BISHT

Question { 5497 }

I have 255 procedures in a job, each procedure contain 2
steps.can we execute this job?

Answer

It's not possible b'coz a jcl contain max 255 steps.
acording to the question this job will contain 510 steps.
That is impossible for a particular job.

Question { IBM, 7410 }

ihave ten flatfile in that iwant to concatinate all the
files except file 5,6 into output file by uing jcl?
how to do this? give me detail yntax for tis?

Answer

Hi...........
We can do it as following.

//COOLJCL JOB NOTIFY=&SYSUID
//STEP1 EXEC PGM=IEBGENER
//SYSPRINT DD SYSOUT=*
//SYSUT1 DD DSN=COOL.TOP.PS1,DISP=SHR
// DD DSN=COOL.TOP.PS2,DISP=SHR
// DD DSN=COOL.TOP.PS3,DISP=SHR
// DD DSN=COOL.TOP.PS4,DISP=SHR
//* DD DSN=COOL.TOP.PS5,DISP=SHR
//* DD DSN=COOL.TOP.PS6,DISP=SHR
// DD DSN=COOL.TOP.PS7,DISP=SHR
// DD DSN=COOL.TOP.PS8,DISP=SHR
// DD DSN=COOL.TOP.PS9,DISP=SHR
// DD DSN=COOL.TOP.PS10,DISP=SHR
//SYSUT2 DD DSN=COOL.TOP.OUTPUT,DISP=SHR
//SYSIN DD DUMMY



We can give comments for 6th and 7th dd statement
through which we can concatenate the remaining files
except 5,6 file into the output file.


I know there is also some other logic
except this.
if anybody know than tell me.
thanks.

Question { 5331 }

proc1,proc2,up to proc5 is there if i want to call proc1 and
proc5how can u write the code

Answer

Hi..............
we can call proc as following.

//COOLJCL JOB NOTIFY=&SYSUID
//PROCFILE JCLLIB ORDER='PROCEDURE-FILE-NAME'
//STEP1 EXEC PROC1
//SYSPRINT DD SYSOUT=*
.
. * OVERRIDE STATEMENT
.
//STEP2 EXEC PROC5
.
. * OVERRIDE STATEMENT
.
//

THANKS..........

Question { 6191 }

Shall i use this query to retrieve first 4 records,

Select empno, sal from emptbl where empno < 5. like this can
we fetch first 100 records?

Answer

Hi.............

No. you cann't use this.
this query will display records less than 5.
not to for first 4 records.

For exm.
Suppose i have duplicate records like
Empno
1
2
1
1
3
4
then it display all the above records.
b'coz these all r less than 5.


Thanks.

Question { 4235 }

How system will identify whether user wants to create PS or
PDS? If answer is SPACE parameter then why we need to pass
ps or po as dataset organisation while creation

Answer

Hi.............
It's not mandtory to pass ps or po organization.

System will automatically decide organization for
a data set according to the directory Block.

If diectory block is 0 or not mantion than it's ps
else it's pds/po.

Thanks