When cursor is not closed what is the error?

Answers were Sorted based on User's Feedback



When cursor is not closed what is the error?..

Answer / prabu

-502 The cursor identified in an open statement is
already open.

Is This Answer Correct ?    4 Yes 0 No

When cursor is not closed what is the error?..

Answer / mdvasanth86

No Error.
Program completion closes the Cursor.

Is This Answer Correct ?    1 Yes 1 No

When cursor is not closed what is the error?..

Answer / ramki

We will get sql code -503

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More JCL Interview Questions

How many types we can give input to JCL

5 Answers   UHG,


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?

4 Answers   IMS,


How to skip first step of a job? Can we use COND on the first step?

3 Answers   iNautix,


State the uses of syspring, sysin, sort fields, sum fields and dummy.

1 Answers  


We have an output dataset in job with disp parameter as SHR. Can we write data in that file dataset?

2 Answers   CTS, IBM,


What is the function of //jcllib statement?

1 Answers  


How many extents are possible for a sequential file ? For a VSAM file ?

3 Answers  


What are the parameter we cannot use in procedure?

1 Answers  


I have GDG defined e.g. GDG.smaplegdg.base, after processing the GDG. it contains some records and which is input to the second step2. How can I use GDG to use it as input file at step2.

3 Answers   Wipro,


Hi, all suppose i have 5 steps (S1,S2,S3,S4,S5) what will happen if cond is true or false (which of the other steps get executed)? 1) //s3 exec pgm=abc,cond=(0,le) 2) //s3 exec pgm=abc,cond=(0,le,step2) 3) In the jobcord RESTART=step3,cond=(0,le) 4) can i code COND=TRUE in jobcard, if yes what will happen?

3 Answers   TCS, Tech Mahindra,


what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?

1 Answers   IBM,


what are the ways of passing data to a cobol program from jcl?

1 Answers   IBM,


Categories