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?
string quote clarification
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
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.
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.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.