Search found 3 matches
- Thu May 14, 2020 5:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: call to TSQL Stored Proc in Before SQL of ODBC Stage
- Replies: 0
- Views: 12276
call to TSQL Stored Proc in Before SQL of ODBC Stage
Hello- Seems to be a few threads on here related to this topic tho I think my use-case is unique. I am loading data from SQL server DB (source) into a Netezza DB (target). Very little transformation (most of the time none) is being done. Our vendor has supplied us with an 'API' in the form of a Stor...
- Fri Aug 30, 2019 10:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: import .csv fails when delimiter or LF found within value
- Replies: 2
- Views: 3598
Thank you for responding. Unfortunately, and like many seem to have experienced, I am not able to affect change in terms of how the file is output and simply have to work with what I get. I ended up going down the path of using a sed command and was able to add it to the Filter property of the Seque...
- Thu Aug 22, 2019 5:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: import .csv fails when delimiter or LF found within value
- Replies: 2
- Views: 3598
import .csv fails when delimiter or LF found within value
I have a .csv file exported from our cisco phone system. It uses semicolon as a delimiter for the columns and appears to have a semicolon after the last column as well as a LF character. The file appears to have the following escaped (using a backslash): null/empty columns, semicolons & line-fee...