Search found 53125 matches

by ray.wurlod
Tue Nov 09, 2010 8:59 pm
Forum: General
Topic: url to file
Replies: 9
Views: 2764

Fix Central, like every other PACK download.
by ray.wurlod
Tue Nov 09, 2010 5:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing complete log into a sequential file
Replies: 4
Views: 1771

Assuming you're using local repository logging create a server job to read the job number from DS_JOBS. Create a second server job that uses this number as a parameter in the log hashed file name (RT_LOGnnnn). You can search DSXchange for log file metadata. If that assumption does not hold you can w...
by ray.wurlod
Tue Nov 09, 2010 3:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get -linkinfo from the DSJOB command
Replies: 3
Views: 2101

What DID you get?

Have you looked at the -stageinfo option for a row count through the stage?
by ray.wurlod
Tue Nov 09, 2010 3:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_CombinedOperatorController,0: *** glibc detected ***
Replies: 3
Views: 2210

Could be a corrupted memory chip. Have your hardware checked.
by ray.wurlod
Tue Nov 09, 2010 3:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sybase OC Stage with multiple read links
Replies: 4
Views: 1666

The stage only supports one output link. You can not have multiple read links. You would need multiple stages. You can combine these within the job, for example using a Funnel stage.
by ray.wurlod
Tue Nov 09, 2010 3:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing complete log into a sequential file
Replies: 4
Views: 1771

Open Director. Select job. Open Log view. Open Project menu. Choose Print. Fill in required options including checking the "Print to File" check box.
by ray.wurlod
Tue Nov 09, 2010 3:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: new line character as deimiter
Replies: 19
Views: 6554

How do you expect the tr command to know which file to process? You have to tell it - it is not picked up from the filename property in the stage.
by ray.wurlod
Tue Nov 09, 2010 3:14 pm
Forum: General
Topic: Job Sequence calling Server jobs and sub-jobs
Replies: 2
Views: 1257

Yes, cause everything to log a warning in the sequence if the activity does not finish with success status, then intercept and process any warning that is generated. If every sequence is so set, all warnings will propagate to the top-level sequence, in which you might organise restartability, notifi...
by ray.wurlod
Tue Nov 09, 2010 6:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: I need to run the job with 0 warnings
Replies: 2
Views: 1826

Your data do not match your metadata, as I noted in replying your other post. Did you think posting the same question twice would yield some different answer? We're a bit more professional than that!
by ray.wurlod
Tue Nov 09, 2010 6:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning while Iam extracting the data from sequential file
Replies: 3
Views: 2582

I need to execute the job without warnings... That's easy enough. All you have to do is to prevent the warnings from being generated, by constructing your job design correctly. For example, "WMI,7,MES028\n2010-1" is clearly not a date, but you have attempted to do some kind of date proces...
by ray.wurlod
Tue Nov 09, 2010 6:03 am
Forum: General
Topic: How to fetch link info into a database
Replies: 1
Views: 1195

None of the above. Download (free) ETLstats from Kim Duke's website - this has everything you have asked for.
by ray.wurlod
Tue Nov 09, 2010 6:02 am
Forum: General
Topic: concatenate of three inut files
Replies: 3
Views: 1637

if [ -z detail.txt ] then copy header.txt+trailer.txt > newfile.txt else copy header.txt+detail.txt+trailer.txt > newfile.txt fi Since you are running parallel edition on Windows you have full access to UNIX shell scripting techniques as shown above. I'm sure there is equivalent functionality in DO...
by ray.wurlod
Tue Nov 09, 2010 5:59 am
Forum: General
Topic: Job Information
Replies: 7
Views: 2925

What does the ps report for the parent process show?

What does the ps report for its parent process show?

Continue up the ladder of parent processes until you get to the init process (process ID = 1).

It would help if your particular UNIX had a ptree command.
by ray.wurlod
Tue Nov 09, 2010 4:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Runtime Error
Replies: 16
Views: 5485

Find out what the invalid character is and get rid of it.
by ray.wurlod
Tue Nov 09, 2010 4:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Possibilities in re-use of jobs ?
Replies: 4
Views: 1221

Welcome aboard. There are many opportunities for creating re-usable components, such as Data Connections, Parameter Sets and Routines. As well it is possible to create re-usable jobs using techniques such as schema files and runtime column propagation. You might like to research these in the DataSta...