enclosing output strings in ''

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

enclosing output strings in ''

Rate Topic

Display Mode

Topic Options

Author

Message

arulkumar

Posted 8/4/2008 6:04:01 AM

Forum Newbie

Group: Forum Members
Last Login: 8/6/2008 6:37:56 AM
Posts: 1, Visits: 4

Hi,

I need to unload data from a table in csv format. My output string(s) should be enclosed in '' for all columns.
Is this possible?. can anyone suggest some approach to do it?

Thanks
Arul

Post #12431

gander_ss

Posted 8/4/2008 11:39:26 AM

Forum Member

Group: Forum Members
Last Login: 9/6/2008 8:42:44 AM
Posts: 41, Visits: 93

write an fastexport

and user substr('''',1,1) || colname||substr('''',1,1)

Regards,
Subhash

Regards,
Subhash

Post #12434

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 2:32am