Hi All,
i have a source oracle stage and a piped sequential stage and a target oracle stage.i am getting error as "column missing". In data there are some special characters that causes such problem. hence i enabled the contain terminators then its working fine. Can any body explain how this option in data stage works.In online manuals it is given as "
Use this to specify how End of Record
(EOR) marks are treated in this column. Choose from:
Yes to specify that the data may include EOR marks and they
should not be treated as meaning end of record. For the final
column definition for a CSV file, the Yes option is disabled"
Can anybody explain about EOR marks.
Reg Contain Terminators
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 15
- Joined: Thu Jul 06, 2006 8:59 am
Reg Contain Terminators
Balaji.
If that special character creates the line to break, i.e., which creates a new line character, the rest of teh columns might not get data. And hence you got the error.
By specifing explictly, datastage will wait till the specified character is met.
By specifing explictly, datastage will wait till the specified character is met.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'