RE: SQL and CLLE

Peter,
Did you create your own UDF of QCMDEXC? We did. IBM supplies a stored procedure for QCMDEXC but not a UDF. Therefore, without a home grown udf for QCMDEXC I don't think this will work.

I had to swap an apostrophe and a parenthesis to this:
SELECT QCMDEXC('CRTDTAQ DTAQ(rob/myDtq) MAXLEN('
concat trim(char(AVGROWSIZE)) concat ')')
FROM QSYS2.SYSPARTITIONSTAT
WHERE SYSTEM_TABLE_SCHEMA = 'SYSIBM'
AND SYSTEM_TABLE_NAME = 'SYSDUMMY1'
;
However I still get
 SQL State: 42704 Vendor Code: -204 Message: [SQL0204] QCMDEXC in *LIBL type *N not found.

But if I change this to use our UDF
SELECT routines.QCMDEXC('CRTDTAQ DTAQ(rob/mydtaq) MAXLEN('
concat trim(char(AVGROWSIZE)) concat ')')
FROM QSYS2.SYSPARTITIONSTAT
WHERE SYSTEM_TABLE_SCHEMA = 'SYSIBM'
AND SYSTEM_TABLE_NAME = 'SYSDUMMY1'
;
It tries to build the data queue. That fails only because the avgrowsize of SYSDUMMY1 is -1 and they don't like to create data queues with that size. However, if I pick a different table it works fine!
SELECT routines.QCMDEXC('CRTDTAQ DTAQ(rob/mydtaq) MAXLEN('
concat trim(char(AVGROWSIZE)) concat ')')
FROM QSYS2.SYSPARTITIONSTAT
WHERE SYSTEM_TABLE_SCHEMA = 'ROB'
AND SYSTEM_TABLE_NAME = 'A'
;


Rob Berendt