--- In firebird-support@yahoogroups.com, "Marvin" <gallagher_98@...>
wrote:

>
> Hi guys,
>
> I'm trying to write an extraction shell script that will be crontabbed
> in a unix box. At certain days, it will extract out some data and save
> them as a file via firebird's iSql.
> Here's my problem.
> Because the files extracted will be input for another program, i'l
> need to format the search results in such that the columns are
> seperated by a delimiter.
>
> Ex:
>
> Currently, querying in iSql will give sth like
>
> USERNAME USERID
> ============================== ==========
> UAT 02 uat02
> UAT 03 uat03
>
> Say i choose to use a # as my column delimeter, Is there a way i can
> set iSql to return it as the following instead?
>
> #UAT 02#uat02#
> #UAT 03#uat03#

Not that I am aware, but you could possibly use SET LIST ON;
This would return

USERNAME UAT 02
USERID uat02

USERNAME UAT 03
USERID uat03

etc.

I imagine that would be reasonably easy to parse (data is at character
34 onwards). Alternatively it is a reasonably trivial thing for you to
write your own console application to do what you require.

Adam