Search found 53125 matches

by ray.wurlod
Tue Feb 19, 2008 1:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lots of warning because of transformation
Replies: 4
Views: 1438

Do some investigation. Create a throw-away job to read the source data and report the actual length of this field (using the Len() function). Just out of curiosity, also report the number of bytes (using the ByteLen() function). Send the result into a delimited text file. Process a few rows, in part...
by ray.wurlod
Tue Feb 19, 2008 1:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: retrieving job status from dsjob
Replies: 8
Views: 2944

cut instead of awk may be marginally more efficient.
by ray.wurlod
Tue Feb 19, 2008 1:43 am
Forum: General
Topic: How to use config files in Datastage
Replies: 4
Views: 1364

So it's basically a list of job parameter values. How is each to be reconciled to a particular job parameter? Do you have any in-house standards for parameter names in jobs, following the "one thing, one name" principle? Now is a good time to start. Think about other components that it would be wise...
by ray.wurlod
Tue Feb 19, 2008 12:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: unable to comiple job with transformer stage
Replies: 3
Views: 2574

What, .NET on Linux?!!

Where do you get that?
by ray.wurlod
Tue Feb 19, 2008 12:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: An unkown error in Server Routine
Replies: 5
Views: 1784

Welcome aboard.

In Director, reset the aborted job. Do not re-compile the job.
You should get an event logged "from previous run".
This will contain valuable diagnostic information.
If you can not solve it yourself, please post the contents of that log message.
by ray.wurlod
Mon Feb 18, 2008 11:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generation of Surrogate Key
Replies: 20
Views: 12959

For Ken: did you mean to add five exclamation points after each of those maniacal laughs?

(See Maskerade by Terry Pratchett)
by ray.wurlod
Mon Feb 18, 2008 11:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: clear status file via command line
Replies: 2
Views: 1396

Yes there is, but clearing the status file is not a magic bullet nor is it a universal panacea. That's why, in the client, it asks "are you sure?" twice. I want to see that you've investigated all other possibilities first. Clearing the status file discards potentially useful diagnostic information ...
by ray.wurlod
Mon Feb 18, 2008 11:28 pm
Forum: General
Topic: How to fetch files from Remote machine for processing in Dat
Replies: 1
Views: 887

FTP Stage streams data directly into your job without creating a local file. If you want to transfer the file before processing it, you need to script that and control it from some DataStage process such as a job sequence or a before-job subroutine.
by ray.wurlod
Mon Feb 18, 2008 11:27 pm
Forum: General
Topic: How to use config files in Datastage
Replies: 4
Views: 1364

Please be more specific about what you mean by "config" files.

For example you can have files (or tables) that describe order of execution, dependencies, parameter values, and lots of other things too.
by ray.wurlod
Mon Feb 18, 2008 9:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Log retrieve
Replies: 4
Views: 1099

By "gone" do you mean automatically purged? In that case, the answer is no - it's gone forever.

You might be able to retrieve the log hashed file from system backups and work your way through that, but it would be a tedious process.
by ray.wurlod
Mon Feb 18, 2008 9:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String to time Conversion
Replies: 3
Views: 2112

OK, then get the format right.

Code: Select all

StringToTime((If Len(InLink.TheString) = 5 Then "0" : InLink.TheString Else InLink.TheString), "%hh:%nn:%ss")
by ray.wurlod
Mon Feb 18, 2008 9:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: server jobs to parallel job
Replies: 1
Views: 863

Asking the same question in multiple forums won't get you multiple answers if the other posters are on their game.

You asked the same question here and I answered it there.
by ray.wurlod
Mon Feb 18, 2008 9:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mainframe File to Ascii (common job)
Replies: 2
Views: 1128

Complex Flat File stage should be able to read this file.
by ray.wurlod
Mon Feb 18, 2008 9:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsimport return code in windows
Replies: 5
Views: 1758

What happens if you capture file unit #2 (stderr in UNIX terminology)?

Code: Select all

dsjob -options project job 2> myfile.txt