Hi everyone
Before I forget - we are on V7r1
I ran the following SQL command
SELECT *
FROM TABLE (QSYS2.OBJECT_STATISTICS('*ALLUSR','FILE'))
as X
on all of our systems with no problem - EXCEPT ONE (isn't that always the case)
This one particular system needs to purge/delete/remove some files as the amount of available disk space is becoming smaller
When I run the above query, I receive
Query cannot be run. See lower level messages.
So taking F1 on that message, and then the job log, I see
Attributes of field OBJSIZE format FILEATTRIB not valid.
Then taking F1 on that message, I see
Message ID . . . . . . : CPD4308
Cause . . . . . : The type, length, decimal digits, decimal precision, CCSID
(Coded Character Set Identifier), date or time format, or date or time
separator of field OBJSIZE query format FILEATTRIB is not valid. See the DDS
topic collection in the Programming category in the IBM i Information Center
book,
http://www.ibm.com/systems/i/infocenter/, for valid field attributes.
I have googled CPD4308 - but theres nothing much out there - well - unless you are looking for some safety courses
Does anyone have any idea the underlying cause is and how to rectify this?
As always - any and all responses gratefully accepted
Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill
midrange.com
