Re: Reporting using rtvdirinfo files

[Pat Barber <mboceanside@xxxxxxxxxxxxxxxx>]

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
>