AS/400 SQL Procedure call from CL program
I am calling an SQL stored procedure (counts records for a value) from a CL program. I want to send the value to compare to the CL SQL pricedure and get back the count. How do I define the count variable (&COUNT ?) in the CL program? I am using STRQMQRY to call.
Software/Hardware used:
Software/Hardware used:
ASKED:
September 18, 2008 4:39 PM
UPDATED:
July 31, 2010 9:16 AM
Answer Wiki:
have you tried it as *DEC (n n) where n n is the length and number of decimal places?
=========================================================
A QM query can't return a value to CL. CL can't call stored procs. Some different process needs to be developed. Actually, it seems to be a very long way around what should be simple. CL can call programs directly or it can count rows by itself.
Please describe the business process that you need to do. A proper suggestion can probably be provided.
Tom
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
