Re: SQLRPG/400 Day of Week

[theis_richard@xxxxxxxxxx]

Simon wrote:
> However, although that basic syntax worked in ISQL, it failed in an
SQLRPG
> program due to not being able to find QSQPTABL in QSYS2 so either I'm
> missing
> some database PTFs or there's an optionally installable component I
> haven't installed.  That's going on the list for later investigation.

Simon,
I got the same error creating an UDF in V4R5, the circumvention was:
from the interactive sql prompt:
CREATE TABLE QSYS2/QSQPTABL (INTEGER_COLUMN FOR COLUMN INTCOL INTEGER )
insert into qsys2/QSQPTABL  values(1)
Then from the CL prompt change the object owner to qsys and authority to
qsys *all public *use.

Best regards
Richard THEIS
AS/400 Education, France
  theis_richard@fr.ibm.com


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---