RE: Interactive SQL - Command History

["Norbut, Jim" <Jim.Norbut@xxxxxxxxxxxxxxx>]

I do the dump command and it says it's sending to spoolfile 1.
But for the life of me....I cannot find spoolfile 1...or the spoolfile name
it says it is creating.

Any clues ?

 -----Original Message-----
From:   Chris Bipes [mailto:chris.bipes@cross-check.com]
Sent:   Tuesday, November 06, 2001 8:37 AM
To:     'midrange-l@midrange.com'
Subject:        RE: Interactive SQL - Command History

How do you find these thing?  I can dump it but cannot see it so how did you
ever find out about the space system objects?

Christopher K. Bipes      mailto:ChrisB@Cross-Check.com
Operations & Network Mgr  mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.                  http://www.cross-check.com
6119 State Farm Drive     Phone: 707 586-0551 x 1102
Rohnert Park CA  94928    Fax: 707 586-1884

-----Original Message-----
From: Douglas Handy [mailto:dhandy1@bellsouth.net]
Sent: Monday, November 05, 2001 4:45 PM
To: midrange-l@midrange.com
Subject: Re: Interactive SQL - Command History

Interactvie SQL is kept in a space object with type 19, subtype EE, in
QRECOVERY
with the name ISQLSTusrprf*.  After the user profile name is the device name
for
which the session history was created.

Try the following command, assuming the profile name is Mike:

  DMPSYSOBJ ISQLSTMIKE* QRECOVERY  TYPE(19) SUBTYPE(EE)

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.