× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.