Search found 53125 matches

by ray.wurlod
Fri Nov 18, 2011 2:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: why all the Sequential file stages cant start at the same ?
Replies: 4
Views: 1703

Please prove your assertion that they don't all start at the same time. Have player processes dump their PIDs into the log at startup time and compare the start times in the log.
by ray.wurlod
Fri Nov 18, 2011 2:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating Unique IDs Based on Timestamp with Milliseconds
Replies: 12
Views: 6295

No surprise really. Just look at the "Microsoft time" estimates when Windows is copying large files.
by ray.wurlod
Fri Nov 18, 2011 2:37 am
Forum: General
Topic: Why Universe is not available in PX ?
Replies: 5
Views: 1504

UniVerse databases can be accessed via ODBC.

The server engine was originally built on UniVerse, so it was easy to provide a "native" interface. The parallel engine was built from scratch by Torrent Systems and their predecessors, and they knew nothing about UniVerse or UniData.
by ray.wurlod
Thu Nov 17, 2011 10:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage function
Replies: 10
Views: 4761

BASIC Transformer has in-built Ereplace() function.
by ray.wurlod
Thu Nov 17, 2011 2:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Code usage from Server jobs environment to Parallel jobs ???
Replies: 5
Views: 1467

1. Not possible in version 7.
2. It's totally different. A different mindset is required. Read Parallel Job Developer's Guide as well as the connectivity guide for any database to which you want to connect.
by ray.wurlod
Thu Nov 17, 2011 2:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage warnings unlimited option
Replies: 2
Views: 1831

Be aware that unlimited warnings can cause your project to become corrupted, or the log to become corrupted, if too many entries are logged.

Prefer to write jobs that don't throw warnings.
by ray.wurlod
Thu Nov 17, 2011 2:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key - stat file
Replies: 4
Views: 2771

So, to clarify, you want to know the next (or, perhaps, current) value without actually incrementing the state file?
This will, of course, be different on different nodes.
by ray.wurlod
Thu Nov 17, 2011 2:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to handle newline character reading from sequential file
Replies: 24
Views: 19263

To clarify Craig's answer, there are more columns in the Columns grid. Scroll the Columns grid to the right to find the "Contains terminators" property.

Note that, for this to work properly, character strings containing terminators must be quoted.
by ray.wurlod
Thu Nov 17, 2011 2:33 pm
Forum: General
Topic: Regaining Scaratch disk space
Replies: 10
Views: 2994

:idea:

Write jobs that never abort.
by ray.wurlod
Thu Nov 17, 2011 2:30 pm
Forum: General
Topic: Clenaup residual processes after abort
Replies: 2
Views: 1714

Do you have the DataStage deadlock daemon (dsdlockd) running?
by ray.wurlod
Thu Nov 17, 2011 2:29 pm
Forum: General
Topic: determining &PH& current type
Replies: 18
Views: 5571

It's a mystery. You're getting Type1 behaviour but without the .Type1 indicator file. Have you actually resized &PH& to Type19?
by ray.wurlod
Thu Nov 17, 2011 2:27 pm
Forum: General
Topic: Parameters for executable jobs
Replies: 7
Views: 2080

Jobs are never executable files. Can you please clarify what kind of object you are discussing?

Server jobs have their "compiled" information in RT_CONFIGxxx table, while parallel jobs have their osh scripts in RT_SCxxx subdirectory.
by ray.wurlod
Thu Nov 17, 2011 2:23 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: job is unable to come to finished state
Replies: 5
Views: 10539

I wonder what the resolution was?
:?:
by ray.wurlod
Thu Nov 17, 2011 12:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Difference between two timestamps
Replies: 9
Views: 3965

Link should be OK now.
by ray.wurlod
Wed Nov 16, 2011 10:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage function
Replies: 10
Views: 4761

Search DSXchange for the pxEreplace function, which will handle your requirement even if there are spaces and commas in your data.

Otherwise do what SURA was attempting to suggest - Trim() to get rid of the spaces and Convert() to change the commas to semi-colons.