Hi,

is there a way to set a field-seperator for the output? I have to get a
row of fields which also can contain spaces. So the blank for the
field-seperator is unuseful.

I'd tried (found in the web):

$ db2 "SELECT name || ';' || uid FROM foo.bar WHERE login='test'"

returned:
SQL0440N No authorazied routine named "||" of type "" having compatible
arguments was found. SQLSTATE=42884

also tried

$ db2 "SELECT CONCAT (name, ';', uid) as mytest from foo.bar where
login='test'"

returned nearly the same:
QL0440N No authorazied routine named "CONCAT" of type "" having compatible
arguments was found. SQLSTATE=42884

has anyone some hints?

regards,

Kai

Server: IBM DB2 UDB 7.2.2 running on AIX
Client: IBM DB2 8.1 running on Linux

Both
db2 "SELECT name || ';' || uid FROM foo.bar WHERE login='test'"
and
db2 "SELECT name concat ';' concat uid FROM foo.bar WHERE login='test'"
should work

Kai Baumgart wrote:

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands