RE: MIDRANGE-L Digest, Vol 12, Issue 1138 -- MIDRANGE-L

This might help you get started....

http://www.youtube.com/watch?v=aDAf6mV2GyM

or

http://www.ibmisql.com

Regards,
Bill Hopkins

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: Friday, May 24, 2013 3:20 PM
To: Midrange Systems Technical Discussion
Subject: RE: MIDRANGE-L Digest, Vol 12, Issue 1138

I think someone should buy a book and or take a class
MS Access, to me, is an excellent way to learn, especially with a good book.
and there are several sources of good iSeries books: MC Press Online is one,
iPro Developer another

I must say I am impressed with the generous and thought-full replies others have offered
(mine did not qualify)

In my experience, it is something of a hallmark of programmers

sometimes too, please forgive, the snarky comeback

Its Friday, Happy Memorial Day weekend, and stay with the generous and thought-full

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Therrien
Sent: Friday, May 24, 2013 12:42 PM
To: Midrange Systems Technical Discussion
Subject: RE: MIDRANGE-L Digest, Vol 12, Issue 1138

Does anyone else feel like we are handing the keys to the Porsche to our pre-adolescent son? :-O

(and, yes I feel terrible for saying this)

Paul

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Mildenberger
Sent: Friday, May 24, 2013 1:33 PM
To: Midrange Systems Technical Discussion
Subject: RE: MIDRANGE-L Digest, Vol 12, Issue 1138

You don't need to prompt the STRSQL command. Once inside STRSQL then type 'CREATE VIEW' and press F4.

Scott

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Crystal Reports
Sent: Friday, May 24, 2013 12:28 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: MIDRANGE-L Digest, Vol 12, Issue 1138

Bill, I don't see the View option here: There will be the Iseries Nav installed but not sure when, in the meantime I just want to see if this helps the Crystal Report time.

Commitment control . . . . . . .   *NONE         *NONE, *CHG, *CS, *ALL... Naming convention . . . . . . .   *SYS          *SYS, *SQL Statement processing . . . . . .   *RUN          *RUN, *VLD, *SYN Library option . . . . . . . . .   *LIBL         Name, *LIBL, *USRLIBL... List type . . . . . . . . . . .   *ALL          *ALL, *SQL Data refresh . . . . . . . . . .   *ALWAYS       *ALWAYS, *FORWARD Allow copy data . . . . . . . .   *YES          *YES, *OPTIMIZE, *NO Date format . . . . . . . . . .   *JOB          *JOB, *USA, *ISO, *EUR... Date separator character . . . .   *JOB          *JOB, /, ., ,, -, ' ', *BLA Time format . . . . . . . . . .   *HMS          *HMS, *USA, *ISO, *EUR, *JI Time separator character . . . .   *JOB          *JOB, :, ., ,, ' ', *BLANK Decimal point . . . . . . . . .   *JOB          *JOB, *PERIOD, *COMMA... Sort sequence . . . . . . . . .   *JOB          Name, *HEX, *JOB, *JOBRUN..
Library . . . . . . . . . . .                 Name, *LIBL, *CURLIB Language identifier . . . . . .   *JOB          *JOB, *JOBRUN...


------------------------------

message: 2
date: Fri, 24 May 2013 10:16:59 -0700 (PDT)
from: Crystal Reports <crystalcleardecisions@xxxxxxxxx>
subject: WRKLNK

I started to use the WRKLNK. It asks for Object and Object type.
?
If I want to make a view as we have been discussing, what do I enter for these?

I am trying to create a view that the Crystal reports will access.

------------------------------

message: 3
date: Fri, 24 May 2013 17:34:31 +0000
from: Gary Thompson <gthompson@xxxxxxxxxxx>
subject: RE: WRKLNK

WRKLINK deals with FOLDERS or DIRECTORIES SQL creates VIEWS (aka Logical Files)

date: Fri, 24 May 2013 17:38:56 +0000
from: Bill Hopkins <bhopkins@xxxxxxxx>
subject: RE: WRKLNK

You can use

STRSQL
F4
Option for "CREATE VIEW"

Regards,
Bill Hopkins
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.