Search found 6797 matches

by DSguru2B
Thu Feb 15, 2007 6:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File pattern warning in Sequential file
Replies: 9
Views: 1654

Or you can always have an empty file say "aaam_classif_empty.txt" to ensure that your job finishes successfully. This will eliminate any extra job or stages.
by DSguru2B
Thu Feb 15, 2007 6:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading multiple input files into a funnel stage using sym
Replies: 3
Views: 893

What exactly do you mean by "symbolic"? I did not get that.
Never the less, Ray has pointed out two appropriate methods to get your work done.
by DSguru2B
Thu Feb 15, 2007 6:01 pm
Forum: General
Topic: How to calculate the size of the text file
Replies: 19
Views: 11188

Load it in your project directory.
Also, If you want to calculate the file size on windows, I posted a small routine that utilizes STATUS basic command to get the file size. Search for it, its here somewhere in the forum.
by DSguru2B
Thu Feb 15, 2007 5:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is Orchestrate Schema in DataStage?
Replies: 5
Views: 5959

vmcburney wrote:Shouldn't that be:
Mod...: please move to Cramming for Job Interview forum
:)

We outta have that forum here, just for fun :wink:
by DSguru2B
Thu Feb 15, 2007 10:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running job in MI
Replies: 9
Views: 2015

The latter, i.e, run the job five times with five different Invocation Ids. Consequentily, you can write your result to a hashed file whos key can be @INROWNUM coupled with Invocation ID. This way all five instances will write to the same hashed file and each record will be preserved due to a differ...
by DSguru2B
Thu Feb 15, 2007 9:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: If then else problem
Replies: 2
Views: 783

Its defined as char(20) so 'ASIA' will have 16 trailing spaces. Change it to varchar and TRIM the column before doing your comparison.
by DSguru2B
Thu Feb 15, 2007 9:01 am
Forum: General
Topic: HashFileLookup
Replies: 12
Views: 5001

How did you change that code. Make sure you only changed 'Open' to 'OpenPath'.
by DSguru2B
Thu Feb 15, 2007 8:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: random errors SIGSEGV, SIGKILL, SIGBUS
Replies: 17
Views: 5314

What is the value of APT_NO_JOBMON ? Turn it off as advised by Andy in the other post and see what happens.
by DSguru2B
Thu Feb 15, 2007 8:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One projet with multiple environnements (parameters)
Replies: 8
Views: 1915

shrek7577 wrote:So, I spent 30minutes to do the first job sequence and 30secondes for the 2 others !!

Thats a huge leap :wink:
by DSguru2B
Thu Feb 15, 2007 7:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: random errors SIGSEGV, SIGKILL, SIGBUS
Replies: 17
Views: 5314

This will be a parallel specific problem as SIG* errors hardly show up in a server job. When these errors show up, a core dump is formed, for example with SIGBUS, its a bus error and a file should show up in your project directory called core. SIGSEGV, is segment violation and your jobs are probably...
by DSguru2B
Thu Feb 15, 2007 7:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Jobs called by a sequence
Replies: 7
Views: 2366

You can also go to the job properties and check out the dependencies. All jobs will be listed there.
by DSguru2B
Thu Feb 15, 2007 7:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One projet with multiple environnements (parameters)
Replies: 8
Views: 1915

You wont be able to change it directly there. You need to define a parameter in the job sequence and pass that parameter as the value. Plus for encrypted passwords, you wont be able to "double click" and enter a value, you need to hit "Insert parameter" and then specify the job sequence's job parame...
by DSguru2B
Thu Feb 15, 2007 7:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: EXPRESS LIKE or NOT LIKE EXPRESSION
Replies: 3
Views: 1379

Or specify the same constraint in one link and create a second link that will be reject link. Any row that doesnt go through the first link will pour down the reject link.
by DSguru2B
Wed Feb 14, 2007 5:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: using UniVerse and UniData
Replies: 12
Views: 3473

What are you trying to achieve here? As noted you cannot connect to Oracle using Universe Stage.