When writing to Amazon S3 we have the fields delimited by a comma (,). The rows are enclosed in double quotes. The Quotation Mark property in the S3 stage controls the column quotations. is there a property or setting that will turn off the double quotes for the rows?
Ex: this is what Amazon S3 admin is seeing in the S3 files
"LCLS,306048214593355542501394290,20-JAN-20 02.39.14.565007 PM"
"LCLS,994570338530973782655923294,20-JAN-20 02.43.28.350008 PM"
"LCLS,234645550397601429848923658,20-JAN-20 03.24.18.888892 PM"
Thanks
Amazon S3 output
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
You need to specify the 'Row delimiter' under the 'File format' section on the Stage - Properties tab.
Options are:
Options are:
- Carriage return <CR>
Line feed <LF>
New line <NL>
Tab <TAB>
Unicode escape string
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>