Search found 14 matches

by srini1508
Mon Dec 26, 2011 6:36 pm
Forum: JCL
Topic: Jcl Interview qn
Replies: 2
Views: 2806

Jcl Interview qn

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 ...
by srini1508
Wed Oct 12, 2011 4:19 pm
Forum: VSAM - File system
Topic: SORT
Replies: 5
Views: 7953

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?
by srini1508
Wed Oct 12, 2011 4:17 pm
Forum: VSAM - File system
Topic: SORT
Replies: 5
Views: 9047

SORT

hi thanks for the reply..

my question is like is there any diffference in SORTING of normal file and a VSAM file?
by srini1508
Wed Oct 12, 2011 1:40 pm
Forum: DB2 INTERVIEW QUESTIONS
Topic: DB2 test-1 with answers
Replies: 5
Views: 7774

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
by srini1508
Wed Oct 12, 2011 1:29 pm
Forum: VSAM - File system
Topic: SORT
Replies: 5
Views: 7953

SORT

can anyone pls advise me how to SORT a VSAM file?
by srini1508
Tue Oct 11, 2011 7:04 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 CURSOR
Replies: 3
Views: 5058

DB2 CURSOR values

that's where you have mistaken, it wont assign any values to the host variables during OPEN CURSOR.
by srini1508
Tue Oct 11, 2011 4:49 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 CURSOR
Replies: 3
Views: 5058

DB2 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?
by srini1508
Tue Oct 11, 2011 4:39 pm
Forum: JCL
Topic: SORT on Variable file
Replies: 2
Views: 4172

SORT on Variable file

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?
by srini1508
Tue Oct 11, 2011 4:22 pm
Forum: JCL
Topic: RESTART
Replies: 1
Views: 2340

RESTART

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.
by srini1508
Tue Oct 11, 2011 4:06 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: SQL query column functions
Replies: 2
Views: 4545

thanks for ur quick response .. i got the answer --- NULL
by srini1508
Tue Oct 11, 2011 4:03 pm
Forum: COBOL INTERVIEW QUESTIONS
Topic: VARIABLE FILE IN COBOL
Replies: 5
Views: 9221

VARIABLE FILE IN COBOL

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.?
by srini1508
Tue Oct 11, 2011 3:56 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: SQL query column functions
Replies: 2
Views: 4545

SQL query column functions

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
by srini1508
Fri Sep 30, 2011 7:08 pm
Forum: COBOL INTERVIEW QUESTIONS
Topic: 88 Level default value
Replies: 2
Views: 6255

Thanks..
by srini1508
Fri Sep 30, 2011 4:42 pm
Forum: COBOL INTERVIEW QUESTIONS
Topic: 88 Level default value
Replies: 2
Views: 6255

88 Level default value

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)