DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 3 matches
Author Message
 Topic: call to TSQL Stored Proc in Before SQL of ODBC Stage
emaher

Replies: 0
Views: 1170

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 14, 2020 5:06 pm   Subject: call to TSQL Stored Proc in Before SQL of ODBC Stage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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 ...
Resolved
 Topic: import .csv fails when delimiter or LF found within value
emaher

Replies: 2
Views: 917

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Aug 30, 2019 10:17 am   Subject: import .csv fails when delimiter or LF found within value
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 u ...
Resolved
 Topic: import .csv fails when delimiter or LF found within value
emaher

Replies: 2
Views: 917

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 22, 2019 5:36 pm   Subject: import .csv fails when delimiter or LF found within value
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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 ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours