Don,
There are two different things in play here.
QCMDEXC, the stored procedure
QCMDEXC, the scalar function.
The stored procedure came out much earlier. When you use CALL QSYS2.QCMDEXC... you are using the stored procedure. When you use select ..., qsys2.qcmdexc(..., from... you are using the scalar function.
For a list of what level of os and ptf's needed check out:
https://www.ibm.com/support/pages/node/1119123
Basically the stored procedure was part of the base of 7.3.
Can you tell me at what 7.3 DB2 group level did the function come out by looking at the link above?
See also: WRKPTFGRP
However, since you are only 6 months behind, and DB2 7.3 is up to level 30, I would think you should have it. I could not find a history of when level 24 came out.
Are you sure you're ordering group ptfs also and not just the cume?

For a definitive search you could try:
select *
from qsys2.sysfuncs
where SPECIFIC_SCHEMA='QSYS2' and ROUTINE_NAME='QCMDEXC';
This is different than
select *
from qsys2.sysprocs
where SPECIFIC_SCHEMA='QSYS2' and ROUTINE_NAME='QCMDEXC';

For 7.3 documentation on the scalar function see:
https://www.ibm.com/docs/en/i/7.3?topic=services-qcmdexc-scalar-function

See also:
https://www.ibm.com/support/pages/ibm-i-group-ptfs-level

Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.