Search found 53125 matches

by ray.wurlod
Wed Oct 17, 2007 9:01 am
Forum: General
Topic: CoSort used in DataStage
Replies: 4
Views: 1113

Search the forum. Also go to the DSXchange home page, where you will find a link to CoSort as a sponsor of DSXchange.
by ray.wurlod
Wed Oct 17, 2007 9:00 am
Forum: General
Topic: Set job parameters in parallel job using unix script
Replies: 3
Views: 2431

I have already told you that DSSetParam() can not be called from UNIX. It is a function in the DataStage API. It must be called from DataStage BASIC or from a C (or C++) program.
by ray.wurlod
Wed Oct 17, 2007 8:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap allocation failure
Replies: 1
Views: 786

Welcome aboard. The forum in which you have chosen to post is called "DSXchange Testimonials", and is intended for posts that heap praise upon the site. Please post afresh in the Enterprise Edition forum, which is the appropriate place for questions relating to parallel jobs. Before you do that, how...
by ray.wurlod
Tue Oct 16, 2007 4:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: difference of dates
Replies: 14
Views: 4128

Just take the leftmost 10 characters of each "timestamp".

Code: Select all

(Iconv(Left(TS1,10),"DDMY"-Iconv(Left(TS2,10),"DDMY")/7
by ray.wurlod
Tue Oct 16, 2007 1:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Parameter as part of DataSet name
Replies: 4
Views: 1132

That suggests that the job parameters are not thus defined in the job properties dialog.
by ray.wurlod
Tue Oct 16, 2007 1:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Parameter as part of DataSet name
Replies: 4
Views: 1132

That suggests that the job parameters are not thus defined in the job properties dialog.
by ray.wurlod
Tue Oct 16, 2007 1:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: I want to use the lookup.h file in my parallel job
Replies: 1
Views: 586

It's a header file. Use #include in your C++ routine.
by ray.wurlod
Tue Oct 16, 2007 1:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hashed file - (project directory or different directory)
Replies: 8
Views: 2645

Only one. It's easier to delete the project.

Best practice is to keep your hashed files in a separate directory, perhaps a sub-directory in the project directory. But if they're going to grow large, then maybe a separate file system is indicated. Create a script to delete the hashed files.
by ray.wurlod
Tue Oct 16, 2007 1:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: difference of dates
Replies: 14
Views: 4128

Are your dates in day-month-year order? Is "/" really the delimiter?

Give us some example data.
by ray.wurlod
Tue Oct 16, 2007 1:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Difference in Routines and Transforms
Replies: 3
Views: 1349

Yes it does, but it's negligible and only incurred on the first row processed.
by ray.wurlod
Tue Oct 16, 2007 1:42 pm
Forum: General
Topic: Set Job parameters using unix script
Replies: 10
Views: 2390

I just did.

DSSetParam() is a DataStage BASIC function. It also exists in the DataStage C language API. It can not be called from UNIX. You can write a small C program if you wish.
by ray.wurlod
Tue Oct 16, 2007 1:39 pm
Forum: General
Topic: Weird icons showup for the stages on the canvas
Replies: 6
Views: 1929

Disabling animated screen savers can help, too.
:wink:
by ray.wurlod
Tue Oct 16, 2007 9:40 am
Forum: General
Topic: Oracle Stored proc thru ODBC Stage
Replies: 4
Views: 1375

Premium membership would allow you to read the entire post. Premium membership is one of the ways in which the hosting and bandwidth costs to keep DSXchange running are defrayed. Therefore I shall not re-post. For less than 30c per day you can buy a premium membership. It's well worth it, and the v...
by ray.wurlod
Tue Oct 16, 2007 9:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Copying ENV variables from one project to another
Replies: 2
Views: 1020

There's nothing odd about parallel jobs. All the project's environment variables (irrespective of the job type in which they may happen to be used) are stored in the DSParams file. So, yes, you copy the pertinent lines from the one DSParams file to the other. I suspect that a Search would have answe...