Re: Rumba question

Hello Glenn,

For what it's worth ...

Have you tried creating an SQL procedure for the program?  STRSQL (or use QM) 
and run the CREATE PROCEDURE 
SQL statement.  For example:

CREATE PROCEDURE I60TSTU.PUR08C (INOUT CHAR(6) P1, INOUT CHAR(2) P2) 
EXTERNAL NAME I60TSTU.PUR08C LANGUAGE ???? GENERAL

Caveat: Above syntax typed from memory so it may not be entirely accurate.  
Replace the question marks with 
the language type.

Regards,
Simon Coulter.

«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
«» FlyByNight Software         AS/400 Technical Specialists       «»
«» Eclipse the competition - run your business on an IBM AS/400.  «»
«»                                                                «»
«» Phone: +61 3 9419 0175      Mobile: +61 0411 091 400           «»
«» Fax:   +61 3 9419 0175      mailto: shc@flybynight.com.au      «»
«»                                                                «»
«» Windoze should not be open at Warp speed.                      «»
«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
//--- forwarded letter -------------------------------------------------------
> MIME-Version: 1.0
> Date: Wed, 03 Feb 99 16:20:48 -0500
> From: Glenn-Cons.T.Geathers@am.pnu.com
> To: MIDRANGE-L@midrange.com
> Reply-To: MIDRANGE-L@midrange.com
> Subject: Rumba question

> 
> Can anyone answer this for me?
> The message itself is:
> 
> [Wall Data][RUMBA Data Access][IRIS FILES TST]Syntax error or       access 
> violation
> 
> The SQL statement causing the error is:
> 
> Call I60TSTU.PUR08C('I60TST','  ')
> 
> 
> If I use the RUMBA DRDA-32 Version 1018.02.0000 driver, I can execute the 
> SQL with no problem.
> 
> If I use the RUMBA AS/400 Optimized Server (32 bit) Version 1018.07.0000 
> driver, I get the error.  However, I can use this same driver to issue 
> simple SELECT statements with no problems.  It won't allow the CALL for 
> some reason though.
> 
> This is why I was wondering if there are maybe different security settings 
> on the AS/400 for DRDA connections as opposed to the TCP/IP connections 
> used with the optimized driver?
> 
> I would lean more toward the problem being syntax if it didn't work with 
> the DRDA driver.  But since it does, I think the formatting of the 
> statement itself is okay.
> 
> Thanks in advance for any help you can offer,

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---