Re: RUNSQLSTM problem

[Richard Reeve <richreeve@xxxxxxxxx>]

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

 Yes.
  MWalter@hanoverwire.com wrote:
is the file MTDMASSP in your job's Library list?




Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040



Richard Reeve
m> cc:
Sent by: Subject: RUNSQLSTM problem
midrange-l-admin@mi
drange.com


12/26/01 10:07 AM
Please respond to
midrange-l






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