I think I was too brief in my first posting.
I using a Sun E3000 running Solaris 7 and IDS 730.UC3
I got the source from IIUG site. The author is Art S. Kagel.
I used ar -x myschema.source.ar to extract the sources in the archive.
I'm trying to compile Art's new dbschema (myschema) utility.
Thanks for your help!
Denmark W.
> Hi Listers,
>
> I would appreciate any advice on this error I received attempting to
compile
> myschema.ec:
>
> bbankmain{informix}/sfw/informix/dba>which cc
> /opt/SUNWspro/bin/cc
> bbankmain{informix}/sfw/informix/dba>esql myschema.ec -o myschema
> esqlc: "myschema.eh", line 247: Error -33051: Syntax error on identifier
or
> symbol 'bigtxt'.
> 1 error(s) found
>
> Regards,
>
> Denmark W.
>
> "Knowledge is power, but it is only useful if it is shared!"
>
>
>
↪ replying to Denmark B. Weatherburn
I had this same problem. I resolved it by downloading the latest esqlc
release from the informix site, it think it was version 2.4?). Anyway,
after that got resolved, I had more syntax errors due to double quotes
in the dynamic sql statements. I resolved that by replacing the double
quotes with single quotes and using escape characters, for example(from
the print_checks.ec file, line 72):
EXEC SQL PREPARE s_chks FROM
'SELECT constrname, ch.* \\
FROM informix.sysconstraints co, informix.syschecks ch \\
WHERE co.constrtype = \\'C\\' \\
AND co.tabid = ? \\
AND co.constrid = ch.constrid \\
AND ch.type = \\'T\\' \\
ORDER BY ch.constrid, ch.seqno';
Hope this helps.
Alison
--
A.S.A. Consulting, with 20 years experience in Relational Database
Design and Performance in support of Client/Server and Data Warehouse
architectures on multiple platforms.