Search found 53125 matches

by ray.wurlod
Thu Nov 12, 2015 3:10 pm
Forum: General
Topic: Attempting to Cleanup after ABORT raised in job
Replies: 5
Views: 5966

Did the job run/hang through midnight?

The file name within BPnnn.O includes the date and time in internal format.

Re-compiling the job should correct the problem.
by ray.wurlod
Wed Nov 11, 2015 5:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Prefix Column Name with Column Number
Replies: 4
Views: 1887

You can't do it that way because of the restriction in the Sequential File stage (and, indeed, throughout DataStage) prohibiting column names beginning with numeric characters. Since the number of columns is so small, write the data without column headings. Invoke ExecSH as a before-job subroutine t...
by ray.wurlod
Wed Nov 11, 2015 5:25 pm
Forum: General
Topic: I passed the 000-421 DataStage v8.5 certification!
Replies: 18
Views: 45158

It probably is worthwhile.

Version 11.3 exams for QualityStage and Information Analyzer are not yet available, but I suspect that the same composite certification will be available once they are.
by ray.wurlod
Wed Nov 11, 2015 2:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Integrating Salesforce with datastage
Replies: 7
Views: 3420

SOAP should be OK, via a Web Service Transformer stage (or, perhaps, a Web Service Client stage).
by ray.wurlod
Wed Nov 11, 2015 2:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Prefix Column Name with Column Number
Replies: 4
Views: 1887

Welcome aboard.

Not sure what you're trying to accomplish.

There should be no restriction on what you put into line 1 in the file. How are you attempting to do this?
by ray.wurlod
Wed Nov 11, 2015 2:15 pm
Forum: General
Topic: I passed the 000-421 DataStage v8.5 certification!
Replies: 18
Views: 45158

Certification exam for version 11.3 has been available since May 2015.
by ray.wurlod
Tue Nov 10, 2015 2:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using Complex flat file stage to read a pipe delimited filed
Replies: 6
Views: 3130

Complex Flat Files use fixed width format. Therefore there is no scope for specifying a delimiter.

Use a Sequential File stage to read the file using a single VarChar column and perform the record type identification and parsing in downstream stages such as Transformer or Column Import.
by ray.wurlod
Tue Nov 10, 2015 2:13 pm
Forum: General
Topic: Report of last modification date of jobs in a projects
Replies: 7
Views: 3645

Information Server Manager is a client which, with an Eclipse plug-in, will allow you to check components into and out of SVN. So you don't need to write anything. Developers who are systematic about check in/check out should not be able to do any damage if given access to Information Server Manager...
by ray.wurlod
Mon Nov 09, 2015 3:18 pm
Forum: General
Topic: Installation of DS Client version 11.3
Replies: 6
Views: 962

You won't see server jobs in the Palette until you have created one. When a server job is open, then you see the Server Job palette.
by ray.wurlod
Sun Nov 08, 2015 7:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Failed to distribute component
Replies: 3
Views: 2688

Check that you have password-less rsh configured correctly if Node1 is remote.

Check that the USADDR rule set has been provisioned, if you have made any overrides, etc., to it.
by ray.wurlod
Fri Nov 06, 2015 8:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion of varbinary data to varchar/char
Replies: 3
Views: 2305

Varbinary can be called Raw. In a Transformer or Modify stage specify a function that converts from Raw to String.
by ray.wurlod
Thu Nov 05, 2015 10:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Newline within XML tags
Replies: 8
Views: 2906

Do you regard Notepad++ as truly XML-aware? Try using a browser.
by ray.wurlod
Thu Nov 05, 2015 10:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential Execution on Db2 Causing Deadlock
Replies: 2
Views: 1588

Connector stages typically do create two connections, one an inactive "control" connection, and one to do the actual work. I've been caught by this in a number of scenarios, and it's not just DB2; I've experienced the same with Netezza. However the inactive connection ought not to take any...
by ray.wurlod
Thu Nov 05, 2015 3:35 pm
Forum: General
Topic: Sequencer design
Replies: 5
Views: 1720

Designing a Sequencer is simple; you have only one choice, whether to run it in Any mode or All mode. Your question is about a Sequence. Take an extra trigger from your Execute Command activity to handle the <100 case. Take this to an Any Sequencer. Take an unconditional trigger from JobActivity2 to...
by ray.wurlod
Wed Nov 04, 2015 3:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ISD Input/Output stage documentation
Replies: 3
Views: 2153

The manual you need is IBM InfoSphere Information Services Director User's Guide.