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.
midrange.com
