Search found 53125 matches

by ray.wurlod
Fri Oct 02, 2015 4:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare DSLink1.Column1 = DSLink1.Column5
Replies: 2
Views: 1669

Right click on the red expression and choose "Validate Derivation" from the menu; the expression editor will tell you what it thinks is wrong with the syntax - for example field and link names are case sensitive. Maybe you mis-spelled "Count" as "Cont".
by ray.wurlod
Fri Oct 02, 2015 4:40 pm
Forum: General
Topic: Info Server 11.5
Replies: 1
Views: 9919

A couple of weeks is NOT enough to make any comments about stability.
by ray.wurlod
Fri Oct 02, 2015 4:39 pm
Forum: General
Topic: Datastage Mainframe Edition GA!
Replies: 11
Views: 2538

That claim was also made in 1999, so that COBOL programmers commanded huge prices preparing for the Year 2K squib.
by ray.wurlod
Thu Oct 01, 2015 6:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RCP on ODBC stage - MySQL
Replies: 4
Views: 1927

What do you infer from "waitForWriteSignal"?
by ray.wurlod
Thu Oct 01, 2015 5:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Drop Unmatched Fields - ODBC
Replies: 3
Views: 2524

If you're using an ODBC Connector you can change the properties so that metadata mismatches cause Warning rather than Failure.
by ray.wurlod
Thu Oct 01, 2015 5:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameter Set Changes - Deploy
Replies: 2
Views: 1884

Manually for me too, after performing a Usage Analysis so that I can recompile any jobs that use the Parameter Set once changed. (This is one of the few times we compile in production, and it requires an extra step in the approvals processes.)
by ray.wurlod
Thu Oct 01, 2015 5:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Varchar to decimal transformation in generic RCP job
Replies: 7
Views: 2968

You could try using a Modify stage. Every specification in a Modify stage can be a job parameter.
by ray.wurlod
Thu Oct 01, 2015 4:39 pm
Forum: General
Topic: Datastage Mainframe Edition GA!
Replies: 11
Views: 2538

Still a few sites left using mainframe jobs here and there around the world.
by ray.wurlod
Wed Sep 30, 2015 4:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Euro Symbol in Datastage
Replies: 8
Views: 5896

I'm not at a DataStage machine at the moment, but I seem to recall there's a parameter in uvconfig relating to handling of the Euro character.
by ray.wurlod
Wed Sep 30, 2015 4:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Derivation
Replies: 6
Views: 1804

... with just a little added complexity if your definition of "does not have a value" includes the possibility of NULL.

Code: Select all

If IsNull(InputLink.Column_A) Or (Trim(InputLink.Column_A) <= ' ') Then '/' Else '_'
by ray.wurlod
Wed Sep 30, 2015 4:36 pm
Forum: General
Topic: Datastage Mainframe Edition GA!
Replies: 11
Views: 2538

There are no mainframe jobs in version 11.3. There are mainframe jobs in version 9.1.
by ray.wurlod
Wed Sep 30, 2015 4:31 pm
Forum: General
Topic: Error adding to schedule: Access is denied
Replies: 3
Views: 1730

Then I can only suggest that it was not done properly. Or perhaps you also have to configure access to the Scheduling Service on Windows (on the Engine machine).
by ray.wurlod
Mon Sep 28, 2015 7:03 pm
Forum: General
Topic: Search for string on designer canvas
Replies: 8
Views: 3929

Meanwhile you can query the DS_JOBOBJECTS records for that particular job number. SELECT * FROM DS_JOBOBJECTS WHERE JOBIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job name>>') AND EVAL "@RECORD" LIKE '%<<string>>%'; This query can be run from a dssh shell or, if you have DataStage Ad...
by ray.wurlod
Mon Sep 28, 2015 7:00 pm
Forum: General
Topic: Installation Issue: Installing IA/Engine on Services Tier
Replies: 8
Views: 4388

Check with IBM Support. Engine tier installation should include a product selection window.
by ray.wurlod
Mon Sep 28, 2015 6:58 pm
Forum: General
Topic: run rexec in execute command stage
Replies: 7
Views: 3132

Does the rexec session require a password? Authentication key?