Using SQL SEQUENCE for Next Number Operations

I'm testing the SEQUENCE operation on a V5R4 system where we want to implement a simple next number system to get a next batch sequence number.

The concept is very cool and it looks like it's been around quite a while so that's good, but here's an anomaly I found.

Here's what I created:
CREATE SEQUENCE QGPL/RJSGLNEXT as decimal (7,0) start with 27000

I run this from STRSQL and it works fine:
SELECT NEXT VALUE FOR RJSGLNEXT FROM SYSIBM/SYSDUMMY1

When I run the same SELECT statement via JT400, I get an error stating that the data area RJSGLNEXT is not found in library list, even though it exists and QGPL is in the library list.

It seems that it's not resolving in my QZDSAOINIT database job even though the library list is set correctly.

Also it appears I can't qualify RJSGLNEXT with the library prefix.

Anyone seen this type of issu with SEQUENCE before ?

Kind of makes SEQUENCE unusable if it doesn't resolve correctly :)

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx<mailto:richard@xxxxxxxxxxxxxxx>
Web Site: http://www.rjssoftware.com<http://www.rjssoftware.com/>
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT