DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 2656 matches
Author Message
 Topic: MDM Connector Stage
qt_ky

Replies: 6
Views: 58

PostForum: Infosphere Master Data Management   Posted: Fri Nov 17, 2017 7:42 pm   Subject: MDM Connector Stage
Yes, you need to open a Service Request, sometimes formerly called a PMR and now I see they're starting to call them tickets or cases. IBM is always changing the web site.
 Topic: MDM Connector Stage
qt_ky

Replies: 6
Views: 58

PostForum: Infosphere Master Data Management   Posted: Fri Nov 17, 2017 11:49 am   Subject: MDM Connector Stage
Sure.

Search on your error here.

Search also on the IBM Support Portal if needed:

https://www.ibm.com/support/home/

If your results are slim to none (as they are with the error you detaile ...
 Topic: MDM Connector Stage
qt_ky

Replies: 6
Views: 58

PostForum: Infosphere Master Data Management   Posted: Fri Nov 17, 2017 6:52 am   Subject: MDM Connector Stage
Contact Support.
Resolved
 Topic: Dynamically export files based on Config table
qt_ky

Replies: 14
Views: 123

PostForum: General   Posted: Thu Nov 16, 2017 4:11 pm   Subject: Dynamically export files based on Config table
You got it! Smile
 Topic: NLS Configuration - Oracle character set to '?'
qt_ky

Replies: 7
Views: 155

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 12:34 pm   Subject: NLS Configuration - Oracle character set to '?'
We don't set any existing environment variable; we add a new one named NLS_LANG and give it a default value that matches the same NLS_LANG value reported by Oracle.
Resolved
 Topic: Dynamically export files based on Config table
qt_ky

Replies: 14
Views: 123

PostForum: General   Posted: Thu Nov 16, 2017 12:28 pm   Subject: Dynamically export files based on Config table
Well, I thought it used to be called DSUtilityRunJob() but I did some poking around and only found one called UtilityRunJob() which is actually what my old test job has in it. I wonder if it got renam ...
Resolved
 Topic: Last Day of Month Future Past Derivation?
qt_ky

Replies: 5
Views: 124

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 9:02 am   Subject: Last Day of Month Future Past Derivation?
Glad we could help! Thanks for sharing the variables you implemented.
 Topic: Retry after failure - JDBC connector
qt_ky

Replies: 2
Views: 188

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 8:48 am   Subject: Retry after failure - JDBC connector
I don't know about the JDBC stage. The Oracle Connector stage does have some retry yes/no settings and sub-settings you can enable. Hopefully IBM would provide the same functionality on the JDBC Conne ...
 Topic: Retry on JDBC connector
qt_ky

Replies: 3
Views: 377

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 8:43 am   Subject: Retry on JDBC connector
That is what we had to do also, because our network is so alarmingly unreliable.

Our highest level of sequence jobs--the ones we place on schedule--perform auto-retry logic by using a loop. The loo ...
Resolved
 Topic: Dynamically export files based on Config table
qt_ky

Replies: 14
Views: 123

PostForum: General   Posted: Thu Nov 16, 2017 8:32 am   Subject: Dynamically export files based on Config table
Welcome to DataStage, where you often have 2 or 3 ways to accomplish anything!

In this case you might want to try using a Server job to read records from the table, then a Transformer stage to call ...
 Topic: NLS Configuration - Oracle character set to '?'
qt_ky

Replies: 7
Views: 155

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 16, 2017 8:04 am   Subject: NLS Configuration - Oracle character set to '?'
When I am extracting from Oracle, I usually find it is sufficient to take the Oracle database's NLS_LANG value and set the same thing as an environment variable at the DataStage project level in the D ...
 Topic: Losing the null value
qt_ky

Replies: 9
Views: 514

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 13, 2017 1:55 pm   Subject: Losing the null value
This was just posted a few days ago:

JR58660: In the PX transformer stage, nullable stage variables are incorrectly set to NULL at the start of every link evaluation cycle
https://www-01.ibm.com/s ...
Resolved
 Topic: Last Day of Month Future Past Derivation?
qt_ky

Replies: 5
Views: 124

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 13, 2017 1:48 pm   Subject: Last Day of Month Future Past Derivation?
Just to clarify, are you asking about using parallel date functions within a parallel job or is this being done within a sequence job?

One way to approach it is to take the day of the month of the ...
 Topic: Remove multiple special characters from leading and trailing
qt_ky

Replies: 16
Views: 320

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 13, 2017 8:56 am   Subject: Remove multiple special characters from leading and trailing
You could use multiple nested Trim() functions--one for each special character. Please consult the product documentation on the Trim() function to specify options for leading and trailing characters.
 Topic: Can DataStage create Basic graphs and visualizations?
qt_ky

Replies: 5
Views: 144

PostForum: General   Posted: Thu Nov 09, 2017 3:49 pm   Subject: Can DataStage create Basic graphs and visualizations?
As far as I know, such a feature has never been part of DataStage; it does not claim to be a data visualization tool. Some of the IBM Cognos products are included as supporting programs but their use ...
 

 Jump to:   



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