TPT, how to output columns enclosed in quotes?

Tools & Utilities
Enthusiast

TPT, how to output columns enclosed in quotes?

So, I'd like a database that's pulling in a file that looks like this:

Right now I have this...

blah blah, 123, bleh bleh

I want...

"blah blah", "123", "bleh bleh"

Right now I'm using this:

/* 235 */      ATTRIBUTES

/* 236 */      (

/* 237 */         FileName = 'sales_detail_fact.txt', 

/* 238 */         Format = 'DELIMITED', 

/* 239 */         OpenMode = 'Write', 

/* 240 */         IndicatorMode = 'N', 

/* 241 */         TextDelimiter = ','

/* 242 */      )

Any help? Can't figure it out in the documentation.

2 REPLIES
Teradata Employee

Re: TPT, how to output columns enclosed in quotes?

Set QuotedData to 'yes'.

-- SteveF
Enthusiast

Re: TPT, how to output columns enclosed in quotes?

Thanks, worked!