RE: ISQL Sessions

[Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>]

That is if you save your session to a source file upon exit.
There are 4 options upon exiting ISQL:


1=Save and exit session      
2=Exit without saving session
3=Resume session             
4=Save session in source file

I wanted to know where option 1 saved the sessions:

It is in a system space object located in qrecovery library.  The type is
19, sub-type is EE and the naming convention is ISQLSTuseridJobnameCounter.
The userid and job is always 10 characters, spaced filled.  The counter is 4
digit number zero filled.

Here is a cut of a dump of my profile, chrisb.

 DMPSYSOBJ PARAMETERS

 OBJ- ISQLSTCHRISB*                   CONTEXT- QRECOVERY

 TYPE- 19   SUBTYPE-EE

 OBJECT TYPE-           SPACE
*MSCSP        
 NAME-        ISQLSTCHRISB    SCHRISBA  0000  TYPE-          19   SUBTYPE-
EE
 LIBRARY-     QRECOVERY                       TYPE-          04   SUBTYPE-
01
 CREATION-    02/24/05  15:49:25              SIZE-          0000004000

 OWNER-       CHRISB                          TYPE-          08   SUBTYPE-
01
 ATTRIBUTES-          0800                    ADDRESS-       319C4236A5
000000        


-----Original Message-----


I've found that all ISQL sessions created by STRISQL are stored in the
userid's library in a file table called QSQLSESS.