To Avoid Quote character

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Shree0410
Participant
Posts: 70
Joined: Tue Nov 29, 2005 7:25 pm

To Avoid Quote character

Post by Shree0410 »

Hi Guys,

my requirement is to create a target file with

1. The first line should be column names - for this I can check the "Fist Line is column names" check box on the format tab of Inputs

2. The columns have to ve pipe delimited - for this I can out a '|' character in the space provided for "Delimiter:'

3. I don't want the " wrapping the column values -

What should I do to avoid the '"' in the space provided for "Quote character".

please help.
Shree0410
Participant
Posts: 70
Joined: Tue Nov 29, 2005 7:25 pm

Post by Shree0410 »

can I just put '000' for Quote character?
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

yes
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

If the stage is anything like the Server equivalent, it will tell you that when you attempt to leave the field blank.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply