Re: RUNSQLSTM problem

[Richard Reeve <richreeve@xxxxxxxxx>]

--
[ Picked text/plain from multipart/alternative ]

 I had tried that already but don't see anything.  Would it be easier to do a 
QMQRY?  If so could someone lay out the steps to accomplist in QMQRY?  I am in 
a bit of a rush..........What else is new?
  Jim Franz <franz400@triad.rr.com> wrote: the msg desc for sq9010 is from cmd: 
DSPMSGD RANGE(SQL9010) MSGF(QSQLMSG)
Message ID . . . . . . . . . : SQL9010
Message file . . . . . . . . : QSQLMSG
Library . . . . . . . . . : QSYS
Message . . . . : RUNSQLSTM command failed.
Cause . . . . . : Errors were found while processing the source for the
RUNSQLSTM command. The listing print file is &1 in &2.
Recovery . . . : Review the messages on the listing. Either correct the
problems or specify a higher severity on the ERRLVL parameter. Try the
request again.
Technical description . . . . . . . . : The RUNSQLSTM command found
errors
with a severity greater than the requested ERRLVL.

(this still doesn't tell all. make sure your interactive job is set for max
logging:
CHGJOB LOG(4 00 *SECLVL) LOGCLPGM(*YES)

then the dspjob, option 10 - or dspjoblog cmds should give more detail
(like file not found, or authority, or something)
also, the runsqlstm cmd defaults a printer file (qsysprt) - see if an error
page exists.
hth
jim franz

----- Original Message -----
From: "Richard Reeve"
To:
Sent: Wednesday, December 26, 2001 10:07 AM
Subject: RUNSQLSTM problem


> --
> [ Picked text/plain from multipart/alternative ]
>
> Hi all. I am having a problem running a simple SQL using the RUNSQLSTM
command. Here is what I did.
>
> 1. Crearted a source file called QSQLSRC in my library
>
> 2. Created a source member in QSQLSRC called FIXFORNAM
>
> UPDATE MDTMASSP SET FORNAM = '4' WHERE FORNAM = '9'
>
> 3. I then created a CL called FIXFORNAM
>
> *************** Beginning of data *************************************
> PGM
> /* This is a one time fix that will be run to correct the formatting *
> /* of the name when printing. *
> RUNSQLSTM SRCFILE(CONSLTRR/QSQLSRC) SRCMBR(FIXFORNAM) +
> COMMIT(*NONE) NAMING(*SYS) +
> SAAFLAG(*FLAG)
> ENDPGM
> ****************** End of data ****************************************
>
> When I compile and run the above CL I get the following messages in my job
log;
>
> call fixfornam
> RUNSQLSTM command failed.
> SQL9010 received by FIXFORNAM at 400. (C D I R)
> C
> Function check. SQL9010 unmonitored by FIXFORNAM at statement 400,
> instruction X'000C'.
>
> Does anyone know what this means? The message text is useless to me.
>
> Thanks.
>
> Rich
>
>
>
>
>
> ---------------------------------
> Do You Yahoo!?
> Send your FREE holiday greetings online at Yahoo! Greetings.
> _______________________________________________
> 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.
>
>


_______________________________________________
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.





---------------------------------
Do You Yahoo!?
Send your FREE holiday greetings online at Yahoo! Greetings.