Search found 6797 matches

by DSguru2B
Mon Mar 12, 2007 10:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Checking Inserts/Updates on large tables
Replies: 18
Views: 4700

Nice....folks in CO must be like, "Stay away from this new yorker or he'll ram us over". :wink:
by DSguru2B
Mon Mar 12, 2007 10:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Batch script
Replies: 6
Views: 1266

Thats a fine approach. Make sure you put enough error handling mechanisms in there.
A suggestion: If the running of one job will not affect the running of another then you can probably make this job a multi-instance job and call the instance with different parameters.
by DSguru2B
Mon Mar 12, 2007 10:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error in log
Replies: 6
Views: 1727

Ok dude relax, no need to get hyper. I didnt know this topic has been covered before, knock yourself out by doing an exact search on keywords "non-virtual data set"
by DSguru2B
Mon Mar 12, 2007 9:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error in log
Replies: 6
Views: 1727

Wow, 8.0 is out for unix platform :?: Nice....
What is the filename that you are reading. Does it really have the .v extension? What if you rename the faile with .txt extension and read the .txt instead of .v?
by DSguru2B
Mon Mar 12, 2007 9:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date conversation
Replies: 17
Views: 4580

Another question, You query just includes current date. Whats the purpose of the parameter (2007-01-01) that you mentioned in your query?
by DSguru2B
Mon Mar 12, 2007 9:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date conversation
Replies: 17
Views: 4580

Have you tried doing it yourself? What have you tried so far? It can be done easily using out of the box functions.
by DSguru2B
Mon Mar 12, 2007 8:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Use Stage Variables when datasource is empty
Replies: 6
Views: 1901

What is your datasource? Is it a flat file or a database?
by DSguru2B
Mon Mar 12, 2007 8:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: manual entry of Job parameters !!!
Replies: 13
Views: 3808

Another variation of Kumar's suggestion for "If you have a job with all these parameters defined" is, that you can make a copy of that particular job and rename it to your new job's name. The copy paste will copy all the parameters. Now you can go to file, select All and hit delete. This will give y...
by DSguru2B
Mon Mar 12, 2007 7:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Control Process Failed
Replies: 61
Views: 15996

Well if there was something different in the way the two DS Engines were running, it would be in this file, if your systems are identical to the point of memory size, file systems and uvconfig values, then to be really honest, I have no idea. Wait for support to get back to you.
by DSguru2B
Mon Mar 12, 2007 7:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job aborting
Replies: 3
Views: 1423

A file system size limitations perhaps? Search on keywords "Error in writeBlock "
by DSguru2B
Mon Mar 12, 2007 7:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sample px routine
Replies: 10
Views: 3269

There is no main() function in a px routine. DataStage looks for function name. You can have 10 C functions in a single file doing different transformations, with 10 px routines, all pointing to a single object file and they all will work.
by DSguru2B
Mon Mar 12, 2007 7:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error: Null value on the accessor interfacing
Replies: 2
Views: 1939

Try giving a space(' ') instead of nothing(''). Also see if setting null_value to space helps in the extended properties of the field.
by DSguru2B
Mon Mar 12, 2007 7:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: C++ routine
Replies: 12
Views: 3626

It is thread hi-jacking.
Thats all, once you provide the path to the object file (.o) you can use the routine inside your transformer. Make sure that your id has execute permission to the file and folder.
by DSguru2B
Mon Mar 12, 2007 6:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: pass value from UNIX script to DataStage Job
Replies: 2
Views: 1175

Search the forum for scripts to do the same in a fancy fashion. There are many.
by DSguru2B
Mon Mar 12, 2007 6:53 am
Forum: General
Topic: Calculating top vaues
Replies: 33
Views: 8467

It is top 10% of a particular column in a file. You need to sort these values ascending, line them up in a single row, get the max value (last value), calculate the 10 percent breaking point, filter all the records equal to or less than that breaking point. If we are talking about Top 10% on values...