Re: SQL Defaults

[Dave Mahadevan <mahadevan@xxxxxxxx>]

Paul:

PaulMmn wrote:
> 
> I know this has been mentioned here before, however, I didn't note the 
>answer...
> 
> I did a STRSQL from 2 sessions at the same time.  Then my 'previous session'
> isn't there anymore.
> 
> I did a 'save to source file,' and now my session's back.
> 
> If I remember correctly, this means that my defaults are now on a
> terminal-by-terminal basis, instead of a user-by-user basis.
> 
> How do I restore my defaults to a user-by-user basis?  Or is this a 1-way
> trip (unless I delete and re-create my user profile)?

The solutions is a little involved.  Follow the directions exactly.

You can get the list of sessions from:
 DMPSYSOBJ ISQLENyouruserid* QRECOVERY 19 EE

My user profile name is CRP.  Output sample for me with one session:

 DMPSYSOBJ PARAMETERS
 OBJ- ISQLENCRP*                      CONTEXT- QRECOVERY
 TYPE- 19   SUBTYPE-EE
 OBJECT TYPE-           SPACE                                        
*MSCSP
 NAME-     ISQLENCRP       QPADEV00790000  TYPE-  19   SUBTYPE-  EE
 LIBRARY-     QRECOVERY                       TYPE-  04   SUBTYPE-  01
 CREATION-    04/28/96  12:53:09              SIZE-     0000003400
 OWNER-       CRP                             TYPE-  08   SUBTYPE-  01

For multiples you will have multiple "NAME-" in the spooled output
QPSRVDMP.
The "NAME-" is positionally in bytes:
      01-06  ::  ISQLEN
      07-16  ::  User profile starting the session.
      17-26  ::  Workstation device name for session selection
      27-30  ::  Session number for that workstation ID <0000 is first>

Sign on to the workstation ID for the one you wish to delete, then
STRSQL,
then 2=Delete after F3=Exit.  HTH.

-- 
Thank You.

Regards

Dave Mahadevan.. mailto:mahadevan@fuse.net
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *