DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 974 matches
Author Message
 Topic: Permission denied
Mike

Replies: 1
Views: 24

PostForum: General   Posted: Fri Apr 28, 2017 7:57 am   Subject: Permission denied
Check the system requirements for your specific version of Information Server and then try it with a supported browser.

I haven't checked in quite a while, but IE and Firefox used to be the only br ...
 Topic: Datastage to informatica Migration
Mike

Replies: 7
Views: 92

PostForum: General   Posted: Tue Apr 25, 2017 8:36 pm   Subject: Datastage to informatica Migration
Good advice from Craig as usual and particularly valuable for your scenario since he has expertise in both tools.

I've always been a firm believer that once you've chosen one of the top enterprise ...
 Topic: Change Capture stage is inactive
Mike

Replies: 2
Views: 58

PostForum: General   Posted: Tue Apr 25, 2017 7:29 am   Subject: Change Capture stage is inactive
If you have the Data Quality bundle for Information Server, then you will only have access to the DataStage core. Most of the special purpose stages will not be available to you.

Verify your Inform ...
 Topic: Job compile issue
Mike

Replies: 2
Views: 111

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 24, 2017 9:40 am   Subject: Job compile issue
With something like this I would suspect some potential metadata corruption causing the issue.

Are you doing a regular compile on your recompile or are you doing a force compile? See if the error r ...
 Topic: Modify the length of a field in all jobs in a project
Mike

Replies: 4
Views: 82

PostForum: General   Posted: Fri Apr 21, 2017 1:06 pm   Subject: Modify the length of a field in all jobs in a project
Craig's very detailed explanation is exactly how I would approach it.

Also be aware that you will miss cases where the column gets mapped to a different name and that other column also needs its si ...
 Topic: Lookup with a Like Operator
Mike

Replies: 4
Views: 194

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 18, 2017 4:26 pm   Subject: Lookup with a Like Operator
Is it always a single starting letter?

If yes, do 2 lookups: 1) full string, and 2) first character.

You could make the second lookup conditional on not finding a match with the full string.

...
 Topic: Partial records are loaded while joining
Mike

Replies: 2
Views: 125

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 18, 2017 7:10 am   Subject: Partial records are loaded while joining
If you are using a join stage, check your link order. Your source dataset should provide the data for the left link and your reference dataset should provide the data for the right link Your results a ...
 Topic: Command stage output
Mike

Replies: 7
Views: 232

PostForum: General   Posted: Mon Apr 17, 2017 3:39 pm   Subject: Command stage output
Since you seem to be out of ideas...

I wouldn't be running Windows commands even on a Windows installation. Take advantage of the MKS toolkit and run a unix-style find command inside a unix shell. ...
Resolved
 Topic: How can I set the lookup stage adding an OR as Condition
Mike

Replies: 4
Views: 133

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Apr 16, 2017 11:11 am   Subject: How can I set the lookup stage adding an OR as Condition
2 distinct lookup keys means 2 lookups:

Lookup1 -- reject link --> Lookup 2 -- reject link --> Additional Processing
| |
| success link | success li ...
Resolved
 Topic: Configuration File - Scratchdisk allocation
Mike

Replies: 4
Views: 234

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 29, 2017 3:16 pm   Subject: Configuration File - Scratchdisk allocation
Try putting your ramdisk into its own non-default pool.

Mike
Resolved
 Topic: ExecuteSQL function within User Variable activity
Mike

Replies: 10
Views: 932

PostForum: General   Posted: Fri Mar 24, 2017 4:25 pm   Subject: ExecuteSQL function within User Variable activity
Scroll up and read Craig's first reply in the thread. That pretty much sums up what you would need to do.

Mike
 Topic: timestamp_from_string with microseconds in Modify Stage
Mike

Replies: 7
Views: 412

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 16, 2017 4:16 pm   Subject: timestamp_from_string with microseconds in Modify Stage
I went back and reread your original post... and took note that your output was a parallel dataset.

In my quick test job, I just used a peek stage after the modify.

I substituted a dataset and t ...
 Topic: timestamp_from_string with microseconds in Modify Stage
Mike

Replies: 7
Views: 412

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 16, 2017 2:37 pm   Subject: timestamp_from_string with microseconds in Modify Stage
I just whipped up a quick test job and am getting the expected microseconds.

Here is my modify spec:OUTPUT_VALUE = timestamp_from_string["%yyyy%mm%dd %hh:%nn:%ss.6"] ( ...
 Topic: timestamp_from_string with microseconds in Modify Stage
Mike

Replies: 7
Views: 412

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 15, 2017 5:00 pm   Subject: timestamp_from_string with microseconds in Modify Stage
I can confirm that timestamp_from_string in a Modify stage in version 11.3 works exactly as expected with microseconds for me. Perhaps a version 8 bug?

Mike
 Topic: DB2 Connector Reject setting
Mike

Replies: 3
Views: 200

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 09, 2017 1:17 pm   Subject: DB2 Connector Reject setting
Consider that rejecting a row and logging a warning message are not the same thing.

What warning limit did your job run with and how many warning messages were logged when the abort was triggered? ...
 

 Jump to:   



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