How to run SQL script with parameters in CL

5 pts.
Tags:
AS/400 Control Language
CL
SQL
SQL scripts
SQL/400
I have to call an sql script with parameters from an existing cl program that runs daily (in batch). If I call it from the cl program, it is giving me this error "Pointer not set for referenced location referenced".

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

How do you call your script? Can you maybe post a sample of the code? Have you tried running the SQL script interactively?

Regards,

Martin Gilbert.

Discuss This Question: 2  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
  • Dreamz1974
    Hi, This seems to be a case of parameter mismatch.
    515 pointsBadges:
    report
  • RonKoontz
    put "with none" or "with NC" at the end of the sql script. I have noticed this before in some of my SQL scripts. Sometimes I have to put it and sometimes I don't.
    1,780 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