Search found 124 matches

by fmou
Sun Oct 30, 2011 8:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transfomer dropping row
Replies: 4
Views: 1979

Rajav,

Please mark the topic as resolve if it is.

I believe all cases have been covered in above replies.
by fmou
Sun Oct 30, 2011 8:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: External Target Stage - Command execution error
Replies: 8
Views: 4747

Re: External Target Stage - Command execution error

This is working fine If I'm using only Date part...Time part is not working :( In this case, try to remove the Date part, just for the testing, and quote the time. I.e., cat >#path#/bio_"`echo "#DSJobStartTime#" | sed -e 's/://g'`".txt Give it a try and tell us what you get. HTH
by fmou
Sun Oct 30, 2011 8:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer constraints and multiple otherwises
Replies: 19
Views: 13130

transformer constraints and multiple otherwises

Hi, Has anyone ever used multiple otherwise output links in transformer? I want to have a cascading reject effect. I.e., 1. reject to file 1 if condition1 meets. 2. reject to file 2 if otherwise AND condition2 meets. 3. reject to file 3 if otherwise AND condition3 meets. 4. AOK now, goes to the main...
by fmou
Sat Oct 29, 2011 12:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change Capture stage warning
Replies: 14
Views: 7550

I thought only the key columns and the value columns can pass the CDC. For all the rest of the columns, ie. the don't-care ones, they can't pass through the CDC. Correct?

thanks
by fmou
Thu Oct 20, 2011 12:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stage to Use
Replies: 5
Views: 2511

take a look at this, which answers your question well.

Pivoting with an description
viewtopic.php?t=142442
by fmou
Thu Oct 20, 2011 12:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stage to Use
Replies: 5
Views: 2511

double post deleted.
by fmou
Thu Oct 20, 2011 12:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: join conditions
Replies: 3
Views: 2039

thanks everyone.
by fmou
Thu Oct 20, 2011 12:40 pm
Forum: General
Topic: job parameters, where used
Replies: 2
Views: 1427

thanks Ray.
by fmou
Wed Oct 19, 2011 2:37 pm
Forum: General
Topic: where is DSEXPORT
Replies: 2
Views: 2109

Found another post asking the same question.

viewtopic.php?t=139661

Maybe DSEXPORT is an optional component not come along with standard tools?
by fmou
Wed Oct 19, 2011 2:27 pm
Forum: General
Topic: where is DSEXPORT
Replies: 2
Views: 2109

where is DSEXPORT

Hi,

I believe my DS environment is properly setup,

I can run dsjob, dsadmin and even orchadmin.

However, there is no dsexport or dscmndexport in my path.

Where can I find them?

I've looked under

$DSHOME/bin/

but not there.

thanks
by fmou
Wed Oct 19, 2011 2:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to properly use pivot/pivot enterprise
Replies: 6
Views: 2117

what I need is the Column header to be pivoted down alongside the value
Have you looked at this?

Pivoting with an description
viewtopic.php?t=142442
by fmou
Wed Oct 19, 2011 11:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: join conditions
Replies: 3
Views: 2039

join conditions

Hi,

How can I specify join conditions in the join stage?

translating from SQL, where should I put in the where clauses?

Thanks
by fmou
Wed Oct 19, 2011 9:26 am
Forum: General
Topic: job parameters, where used
Replies: 2
Views: 1427

job parameters, where used

Hi, I've just inherited a chaotic project that defines lots of of job parameters. Among them, I suspect that some parameters are never used, or not applicable after I've moved some part of the job into other jobs. So my question is, - is it possible to double check if a job parameter is no longer us...
by fmou
Wed Oct 19, 2011 7:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: copy dataset in GUI
Replies: 3
Views: 1226

no, not there either.

Under our project, we have sub directories like, dsdata/ dsproj/, etc.

I've looked all three places, project home, dsdata/ & dsproj/. Not there.

Never mind. I copied the dataset in DataStage instead.

Thanks
by fmou
Tue Oct 18, 2011 2:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: copy dataset in GUI
Replies: 3
Views: 1226

copy dataset in GUI

Hi,

I copied a dataset in GUI as another one.
Dataset management told me it is successful.

But I couldn't find the copied one under the same directory with the source. Neither from the GUI, nor from within shell.

Done twice. Same problem.

Any comments?

Thanks