mainframegurukul.com

I have faced a interview qn for infy as below i have to write a JCL which will contain some steps and the steps has to execute based on the current day. like suppose if monday execute step 1 and tuesday step 2 like so on.. how i can write a JCL? i have answerd as below pls correct me if im wrong in ...

hI MrSpock,

Thanks for the reply,

could u pls let me know if there is any difference in the SORT process of normal file with the VSAM file?

hi thanks for the reply..

my question is like is there any diffference in SORTING of normal file and a VSAM file?

7) How do you retrieve the first 5 characters of FIRSTNAME column of DB2 table EMP ?

a) FIRSTNAME(SUBSTR)
b) FIRSTNAME(SUBSTR,1,5)
c) SUBSTR(FIRSTNAME,1,5)
d) SUBSTR(1,5,FIRSTNAME)


the answer would be C not D

can anyone pls advise me how to SORT a VSAM file?

that's where you have mistaken, it wont assign any values to the host variables during OPEN CURSOR.

i have declare cursor statement and i opened it and fetched the records in to working storage variables which are not initialised.

what will be the default value stored in these host variables during the time of OPEN CURSOR?

hi can some one please let me know how to give the sort card for sorting a a VARIABLE RECORD LENGTH FILE based on the first 10 characters in ASC order?

Hi i faced a interview question as below

i have a job with two procs --

//Job

//proc1


//proc2

in proc2, there r 2 steps.

//proc2

//step1

//step2

if the job abends in step2 of proc2 , what is the syntax for rerunning the abend job from abended step?

Please let me know.

thanks for ur quick response .. i got the answer --- NULL

Hi,

I faced a interview question as below

how would you set the variable record length and what is the use of defining file as variable length format.

can any one please reply me what is the gud way to answer to this question.?

Hi,

I faced a interview question as belwo.

in a database i need to fetch a a record SALARY from a database SAL TABLE for a employee RAVI. but RAVI is not there in the database, so what will happen to the given SQL QUERY

select MAX(SALARY) from SAL where empname = 'RAVI'

??

pLESE LET ME KNOW

Thanks..

I have faced an interview qn as below

01 city pic x(4)
88 valid-city value 'cata'
88 invalid-city value 'xyz'


what is the default value stored in city field ( note city is not initialised)