Re: RUNSQLSTM problem

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
                    <richreeve@yahoo.co        To:     midrange-l@midrange.com
                    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.