Re: Possible to set field separator on command line dbaccess

Hi. The easy way is to add constants to your select list. Something like this: ># >dbaccess databasename << EOF > /tmp/outputfile > >select field1,"|",field2,"|" from table where field1 like "foobar%"> >EOF You can also use the unload that make this automaticaly. Somethink like this: ># >dbaccess databasename << EOF > >unload to /tmp/outputfile select field1, field2, from table where field1 like "foobar%"> >EOF Bye