What version of IBM i OS are you running?
Run STRSQL
Then once in SQL press F4. You will see a list of commands. Create View (in my version), is 11.
Select one of the following:
1. ALTER TABLE
2. CALL
3. COMMENT ON
4. COMMIT
5. CONNECT
6. CREATE ALIAS
7. CREATE COLLECTION
8. CREATE INDEX
9. CREATE PROCEDURE
10. CREATE TABLE
11. CREATE VIEW
12. DELETE
13. DISCONNECT
14. DROP ALIAS
Selection
Paul
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Crystal Reports
Sent: Friday, May 24, 2013 1: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
