Search found 42189 matches

by chulett
Mon Jun 18, 2012 5:48 pm
Forum: General
Topic: IBM XL C/C++ Enterprise Edition compiler
Replies: 4
Views: 1903

I would feel confident in saying that if your platform supports concurrent licensing for the compiler, you'd be fine as you noted. Unless Ray notes otherwise, of course. :wink:
by chulett
Mon Jun 18, 2012 5:30 pm
Forum: General
Topic: Information server 8.5 Installation error on Linux
Replies: 4
Views: 2045

You'll need to post more than that as that's not any kind of an error. Is there something more descriptive that you received or that was listed around that one?
by chulett
Mon Jun 18, 2012 6:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How do I access the 'Drop unmatched fields' property in ODBC
Replies: 3
Views: 2813

Karthik.M wrote:Thanks for mentioning the "View Data" bug.
Why the thanks? I might as well say "Thanks for running around and resurrecting old posts". :?

(serious question btw)
by chulett
Mon Jun 18, 2012 6:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: what is use of surrogate key?when we u r using this?
Replies: 5
Views: 2179

Re: what is use of surrogate key?when we u r using this?

hi Harikumar, you really should put together better posts than this. Rather than "hi" you might have simply put "Surrogate key" as your subject and then a more fleshed out version of your questions in the post itself. Something more like: What is the use of a surrogate key? When...
by chulett
Mon Jun 18, 2012 6:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: what is use of surrogate key?when we u r using this?
Replies: 5
Views: 2179

A surrogate key is a unique primary key that is not derived from the data that it represents, therefore changes to the data will not change the primary key. In a star schema database, surrogate keys are used to join a fact table to a dimension table. Straight out of the documentation for the stage....
by chulett
Mon Jun 18, 2012 6:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Load multiple tables from Oracle to DB2
Replies: 4
Views: 3238

I imagine they've solved this problem by now. :wink:
by chulett
Mon Jun 18, 2012 6:28 am
Forum: General
Topic: corrected the job
Replies: 16
Views: 6211

Close.

cd $DSHOME
. ./dsenv
./bin/uvsh
LOGTO <Project>

What do you plan on doing once you get there? :?
by chulett
Sun Jun 17, 2012 7:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: converting hash files from DS 7.5.2 to DS 8.5 (server)
Replies: 8
Views: 2968

FYI, sounds like you may already know this but search here for the SETFILE command, which is used to create the VOC entries you (may) need.
by chulett
Sun Jun 17, 2012 4:55 pm
Forum: General
Topic: unix commands in sequential file
Replies: 5
Views: 1747

Which I did mention, just without the "rather than" part. Thanks. :wink:
by chulett
Sun Jun 17, 2012 4:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: converting hash files from DS 7.5.2 to DS 8.5 (server)
Replies: 8
Views: 2968

You can validate the jobs and then copy over the hashed files or copy them and then create the VOC manually. Your choice on the manual step but there will be one. :wink:
by chulett
Sun Jun 17, 2012 4:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: converting hash files from DS 7.5.2 to DS 8.5 (server)
Replies: 8
Views: 2968

And just to be anal, there's no "conversion" required. As noted, it's a simple migration possibly complicated if they are account-based rather than pathed hashed files.
by chulett
Sun Jun 17, 2012 7:27 am
Forum: General
Topic: unix commands in sequential file
Replies: 5
Views: 1747

Well... pretty standard stuff. Any command that writes its output to 'the screen' is writing to stdout. That output stream is what the stage consumes when the filter option is enabled.
by chulett
Sat Jun 16, 2012 10:09 pm
Forum: General
Topic: unix commands in sequential file
Replies: 5
Views: 1747

Anything that outputs to 'standard out'.
by chulett
Sat Jun 16, 2012 6:47 am
Forum: General
Topic: corrected the job
Replies: 16
Views: 6211

In the 8.x release? I'm not so sure. And I thought the NAME field was only in DS_JOBS. :?
by chulett
Fri Jun 15, 2012 5:59 pm
Forum: General
Topic: LISTAGG Function in ORACLE 11g R2
Replies: 5
Views: 3670

I wasn't thinking about how useful it could be in an ETL tool but rather outside of one...