AIX 5.2 DB2 8.1.4

Hi guys

I'm trying to export database tables to positional files
which works well with alle character and numerical values
But any attempt to concatenate dates results in error:

--x--

EXPORT TO "u:\mdr.txt" OF DEL MESSAGES "u:\mdr.log"

SELECT (A.d_anmdato)||(a.d_koncdato)

FROM mdr.t_aflv04 A

--x--

The select by itself reports:


com.ibm.db.DataException: Der er
opstået en fejl i databasesystemet. : [IBM][CLI
Driver][DB2/6000] SQL0440N No authorized routine named "||" of
type "FUNCTION" having compatible arguments was found.
SQLSTATE=42884


Does anyone know a workaround?

Cheers

char(date1)||char(date2)

Thanks Sathyaram

The only problem with this approach is that it superseeds
the default settings on the export utility and returns the
dates in dd-mm-yyyy instead of ISO which I require.

Do I really have to cut the date to pieces and string it together?

Cheers

Have you tried using modified by datesiso ..

If this does not work with char(date1) then you can try using CTE (Not tested, but you can give a try)

export to file1.del of del
modified by datesiso
with temp as
(
select date1,date2 from table1
)
select char(date1)||char(date2) from temp

If you RTFM to look up the definition of the CHAR function you'll see that it allows you to specify date string format, something like this:

Hey n_i

I did just that and it worked, though i still had to cut
out the '-''s afterwards - Thanks both.

Cheers