DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 1433 matches
Author Message
 Topic: Reading SAS code through datastage
asorrell

Replies: 5
Views: 912

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Dec 03, 2018 9:00 pm   Subject: Reading SAS code through datastage
So, just to insure I understand... You have been tasked to replace a SAS process that reads a COBOL binary file with a DataStage process? If so, feeding DataStage from a SAS application won't accomp ...
Resolved
 Topic: DB2 vs SQL Server for repositories?
asorrell

Replies: 5
Views: 795

PostForum: General   Posted: Mon Dec 03, 2018 8:41 pm   Subject: DB2 vs SQL Server for repositories?
Craig! Stop talking about Ray like that! Smile
 Topic: Stuck DataStage Parallel Job
asorrell

Replies: 1
Views: 531

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 27, 2018 7:56 am   Subject: Stuck DataStage Parallel Job
The VOCabulary hashed file is a very critical part of the "uniVerse" database that supports every DataStage project. It tracks a lot of critical pieces required in a working DataStage project.

The ...
 Topic: Hierarchical stage: Error 500 using Recursive to List
asorrell

Replies: 4
Views: 855

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 21, 2018 12:10 pm   Subject: Hierarchical stage: Error 500 using Recursive to List
You didn't answer one of my questions - have you used this option before in another job?

I'd recommend proceed to step 4...

The "Caused by: java.lang.NullPointerException" message seems to indic ...
 Topic: COBOL file without copybook
asorrell

Replies: 99
Views: 7702

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 21, 2018 10:04 am   Subject: COBOL file without copybook
When Franklin said "Map it to the copybook" I believe he meant FIX the copybook to make it reflect reality. Then use the Complex Flat File stage to read the data using the new copybook.

You will ...
 Topic: Oracle 12c Update Jobs are failing with deadlock
asorrell

Replies: 3
Views: 735

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 21, 2018 9:31 am   Subject: Oracle 12c Update Jobs are failing with deadlock
Also check the exact release of both Information Server and Oracle and insure they are compatible.

For example, Oracle 12c, Release 2 is only certified on Information Server 11.7 or higher.

You ...
 Topic: Hierarchical stage: Error 500 using Recursive to List
asorrell

Replies: 4
Views: 855

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 21, 2018 9:00 am   Subject: Hierarchical stage: Error 500 using Recursive to List
Hmm - I've used the stage a lot and never had that happen, so I don't recognize the error. It looks like it can't find the properties file in WebSphere that supports that option. Have you used that ...
 Topic: Is there a licensing cost for the Connector Migration tool?
asorrell

Replies: 5
Views: 817

PostForum: General   Posted: Wed Nov 21, 2018 7:54 am   Subject: Is there a licensing cost for the Connector Migration tool?
Ray - is it in Passport Advantage now?
Resolved
 Topic: Migrate Netezza connector stage to Snowflake Connector stage
asorrell

Replies: 1
Views: 616

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 21, 2018 7:38 am   Subject: Migrate Netezza connector stage to Snowflake Connector stage
The Snowflake Connector has only been out for a few months on the latest release of Information Server (11.7). At this point you are probably one of the first customers working on a deployment. I'm ...
 Topic: How can I backup Information Analyzer assets?
asorrell

Replies: 2
Views: 748

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Mon Nov 12, 2018 9:37 am   Subject: How can I backup Information Analyzer assets?
The answer isn't simple. Information Analyzer uses several components including the XMETA repository and the IADB.

You can start with this link:
https://www.ibm.com/support/knowledgecenter/en/ ...
Resolved
 Topic: custom transform routine - undefined symbol
asorrell

Replies: 3
Views: 806

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 10, 2018 7:39 am   Subject: custom transform routine - undefined symbol
The error was misleading. We had several problems that apparently combined to confuse the situation.

The C routine had arguments that were unsigned char* and the parallel routine definition only ...
Resolved
 Topic: custom transform routine - undefined symbol
asorrell

Replies: 3
Views: 806

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 27, 2018 9:42 pm   Subject: custom transform routine - undefined symbol
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
We're working on a custom transformer routine that calls a custom C++ function. The C++ function has been compiled with the same compiler options as DataStage.

We've got the lib path in the LD_LI ...
 Topic: Backing up IADB
asorrell

Replies: 8
Views: 1434

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Tue Sep 11, 2018 8:17 pm   Subject: Backing up IADB
I would recommend doing the purge in very small chunks initially to determine timings / impact. The admin at a previous site initially kicked it off to purge an entire month and the purge process no ...
 Topic: Junk characters when moving data from VARCHAR to CHAR
asorrell

Replies: 4
Views: 774

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 14, 2018 12:24 pm   Subject: Junk characters when moving data from VARCHAR to CHAR
Because you have not identified what kind of "junk" you are getting - my best guess is that your project is still using the default value 0x0 (Hex 0) for padding CHAR fields. CHAR fields are always ...
 Topic: DataStage MD5 Implementation
asorrell

Replies: 12
Views: 3238

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 14, 2018 11:58 am   Subject: DataStage MD5 Implementation
I know I'm resurrecting an old thread, but just encountered this, and it IS now documented.

The checksum stage does use MD5, but unfortunately the checksum stage changes the data being hashed witho ...
 

 Jump to:   



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