RE: utils2_ak problem (BUG in released code)
Oh rats, I hate to bug the list when I could have found the problem myself.
The print_procedures.ec line 243 has a BUG. I was looking to hard at what
the error message was complaining about but It turned out to be a lost comma
in the select statement.
"SELECT *, FROM \\\\"informix\\\\".sysprocbody \\\\
^ lost comma?
Tim Ertl
413-442-9000 x6211
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Tim
Ertl
Sent: Friday, July 18, 2008 1:05 PM
To: ids@iiug.org
Subject: utils2_ak problem [12787]
I just went to compile the utils2_ak programs to support the use of
myexport. I got a strange error in the myschema stuff. It seems to be
complaining about the use of the backslash on the quotes around the word
Informix. This is pretty standard stuff. I included both the error, the code
below and the esql error message. The code looks right to me?.
I welcome any thoughts. Thanks...
,,,Tim
INFORMIXC=gcc esql -O3 -c print_procedures.ec
esqlc: "print_procedures.ec", line 243: Error -33051: Syntax error on
identifier or symbol '\\\\"informix\\\\"'.
1 error(s) found
make[1]: *** [print_procedures.o] Error 1
make[1]: Leaving directory `/informix/iiug-utils/myschema.d'
cp: cannot access myschema
make: *** [myschema] Error 2
------------------------------------------------------------
FROM print_procedures.ec : line 243: (looks right to me?!)
EXEC SQL PREPARE s_atext FROM
"SELECT *, FROM \\\\"informix\\\\".sysprocbody \\\\
WHERE procid = ? AND datakey = 'A' \\\\
ORDER BY 1,2,3";
--------------------------------------------------------
ESQL message:
-33051 Syntax error on identifier or symbol symbol-name.
An error in syntax was found at or near symbol-name. Check the IBM Informix
Guide to SQL: Syntax for the proper use of identifiers and the
appropriate embedded-language manual for the proper use of other
symbols.
-------------------------------------------------------------
CSDK version 3.00.FC3 (supplied with the Informix download)
Gcc 3.4.6
Gmake 3.81
Informix 11.10.FC2
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
Yes, I uploaded the fix for that over a week ago, it hasn't been posted
yet. My fault or course for the original bug. Fumble fingered cleaning up
trace code after the testing. <sigh> Anyone not comfortable in 'C'-ESQL/C
who wants the update emailed directly, just email me, address at the bottom
of the post.
Art
On Fri, Jul 18, 2008 at 1:24 PM, Tim Ertl <tim@lmrgroup.com> wrote:
> Oh rats, I hate to bug the list when I could have found the problem myself.
> The print_procedures.ec line 243 has a BUG. I was looking to hard at what
> the error message was complaining about but It turned out to be a lost
> comma
> in the select statement.
>
> "SELECT *, FROM \\\\"informix\\\\".sysprocbody \\\\
>
> ^ lost comma?
>
> Tim Ertl
>
> 413-442-9000 x6211
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Tim
> Ertl
> Sent: Friday, July 18, 2008 1:05 PM
> To: ids@iiug.org
> Subject: utils2_ak problem [12787]
>
> I just went to compile the utils2_ak programs to support the use of
>
> myexport. I got a strange error in the myschema stuff. It seems to be
>
> complaining about the use of the backslash on the quotes around the word
>
> Informix. This is pretty standard stuff. I included both the error, the
> code
>
> below and the esql error message. The code looks right to me?.
>
> I welcome any thoughts. Thanks...
>
> ,,,Tim
>
> INFORMIXC=gcc esql -O3 -c print_procedures.ec>
> esqlc: "print_procedures.ec", line 243: Error -33051: Syntax error on
>
> identifier or symbol '\\\\"informix\\\\"'.
>
> 1 error(s) found
>
> make[1]: *** [print_procedures.o] Error 1
>
> make[1]: Leaving directory `/informix/iiug-utils/myschema.d'
>
> cp: cannot access myschema
>
> make: *** [myschema] Error 2
>
> ------------------------------------------------------------
>
> FROM print_procedures.ec : line 243: (looks right to me?!)
>
> EXEC SQL PREPARE s_atext FROM
>
> "SELECT *, FROM \\\\"informix\\\\".sysprocbody \\\\
>
> WHERE procid = ? AND datakey = 'A' \\\\
>
> ORDER BY 1,2,3";
>
> --------------------------------------------------------
>
> ESQL message:
>
> -33051 Syntax error on identifier or symbol symbol-name.
>
> An error in syntax was found at or near symbol-name. Check the IBM Informix
>
> Guide to SQL: Syntax for the proper use of identifiers and the
>
> appropriate embedded-language manual for the proper use of other
>
> symbols.
>
> -------------------------------------------------------------
>
> CSDK version 3.00.FC3 (supplied with the Informix download)
>
> Gcc 3.4.6
>
> Gmake 3.81
>
> Informix 11.10.FC2
>
>
> ****************************************************************************
> ***
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.