×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Can you share the exact command entered, and the value of iSql that REXX
sees? Have you tried the SQL in Navigator or RUNSQL to verify the
syntax?
Also, you may need to specify immediate execution depending on what the
statement is (select versus insert or update):
EXECSQL "execute immediate "iSql
I don't do dynamic SQL in REXX so that's all I can think of.
Loyd Goodbar
Business Systems
BorgWarner Shared Services
662-473-5713
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of David FOXWELL
Sent: Thursday, October 09, 2008 7:51 AM
To: Midrange Systems Technical Discussion
Subject: RE: REXX QIBM_REX_FIND_SRCMBR
Having some difficulty with that.
My working REXX procedure permits me to pass and execute an sql
instruction.
Now I've created a command that directly invokes REXX.
I parse the argument so :
PARSE ARG 'CMD('iSql')'
SAY iSql shows me that the parsing has taken place, but
ADDRESS EXECSQL,
EXECSQL iSql
Sends the error SQL0104 which is a syntax error.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
