Re: SQL Cheat Sheets RE: Item with last transaction date

[Margareth Sere <margiesere@xxxxxxxxx>]

Hi Al,
I think these stuff is good and I think I can use it as query/400
alternative as I am struggling on SQL/400
Can I also request for a copy of all these docs.

TIA!

Regards,
Margie

On Fri, Oct 22, 2010 at 2:05 AM, Al <macwheel99@xxxxxxxxxx> wrote:

> 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
>
> --
> This is the BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
> Delivered-To: margiesere@xxxxxxxxx