Paul -
I don't know about you, but time I spend here is time that I cannot bill to
my client - hence, advice which I supply is being provided at *my* expense.
The minimum that I would expect of someone who asks for assistance here is
that they first learn how to search for information on the internet and/or
on the IBM Information Center and at least try to figure out the basics
before asking very basic questions here...
It seems to me that some really basic knowledge of the platform is lacking,
and perhaps his employer should provide some additional training on IBM i.
BTW, I would encourage "Crystal Reports" to study the excellent advice from
Eric Raymond on requesting help from mailing lists/forums before posting
another request for help - How to Ask Questions the Smart Way:
http://www.catb.org/esr/faqs/smart-questions.html
-sjl
"Paul Therrien" wrote in message
news:mailman.5427.1369420604.7202.midrange-l@xxxxxxxxxxxx...
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.
midrange.com
