Can you use variables as input and output when calling a stored procedure in COBOL?

15 pts.
Tags:
CL variables
COBOL
SQL procedure
SQL variables
Variable fields
If you move data into your variable before calling your procedure, can the procedure then return a value back, which might be different? The procedure will intially be searching for the variable data, but, according to our .net programmer, will return a blank or null if it does not find the data. So far, that is not working, and he wants me to find the COBOL answer to this.

Software/Hardware used:
Micro-Focus COBOL, with embedded SQL procedure calls.

Answer Wiki

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

How are you accessing the ORACLE DBMS from the IBMi server?

We use a product called Oracle Access manager are calling an oracle based stored procedure that returns variables. The returned variables are defined in the SP as OUTPUT. The COBOL variable accepting the return value will have the default value (spaces or zeros) when it is NULL in the DB. The associated null indicator variable will state whether the value was null or not.

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
  • TomLiotta
    Can you tell us what DBMS is involved? That might help someone know how to answer. Tom
    125,585 pointsBadges:
    report
  • Bunkyg
    ORACLE
    15 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