View previous topic :: View next topic
|
Author |
Message |
shankarm
Active User
Joined: 17 May 2010 Posts: 175 Location: India
|
|
|
|
Hello,
I am writing a cobol code with cursor. Cursor declaration below,
Code: |
EXEC SQL
DECLARE LOADCRSR CURSOR FOR
SELECT DBR,...
FROM DM_IND
WHERE DBR = :WS-OLD-A
ORDER BY SEQ_NBR
FETCH FIRST 25 ROWS ONLY
END-EXEC
|
In the above, I want to make 25 configurable. Number of rows to be fetched may vary for every run. i have to pass it from JCL as PARM. I cannot substituite it with a host variable correct?
Please advise. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
1. when reading the syntax of a command, when it says host-variable it means host variable,
when it says n it means a numeric literal.
when it does not stipulate that a host variable can be used (it is not stipulated when host-variable is not contained in the syntax for that command), (i love it when i can find a legal use of a double negative!)
then a host variable cannot be used.
2. why would you want the number of rows to be fetched to be dynamic? |
|
Back to top |
|
|
shankarm
Active User
Joined: 17 May 2010 Posts: 175 Location: India
|
|
|
|
Quote: |
why would you want the number of rows to be fetched to be dynamic?
|
This is the requirement customer says.
I understand that i can fetch all the rows and later when i write the output, i can restrict the number of rows written to the output. I just little concerned about the performance.
This particular table can have thousands of records for each DBR (Refer where condition in query to understand how DBR is used) and i have more than 800 Million records to extract. |
|
Back to top |
|
|
|