Re: SQL and CLLE

Hi Steve,

Building on Rob's idea, will this work?

SELECT QCMDEXC('CRTDTAQ DTAQ(myLib/myDtq) MAXLEN('
                  concat trim(char(AVGROWSIZE)) concat '))'
  FROM QSYS2.SYSPARTITIONSTAT
 WHERE SYSTEM_TABLE_SCHEMA = 'myLib'
   AND SYSTEM_TABLE_NAME = 'myFile'

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /

On 3/9/2021 7:31 AM, Rob Berendt wrote:

May I ask why you would need row length? Is it so you can do something like this?
SELECT SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME, system_table_member,
AVGROWSIZE, NUMBER_DELETED_ROWS,
AVGROWSIZE * NUMBER_DELETED_ROWS as Deleted_Space
FROM QSYS2.SYSPARTITIONSTAT
WHERE SYSTEM_TABLE_SCHEMA = 'ROUTINES';

Rob Berendt