| SQL*Plus edit pds [message #113892] |
Sat, 03 May 2003 19:10  |
Steve Runtsch
Messages: 4
Registered: January 2002
|
Junior Member |
|
|
In Oracle7 SQL*Plus, on our OS/390 systems, command "edit abc123" takes the user to ISPF editor, data set uid.ORACLE.SQL, member ABC123. (The value of EDITFILE is "ORACLE", and SUFFIX is "SQL".)
In Oracle8 SQL*Plus, the same command takes the user to ISPF editor, data set uid.ABC123.SQL.
I can't find a reason in Oracle7 books why ABC123 is used as a PDS member name instead of an override for EDITFILE, but users like it that way and want Oracle8 to behave the same.
How can I make Oracle8 work like Oracle7?
|
|
|
|
| Re: SQL*Plus edit pds [message #113923 is a reply to message #113892] |
Wed, 11 June 2003 11:25  |
Jim Gillespie
Messages: 23
Registered: January 2001
|
Junior Member |
|
|
: In Oracle7 SQL*Plus, on our OS/390 systems, command "edit abc123" takes the user to ISPF editor, data set uid.ORACLE.SQL, member ABC123. (The value of EDITFILE is "ORACLE", and SUFFIX is "SQL".)
: In Oracle8 SQL*Plus, the same command takes the user to ISPF editor, data set uid.ABC123.SQL.
: I can't find a reason in Oracle7 books why ABC123 is used as a PDS member name instead of an override for EDITFILE, but users like it that way and want Oracle8 to behave the same.
: How can I make Oracle8 work like Oracle7?
Steve,
I use a clist to run sqlplus. In the clist I allocate an ORA$FNA dataset. This is what is in the dataset;
FSA ( FTYPE(SQL) FNAME ('/DSN/PDPJN.ORA.SQL(+)') ) This acts like your version 7 did.
Jim Gillespie
|
|
|
|
| Re: SQL*Plus edit pds [message #113924 is a reply to message #113923] |
Wed, 11 June 2003 11:34 |
Jim Gillespie
Messages: 23
Registered: January 2001
|
Junior Member |
|
|
: : In Oracle7 SQL*Plus, on our OS/390 systems, command "edit abc123" takes the user to ISPF editor, data set uid.ORACLE.SQL, member ABC123. (The value of EDITFILE is "ORACLE", and SUFFIX is "SQL".)
: : In Oracle8 SQL*Plus, the same command takes the user to ISPF editor, data set uid.ABC123.SQL.
: : I can't find a reason in Oracle7 books why ABC123 is used as a PDS member name instead of an override for EDITFILE, but users like it that way and want Oracle8 to behave the same.
: : How can I make Oracle8 work like Oracle7?
: Steve,
: I use a clist to run sqlplus. In the clist I allocate an ORA$FNA dataset. This is what is in the dataset;
: FSA ( FTYPE(SQL) FNAME ('/DSN/PDPJN.ORA.SQL(+)') ) This acts like your version 7 did.
: Jim Gillespie
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
