Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Robert Colombo — — source: Informix-list mailing list archive (1991-1998)
Chris,
Instead of using:
OUTPUT TO something.sql
SELECT "SELECT COUNT(*) FROM", tabname, ";" FROM SYSTABLES;
I use:
UNLOAD TO "something.sql" DELIMITER ";"
SELECT "SELECT COUNT(*) FROM "||tabname FROM SYSTABLES;
Much easier to deal with.
Bob Colombo
Sr. Consultant
Informix, Boston
In article <3a91bv$b4b@saturn.mincom.oz.au> chrispw@mincom.oz.au (Chris Wegener) writes:
>I have some SQL that I run under dbaccess to create other SQL which I
>then edit and run, also under dbaccess.
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.