Interview Questions ..Please Reply

shashi · New User Joined: 10 Mar 2005 Posts: 8

Hello Here are a few interview questions..
1)How d u code SQL codes/logic in BATCH?/in CICS?
2)How do u code a CICS-COBOL-DB@ prog?
3)In the middle of a fetch routine a commit command is encountered ?Wat will happen t the fetch routine?
4)How 2 know the other person's job status?
5)Wat will happen if th esubroutine is caled the second time?
6)Wat will b the initial position of the cursorof the execution of open statements.
7)Wat r LOW VALUES and HIGh VALUES?

Waiting 4 ur reply...

ovreddy · Posted: Wed Mar 23, 2005 7:17 pm

Hi,

For 1) and 2) down load the programs available in programs.ibmmainframes.com

3 Ans: Commit will close the Cursor, so Fetch will be failed. If you want the cursor still opened even after using Commit, then you must code WITH HOLD option.

4 Ans: Go to SPOOL =SD.ST from ISPF main menu.

Type PRE ID* ( ID is other persons id) or
OWNER ID
5 Ans. That will be executed normally. Nothing will happen.

6. Before first record.

7. LOW VALUES Represents one or more occurrences of the character that has the lowest ordinal position in the collating sequence used. For the EBCDIC collating sequence, the character is X'00'.

LOW-VALUE is treated as an alphanumeric literal.

HIGH-VALUE, HIGH-VALUES
Represents one or more occurrences of the character that has the highest ordinal position in the collating sequence used. For the EBCDIC collating sequence, the character is X'FF'.

HIGH-VALUE is treated as an alphanumeric literal.

Thanks,
Reddy.