Re: Reporting using rtvdirinfo files

Here is what I got when I tried to run that script.



Connected to relational database S1076a2f on 192.168.10.02 as Patrick - 035784/Quser/Qzdasoinit

>
> SELECT SUBSTR(char(QEZOBJNAM),1,30) AS ObjectName, SUBSTR(char(QEZDIRNAM1),1,60) as DirName, QEZOBJTYPE, QEZALCSIZE, QEZDTASIZE, QEZACCTIM, QEZCHGTIMA, QEZCHGTIMD FROM QUSRSYS/qaezd0003o JOIN QUSRSYS/QAEZD0003d ON O.qEZDIRIDX = D.qEZDIRIDX order by qezalcsize desc

SQL State: 42833
Vendor Code: -5016
Message: [SQL5016] Qualified object name QAEZD0003O not valid. Cause . . . . . : One of the following has occurred: -- The syntax used for the qualified object name is not valid for the naming option specified. With system naming, the qualified form of an object name is schema-name/object-name. With SQL naming the qualified form of an object name is authorization-name.object-name. -- The syntax used for the qualified object name is not allowed. User-defined types cannot be qualified with the schema in the system naming convention on parameters and SQL variables of an SQL procedure or function. Recovery . . . : Do one of the following and try the request again: -- If you want to use the SQL naming convention, verify the SQL naming option in the appropriate SQL command and qualify the object names in the form authorization-id.object-name. -- If you want to use the system naming convention, specify the system naming option in the appropriate SQL command and qualify the object names in the form schema-name/object-name. -- With the system naming convention, ensure the user-defined types specified for parameters and variables in an SQL routine can be found in the current path.

Processing ended because the highlighted statement did not complete successfully



rob@xxxxxxxxx wrote:

Well, iNav's Run SQL Scripts is pretty sexy. Then there's RUNSQLSTM or the combo of CRTQMQRY and STRQMQRY. The last sentence is for source files.

Rob Berendt