string quote clarification

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
vamsi.4a6
Participant
Posts: 334
Joined: Sun Jan 22, 2012 7:06 am
Contact:

string quote clarification

Post by vamsi.4a6 »

I am using below source file which is sample data.I am able to read the data with
quote=none or double or single[Field level property]

col1,col2
1,a
2,b
3,c
4,d


But input data does not have any double or single quote's for any one of the fields?Just what to know why Job is not throwing any error or warning or compilation errror?
jerome_rajan
Premium Member
Premium Member
Posts: 376
Joined: Sat Jan 07, 2012 12:25 pm
Location: Piscataway

Post by jerome_rajan »

it won't and it shouldn't. The Quote=double/single merely tells datastage to ignore the character 'IF' present and read from the character after the leading quote character up to and not including the trailing quote.
If not present, it just reads all the data. if the quotes are present, then it ignores them as specified in your property.
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn

Life is really simple, but we insist on making it complicated.
Post Reply