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 to convert a file form fixed Length to variable length?

2 Answers   Syntel,


with out sorting how to copy records from one file to another file using jcl.Mean I have one input file in which the record are like 1,6,5,4,2,3(for example) and i want to copy to output file from top to bottom(without sorting) like 3,2,4,5,6,1.so I want the JCL for this.cna any one can answers?

1 Answers   TCS,


Hi, can we call catalog( say myproc } proc n times in jcl if so how please explain Thanks in advance

2 Answers   Cap Gemini,


Explain how can a jobs execution priority be modified?

0 Answers  


What is jcl in mainframe, and how many types of jcl statements are there for a job?

0 Answers  






If job is submitted with typerun = hold then how can we submit the same job?

3 Answers   Wipro,


How to execute step2,step1,step3 when step1,2&3 are in order

6 Answers   TCS,


what is the default region size if I dont specify region parametre in my job card ( I know that if I specify region=0k or 0M, then the job will occupy all he available resources at the time of job execution), but I want to know the defult value for "region" paramatre.

5 Answers   BirlaSoft, Infosys,


List the different jcl statements that are not permitted in the procedures?

0 Answers  


What does it mean by Restart and Checkpoint in JCL ? How are checkpoints being taken and what is their usage ? How to use Checkpoint macro on a JOBSTEP ?

0 Answers   IBM,


There are 5 steps in a Job. How to bypass the first step by making use of only COND Parameter and not using any Restart and IF/THEN/ELSE parameter?

11 Answers   IBM,


How to identify where file is empty or not? How many ways are there to identifying?

3 Answers   CTS,


Categories