Plenty more for him to learn there also.
Regards,
Bill Hopkins
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Therrien
Sent: Friday, May 24, 2013 3:55 PM
To: Midrange Systems Technical Discussion
Subject: RE: MIDRANGE-L Digest, Vol 12, Issue 1138
Regarding the youtube video - that is truly helpful. CR should take note.
Paul
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bill Hopkins
Sent: Friday, May 24, 2013 2:31 PM
To: Midrange Systems Technical Discussion
Subject: RE: MIDRANGE-L Digest, Vol 12, Issue 1138
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.
--
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.
midrange.com
