Exporting positionally

Tank · #1 (**permalink**) 06-01-04, 09:53

AIX 5.2 DB2 8.1.4

I'm trying to export data from my DB2 table
to an ascii file - but in the guide these is no
positional export - only delimiter - which
is not satisfactory for my needs.

Has anyone encountered the samme difficulties?

- And how did you conquer them?

Cheers

n_i · #2 (**permalink**) 06-01-04, 10:08

Code:

export to  file.asc of del
select substr(col1, 1, 10) || substr(char(col2),1,5)) || .... from table

Basically, you generate the entire output line with SQL. The only thing you'll need to do after the export would be to strip double quotes that DB2 uses to enclose the output string.

Tank · #3 (**permalink**) 06-01-04, 10:35

Thank you fella

Works like a charm!!

Cheers

Internet Services

Web Development

Digital Marketing

Consumer Tech