Search found 53125 matches

by ray.wurlod
Wed Jan 21, 2009 11:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need to capture the timings of Job design change
Replies: 2
Views: 957

Changes are recorded in DS_AUDIT. Compilation times are not, in general, preserved. By whom compiled is never preserved.
by ray.wurlod
Wed Jan 21, 2009 5:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: having exponential values in file
Replies: 3
Views: 1976

... or, more pedantically, failed to tell DataStage not to do so. Investigate the Decimal Output properties in the Aggregator stage.
by ray.wurlod
Wed Jan 21, 2009 5:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compilation error
Replies: 1
Views: 1108

That's all? Any other messages about null handling?

Check thoroughly the extended Nullable properties of the Sequential File stage.
by ray.wurlod
Wed Jan 21, 2009 5:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Server Jobs Not Supported in 8.? ?!?!?
Replies: 2
Views: 821

Totally, one hundred percent false. This myth was first propagated by IBM sales people who either didn't understand what was happening, or who were motivated by the much higher recognition (= commission) for selling enterprise edition. We have had statements from IBM's world wide head of DataStage, ...
by ray.wurlod
Wed Jan 21, 2009 5:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: equal to symbol(=) not taken as a job parameter
Replies: 9
Views: 2869

What is the name of the variable that contains 'error_cod=----|FILENAME= Test_20080801.dat' ?
by ray.wurlod
Wed Jan 21, 2009 5:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Routine to delete data
Replies: 6
Views: 2476

Try building the Cmd variable in a more piecemeal fashion, so that it's easier to read and therefore easier to maintain.
Also please show us the rest, particularly how you are executing the command.
by ray.wurlod
Wed Jan 21, 2009 5:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read operation failure. >
Replies: 23
Views: 6772

Look for permissions changes on anything that may have been made in the last couple of days, particularly the DS_RESENU hashed file and the SYS.MESSAGE hashed file and catdir directory. Indeed, search for anything in the project or in the DSEngine directory that has been modified since the job last ...
by ray.wurlod
Wed Jan 21, 2009 1:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem in Shared Container
Replies: 3
Views: 1533

Shared containers expect their parameters (which can only be of type String or Encrypted) to be passed from the job that contains them. Therefore the default value is empty in the Shared Container - you need to pass the value of $APT_CONFIG_FILE from the parent job.
by ray.wurlod
Wed Jan 21, 2009 1:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: equal to symbol(=) not taken as a job parameter
Replies: 9
Views: 2869

How are you doing the splitting?
by ray.wurlod
Wed Jan 21, 2009 1:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need to load sequential files to Oracle database daily.
Replies: 2
Views: 1150

There's a webinar available at the DSXchange Learning Center dealing with handling files from DataStage job sequences.
by ray.wurlod
Wed Jan 21, 2009 1:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need to load sequential files to Oracle database daily.
Replies: 2
Views: 1150

Welcome aboard. There are many possible solutions, but probably the easiest is one that moves the file to a different directory once that file has been processed. Then you can simply grab "the" file in its directory. Use an ls command to get the file name. Otherwise you can generate the ti...
by ray.wurlod
Wed Jan 21, 2009 1:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read operation failure. >
Replies: 23
Views: 6772

From where are you executing the LOGTO command?

Please check permissions on the project from which you are attempting to LOGTO and the project to which you are attempting to transfer.

Finally please check that you have read permission to the UV.ACCOUNT hashed file in the UV account.
by ray.wurlod
Tue Jan 20, 2009 11:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: JobAuditReport..BeforeJob (DSAttachJob): Job control error (
Replies: 8
Views: 4142

So now answer Craig's question. Ideally post your before-job routine code (encased in Code tags).
by ray.wurlod
Tue Jan 20, 2009 8:28 pm
Forum: General
Topic: Banking, IT and Offshoring
Replies: 0
Views: 537

Banking, IT and Offshoring

IT infrastructure is the backbone of all operations in the modern world. IT needs to be treated as one of the most protected and secure assets by government and by business, especially for banks, where everything it owns is represented by a bunch of ones and zeros stored in a database somewhere. You...
by ray.wurlod
Tue Jan 20, 2009 8:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: get the batchid and transaction id for each transaction
Replies: 5
Views: 2470

In that case you should have posted in the TX forum.