CL/QMQRY

15 pts.
Tags:
AS/400
QMQRY
SQL procedure
i hav code

 

STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT) 

 In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file.

in sqlproc if i mentioned SELECT statment , then it will work fine, but i want through procedure

its urgent , plz help

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    ...but i want through procedure Then write a program using a language that can receive a result set from a procedure. Don't use CL. CL can not receive result sets. (Technically, at V5R4 and later, you can probably call a stored procedure and possibly access a returned result set. You might do it by calling the appropriate SQL Call Level Interface (CLI) APIs, but it would be easier to use a different language. CL is intended to be a control language rather than a general purpose programming language.) Tom
    125,585 pointsBadges:
    report
  • Sanashakeel
    WHY , QMQRY CAN'T GRAB RESULT FROM PROCEDURE, WHILE IT CAN GRAB RESULT SET FROM 'SELECT STATMENT '
    15 pointsBadges:
    report
  • TomLiotta
    WHY , QMQRY CAN’T GRAB RESULT FROM PROCEDURE CL can't grab a result set. It doesn't matter if a QMQRY can or can't. As long as CL can't do it, there is no point in tring to use a QMQRY to return a result set to CL. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following