SQL Cheat Sheets RE: Item with last transaction date

Another alternative to query/400 or RPG is SQL/400.

I have been to a couple classes in SQL and still have some class hand-outs
from it as Word documents. I could send you off-line if you interested.
They are:

171 k SQL Codes
85k SQL Data Types
53k SQL Examples
220k SQL Roadmap
496k SQL Tech Ref
65k SQL RPGLE Examples

Also see below
61 k Math 400

This is SQL/400 programming in general. It is not BPCS specific.

The third one has examples which can also be used in Query/400, such as
sub-stringing a date.

Plus it reminds me of another Query Tip I neglected to mention earlier.
When you grab files in Query, they get labeled T01 T02 T03 etc. I like to
relabel them as I (for Item Master) I1 (for IIML01) C (for cost or customer
file) T (for ITH transactions) etc. This makes it easier later seeing which
file is which on the other Query screens.

If you are not an RPG programmer, the first one (SQL Codes) will be totally
Greek to you, because it is a list of the various "error" condition codes
that are fed back to an RPG program when you use embedded SQL, that your
program might want to test for.

The Technical Reference explains what you have to have from IBM for this
stuff to work, compares SQL to DDS, has an inventory of functions available,
the various things you can do, and their rules.

The Roadmap is an essay or introduction for understanding SQL/400 on IBM
platform. It provides suggestions for additional reading up on the subject.

If you ask for them, I will not send using the same e-mail address I use for
BPCS-L because my ISP has been flickering out on me, which is a royal pain
when there's dozens of e-mails in the queue, or VPN to 400.

I also offer a seventh document.

61 k Math 400

This is a write-up by me, a few years ago, addressing the question of which
functions I am able to get out of which programming languages I was familiar
with on the 400 a few years ago. It compares: OPNQRYF in CL, query/400;
SQL/400; RPG; - their relative pros & cons from my perspective, since each
one offers stuff I not know how to do in the others. It also mentions a few
other alternatives that me not proficient in. I wrote this so long ago that
there are references in there I forget the details of.

Maybe one person here who asks for this stuff, can then inform the group
whether Al's offer is any damn good, considering it is not current stuff.

-
Al Mac