How can i export a query result in an ascii file having....

[Masi]

How can i export a query result in an ascii file having
fixed field size instead of using a delimiter?
I saw "output to" and "unload to" but, the first writes
also column name and column value on each raw, and the
second seems to force the use of a delimiter.

Thanks for any help!
Masi

 

[olded]

In the output statement use 'without headings':

dbaccess -e ificsdc << EDS
output to temp.txt without headings
SELECT * FROM systables
EDS

regards,

Ed
Schaefer

 

[Masi]

It's working, thanks!
But it seems, as in your example, that when it has
to do with a lot of fields, it doesn't put them all in a raw
having one record/raw like i want it, but it decide to put one field/raw!

Thanks a lot for helping me
Masi

 

[olded]

Masi:

I'm not certain what you mean. The unload command creates one record per row, pipe symobol delimited or whatever DBDELIMITER is set to.

If you want to continue this conversation offline, email me at olded@ix.netcom.com

Ed