Re: Rumba question

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

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
+---