Search found 53125 matches

by ray.wurlod
Fri Sep 21, 2007 3:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Document or tutorial
Replies: 6
Views: 2564

You can stop looking, there isn't one. There is a Tutorial that ships with the DataStage software - ask your employer for the CD and a project so that you can install the same.
by ray.wurlod
Fri Sep 21, 2007 2:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sequential File
Replies: 22
Views: 3256

Please advise:
(a) exactly what tr command was executed (and specifically what quote characters were involved)
(b) the exact error message that was generated by the tr command
(c) what version of the operating system you are using (uname -a)
by ray.wurlod
Fri Sep 21, 2007 2:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Splliting of 1 Input col into 4 Output cols on word boundary
Replies: 5
Views: 1061

Etiquette Note When a problem has been solved, the OP marks the thread as Resolved and adds a post indicating how the problem was solved, to aid future searchers. I suspect you used either the Fmt() or the Fold() function after searching the forum, but it would be nice to know exactly what you did ...
by ray.wurlod
Fri Sep 21, 2007 2:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ADS as ETL tool for Telecom sector DWH
Replies: 9
Views: 2019

There is a telco in India using a server-only DataStage implementation, relying upon multi-instance jobs to achieve scalability. They are processing crores of records per day, and the Data Warehouse is many tens of TB in size. Could be approaching 100TB by now. They're happy with it.
by ray.wurlod
Fri Sep 21, 2007 2:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Debugging Phantom Error
Replies: 21
Views: 6122

Yes, but then again no. The Transformer code invokes functions (generically called things like "get next row", "get row by key", "put") that are exposed by the passive stage on the other end of each link.
by ray.wurlod
Fri Sep 21, 2007 5:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Debugging Phantom Error
Replies: 21
Views: 6122

It won't be anywhere. You need to scrutinize the job design itself.
by ray.wurlod
Fri Sep 21, 2007 5:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer stage compilation problem
Replies: 2
Views: 897

This is because you did not install Visual Studio .NET C++ compiler before installing DataStage.

Only the Transformer and Build stages require this - you will be able to compile any job that contains neither of these stage types.
by ray.wurlod
Fri Sep 21, 2007 5:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job aborting due to row limit being reached on output link
Replies: 5
Views: 11766

What stage type are you using for the target?
by ray.wurlod
Fri Sep 21, 2007 5:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Making individual Export of jobs
Replies: 2
Views: 1075

You can export one job, or one category of jobs, from the Export tool. However, if you require a separate DSX for each job, these must be done separately. The Version Control product is not recommended because it is discontinued in version 8 of DataStage. Therefore what you propose - to pretend that...
by ray.wurlod
Fri Sep 21, 2007 4:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Disabling memory sharing in Lookups
Replies: 6
Views: 2058

Input port #0 is the one coming from your Sequential File stage. Check the input link execution order for the Lookup stage.
by ray.wurlod
Fri Sep 21, 2007 4:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Debugging Phantom Error
Replies: 21
Views: 6122

DSD.StageRun is the routine that runs Transformer stages - it's one that was provided with the software. The error message suggests that you've provided a non-numeric value for some parameter that is supposed only to take numeric values. You need to do some detective work in your job design to figur...
by ray.wurlod
Fri Sep 21, 2007 4:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Index Rebuild option
Replies: 3
Views: 937

Indexes, and the rebuilding thereof, is associated with the Repository in which ALL job types (and other objects, such as Routines) are stored. Therefore, there is no different way to do it for server jobs versus parallel jobs.
by ray.wurlod
Fri Sep 21, 2007 4:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete Hash File via Routine
Replies: 2
Views: 1153

There are three different ways to delete a hashed file (note, not hash file): which one you should choose depends upon how the hashed file was created.

Once you've sorted that out, you would invoke the appropriate command through a call to the DSExecute subroutine.
by ray.wurlod
Fri Sep 21, 2007 4:48 am
Forum: General
Topic: FLOAT TO VARCHAR ??
Replies: 9
Views: 3385

It may not require conversion. DO what was asked (send it to a text file) and tell us what you got in that file. Look at the file using a text editor, not View Data from DataStage.
by ray.wurlod
Thu Sep 20, 2007 9:45 pm
Forum: General
Topic: Populate values into job parameters at run time from sql cod
Replies: 4
Views: 1113

It's invisible.

You put stuff in using DSSetUserStatus() function, probably in a Transformer stage.