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

Oops ... I copied via PDM-6 print, then OPSNAV to text file.
I will resend the QRY techniques doc after I cleaned it up a wee bit,
because I run into variations on this sort of thing far too often.

If you change the font to Courier or other proportional, the text should
line up again Ok.

If you can view the doc in your e-mail, it may line up better, then Ctl A
(all) then cut & paste into a Word doc, and make the whole doc courier and
character size 10 or smaller, it should get much more readable.

The QRY Techniques doc is a collection of "how to" in query/400, which we
figured out over time.
Absolute value sequence of data
Date math with BPCS dates
Figure labor efficiency
Other stuff whose needs may not also exist other places.

-
Al Mac
-----Original Message-----
From: bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx] On Behalf Of
Margareth Sere
Sent: Tuesday, November 09, 2010 8:42 PM
To: BPCS ERP System
Subject: Re: [BPCS-L] SQL Cheat Sheets RE: Item with last transaction date

Hi Al,
I received the files. It's very much useful to me and definitely will ease
out my query troubles!
The text files however are misaligned, anyway I'll try to figure out how it
can be aligned.

Thank you very much again.
Regards,
Margie
On Tue, Nov 9, 2010 at 11:00 PM, Michael Perna <MPerna@xxxxxxxxxxxx> wrote:

Hi Al -

Is it possible for you to send to me as well? Any way of posting them?
I'm sure a lot of people would benefit from them.
Thank you,

Michael


-----Original Message-----
From: bpcs-l-bounces+mperna=contessa.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+mperna <bpcs-l-bounces%2Bmperna>=contessa.com@
midrange.com] On Behalf Of Al
Sent: Sunday, November 07, 2010 8:04 PM
To: 'BPCS ERP System'
Subject: Re: [BPCS-L] SQL Cheat Sheets RE: Item with last transaction
date

I sent you them off-list.

99% of my SQL/400 programming is via embedded inside RPG.

Occasionally I use STRSQL with SELECT to obtain some data, then SAVE
the successful session to get the successful code to embed in some
program.

My main current focus struggle is review of EOY needs, make sure
software
ready, then as I test stuff, this leads people ideas for further
improvements. Inventory unused in some time frame, slow moving
inventory.
Much of this data derived via SQL embedded in RPG.

-
Al Mac
-----Original Message-----
From: bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+macwheel99 <bpcs-l-bounces%2Bmacwheel99>=wowway.com
@midrange.com] On Behalf Of
Margareth Sere
Sent: Sunday, November 07, 2010 9:38 PM
To: BPCS ERP System
Subject: Re: [BPCS-L] SQL Cheat Sheets RE: Item with last transaction
date

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: mperna@xxxxxxxxxxxx
--
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