Search found 42189 matches

by chulett
Sun May 24, 2015 6:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Blank Rows are not Read by Datastage
Replies: 4
Views: 1494

Define "blank row" for us. Complete empty, all spaces or ???
by chulett
Sun May 24, 2015 6:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Blank Rows are not Read by Datastage
Replies: 4
Views: 1494

:!: Just a quick note. When you have a question about Parallel jobs you should be posting them in the EE/PX forum. Saves me from having to move everything for you as I've been doing. Thanks.
by chulett
Sun May 24, 2015 6:52 am
Forum: General
Topic: XMETA, Oracle 12c RAC and PDB issue
Replies: 2
Views: 1057

Let's get you in your own post for this.

The "similar situation" can be found here.
by chulett
Sat May 23, 2015 3:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Repeat the value of the first line of each group
Replies: 2
Views: 814

Again, that's just stage variables and change detection. I assume each new 'group' start with a col1 value of "1" and arrive properly sorted? If so on each "1" line store the value of col2 into a stage variable. On every line, assign the stage variable to col3. In that order. Obv...
by chulett
Sat May 23, 2015 3:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare the current row to previous row
Replies: 2
Views: 2195

Short answer is yes.

This article might help with the whole record approach. You should also become very familiar with stage variables as they can be used to hold previous values (including a complete record string) since they are evaluated in order from top to bottom.
by chulett
Sat May 23, 2015 3:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Set the value of a Variable using a Variable
Replies: 5
Views: 1519

Yes... and no.

WITH another variable: yes
IN another variable: no

Code: Select all

vCheck= 
 If Col1=1 then vReference=Col1       <- not good
 Else vReference                      <- good
by chulett
Sat May 23, 2015 2:59 pm
Forum: General
Topic: Code on that checks if a file exists in a FTP Server
Replies: 3
Views: 1110

The answer really depends on what it is you need to do... and rather than pull teeth one at a time, why don't we start with a full description of what it is you are trying to accomplish? What requirements / tasks do you need to fulfill? End to end, the whole nine yards please.
by chulett
Fri May 22, 2015 6:02 pm
Forum: General
Topic: Sequencer was entered, but never exited
Replies: 4
Views: 2269

As noted, if you have an All sequencer with multiple input links and not all triggers on the incoming links 'fire' but some do, then the sequencer cannot 'fire' as well... it becomes entered but not exited when the sequence job itself runs out of things to do. And that doesn't mean the sequence job ...
by chulett
Fri May 22, 2015 9:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: [IBM][CLI Driver] CLI0143E Invalid precision value
Replies: 7
Views: 6146

A couple of things. If you Reset the aborted job, does an message appear in the log labelled "From previous run..."? If so, please post the contents. Also, are any of your values NULL? Googling around finds some articles on NULL values causing that error but other than that there's not muc...
by chulett
Fri May 22, 2015 9:16 am
Forum: General
Topic: version migration from 8.1 to 11.3
Replies: 3
Views: 2210

Re: version migration from 8.1 to 11.3

esivaprasad wrote:Taking all jobs export from 8.1 and directly importing into 11.3 version and compiling all jobs, it will work ?
You'll have to test everything since functions change over time and bugs are smashed (that you may be unknowingly taking advantage of) but the short answer is 'yes'.
by chulett
Fri May 22, 2015 9:14 am
Forum: General
Topic: Code on that checks if a file exists in a FTP Server
Replies: 3
Views: 1110

Simplest way? Google for "ftp file check".
by chulett
Fri May 22, 2015 9:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: [IBM][CLI Driver] CLI0143E Invalid precision value
Replies: 7
Views: 6146

Then off we go to the Server forum!
by chulett
Fri May 22, 2015 7:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: [IBM][CLI Driver] CLI0143E Invalid precision value
Replies: 7
Views: 6146

Really really truly a Server job?
by chulett
Thu May 21, 2015 5:40 pm
Forum:
Topic: Shouldn't the dev catalog have query building capabilities?
Replies: 10
Views: 10629

We keep a table reserved for him over in that corner. <points thumb over shoulder>

:wink:
by chulett
Thu May 21, 2015 11:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to load attributes in xml tag using xmlstage
Replies: 10
Views: 3005

So, just to be clear - the output you posted is what you got, not what you want. Correct? Can you post an example of what you actually want it to look like so we're all on the same page?

Thanks.