Fantastic Chuck !! ... I do believe this works .... <smile>
Here is what query output looks like now ....
Date Time Type Sub Access User Object / Type....... Program JOB.................
Type Type causing causing
entry entry
04/14/10 12:35:03 ZC C 00030 J6D AW100F SEACOL *FILE AW100C 035415 J6D SJ6D1
04/14/10 12:35:04 C 00030 J6D AW200F SEACOL *FILE AW200C 035415 J6D SJ6D1
04/14/10 12:36:23 C 00030 J6D AWPRT SEACOL *FILE AW310 035927 J6D COLLECTOR
04/14/10 12:37:45 C 00030 J6D AWPRT SEACOL *FILE AW800 035927 J6D COLLECTOR
04/14/10 01:15:03 C 00007 KEG QGPL QSYS *LIB PABC0321 028727 KEG AUTBRKLOG
04/14/10 01:15:04 C 00007 KEG QGPL QSYS *LIB PABC0321 028727 KEG AUTBRKLOG
04/14/10 01:15:04 C 00007 KEG QGPL QSYS *LIB PABC0321 028727 KEG AUTBRKLOG
04/14/10 05:48:40 C 00007 KEG QSYS QSYS *LIB CRTKENNETH 032846 KGRAAP KENNETH1
04/14/10 05:48:45 C 00001 KEG QSYS QSYS *LIB CRTKENNETH 032846 KGRAAP KENNETH1
Kenneth
Kenneth E. Graap
http://www.linkedin.com/in/kennethgraap
-----Original Message-----
The data of interest actually appears to be from position 30 for three bytes.
The /result field/ expression TYPE=SUBSTR(AUDATA,30,3) will result in the string of data x'00007F'. AFaIK a character string is not valid for the operand of the DIGITS scalar function; i.e. the result field CHARTYPE should not be allowed as shown.?
Given the data is always both positive and integer, the following expressions would suffice to present the numeric result as a character string; albeit easily combined into one expression:
TYPE = SUBSTR( AUDATA, 30, 3)
CHARTYPE = SUBSTR( HEX(TYPE), 1, 5)
midrange.com
