RE: [WEB400] File QSQLTEMP1 not available.

[Andrew.Lutz@xxxxxxxxxx]

Aaron,

Are you compiling in batch mode?  If so change it to interactive.....




                    "Bartell, Aaron
                    L. (TC)"                To:     "'web400@midrange.com'" 
<web400@midrange.com>
                    <ALBartell@taylo        cc:
                    rcorp.com>              Subject:     RE: [WEB400] File 
QSQLTEMP1 not available.
                    Sent by:
                    web400-admin@mid
                    range.com


                    10/16/2001 10:47
                    AM
                    Please respond
                    to web400






Is there a special option that I have to specify on the compile(15=create
module) to make it show up in QTEMP?  Here is what the top of my compile
output looks like but it is still not showing up in QTEMP. . .

Command  . . . . . . . . . . . . :   CRTRPGMOD

  Issued by  . . . . . . . . . . :     ALBARTELL

Module . . . . . . . . . . . . . :   PROG1

  Library  . . . . . . . . . . . :     AS400CGI

Text 'description' . . . . . . . :   *SRCMBRTXT

Source Member  . . . . . . . . . :   PROG1

Source File  . . . . . . . . . . :   QSQLTEMP1

  Library  . . . . . . . . . . . :     QTEMP

  CCSID  . . . . . . . . . . . . :     37

Text 'description' . . . . . . . :
Last Change  . . . . . . . . . . :   10/16/01  10:42:14

Generation severity level  . . . :   10

Compiler options . . . . . . . . :   *XREF      *GEN       *NOSECLVL
*SHOWCPY
                                     *EXPDDS    *EXT       *NOSHOWSKP
*NOSRCSTMT
                                     *DEBUGIO   *NOEVENTF


I am doing a WRKOBJPDM QTEMP and I am assuming that is correct?  or am I
looking in the wrong spot?

Aaron Bartell

-----Original Message-----
From: Andrew.Lutz@abbott.com [mailto:Andrew.Lutz@abbott.com]
Sent: Monday, October 15, 2001 5:46 PM
To: web400@midrange.com
Subject: Re: [WEB400] File QSQLTEMP1 not available.



Aaron,

Follow your compile into QTEMP....

Here is what I mean

1.  Your first compile will generate (SQL pre-compilier does this)
intermediate source in QTEMP/QSQLTEMP1

2.  Compile from the QTEMP file with the debug options you want.

3.  Debug happily once again :-)






                    "Bartell, Aaron
                    L. (TC)"                To:     "'web400@midrange.com'"
<web400@midrange.com>
                    <ALBartell@taylo        cc:
                    rcorp.com>              Subject:     [WEB400] File
QSQLTEMP1 not available.
                    Sent by:
                    web400-admin@mid
                    range.com


                    10/15/2001 04:17
                    PM
                    Please respond
                    to web400






Above is the message I am getting when I try and debug an SQL ILE RPG CGI
program(we'll call it programA).  I am compiling programA with a 15(create
module) so I can then specify the Binding directory on the CRTPGM command
once the syntax checking is complete.  I have debugged many e-RPG programs
before but none that were SQL ILE.

Anybody know how to fix my problem?

Thanks,
Aaron Bartell
_______________________________________________
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/web400
or email: WEB400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.





_______________________________________________
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/web400
or email: WEB400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.
_______________________________________________
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/web400
or email: WEB400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.