Question { UST, 6541 }

if there is a table with huge number of records and if i
want to extract only first 3 records from the table, what
query i have to provide to retreive first 3 records

Answer

select * from table_name
order by ascending
fetch first 3 rows only

Question { DELL, 10112 }

how can we get current dat and time thru cobol pgm

Answer

USING REFERENCE MODIFICATION WE GET DATE

1) current date
move function current-date (1:8) to ws-today
here ws-today is w.s.s variable


2) current time
move function current-date (9:6) to ws-time
here ws-time is the w.s.s variable

Question { ADP, 7628 }

wt will happen to the step of a job if u code COND=ONLY

Answer

//s1 exec pgm=ex1
//s2 exec pgm=ex2
//s3 exec pgm=ex3,cond=only
//s4 exec pgm=ex4

1) if s1 executes sucess, s2 got abend ,then executes s3.and
stops execution

2) if s1 got abend, s2 dont executes ,then s3 executes.and
stops execution

3) if s1 executes sucess ,s2 executes sucess,then s3 wont
executes. and go to s4.....

if any wrong in my answer plz correct me..