Re: Version problem

--- "Obnoxio The Clown" <obnoxio@hotmail.com> > wrote: >From: NDSTURNERBUND@t-online.de (Dirk Emmermacher) >> >>Hello clown! >> >> > Oh. What's wrong with >> >> > dbaccess dbname <<! >> > OUTPUT TO PIPE "cat | dbaccess dbname" WITHOUT HEADINGS >> > SELECT "UNLOAD TO /NTB3/ntb3/" || tabname CLIPPED || >> > ".dat DELIMITER "#", >> > "SELECT * FROM " || tabname CLIPPED || ";" >> > FROM systables >> > WHERE tabtype = "T" >> > AND tabid > 100 >> > ORDER BY tabname >> > ! >> > >> > ??? Seems to save the cost of the Informix-SQL license.... >> >>Nothing is wrong with this script... >>... but the version 4.00 don't use dbaccess. > >And I suppose the SQL doesn't support the || syntax...hmmm...sure there must >be some way.... > >But unlike so many other strange people on the group, I don't have access to >old versions (or even ISQL) Well, in version 0.00.1 the PDQ(Pretty Dumb Query) Engine doesn't support it. I was able to test even though there's a leak in the bellows that operates the old computer that system is loaded on, but I had to work the pedals twice as fast as usual.... I checked ISQL also and the second occurance of || was where the syntax error was indicated. == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net