Search found 42189 matches

by chulett
Thu Jul 20, 2006 10:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sybase and Oracle errors
Replies: 27
Views: 9465

Hey, just because you can't find something doesn't mean it isn't there. Just ask my wife. :wink:

Here's an example from my dsenv, adapt as appropriate:

Code: Select all

SYBASE=/opt/sybase; export SYBASE
SYBASE_OCS=OCS-12_5; export SYBASE_OCS
by chulett
Thu Jul 20, 2006 9:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get the DS Director log into Text file
Replies: 12
Views: 2944

Krazykoolrohit wrote:
chulett wrote:Someone is channeling Ray. :lol:

i will take this as a compliment.. lol..

but were you serious?

Yes, because that is Ray's classic answer to the question as asked. How to get Directory information in a file? Select print to file... and you beat him to it.
by chulett
Thu Jul 20, 2006 8:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi-Instance jobs and User Status
Replies: 6
Views: 1643

Multi-Instance jobs and User Status

I'm wondering something and I'll certainly build some kind of a test harness to check for myself, but I was wondering if anyone already knew... Multi-instance jobs that stash data in their User Status area: does each Invocation ID store a value unique to them or (since there is only one job) is it a...
by chulett
Thu Jul 20, 2006 8:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: seq file to oracle timestamp
Replies: 6
Views: 1099

Ok. Kris asked about five questions and you answered... one.
by chulett
Thu Jul 20, 2006 7:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination received after stage
Replies: 10
Views: 3433

So... is it still one job?
by chulett
Thu Jul 20, 2006 7:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: getting topic tag in uppercase
Replies: 11
Views: 2887

Don't worry about it, this site is all about troubling people for help on problems. It's just frustrating me that something that should be fairly simple is not getting solved. Obviously either I'm overlooking something or there is a critical piece of information that you don't know is critical and h...
by chulett
Thu Jul 20, 2006 6:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding DataStage TX Map
Replies: 3
Views: 2201

I've already noted the purpose of the stage - to call a TX map from inside a Server job. I also believe someone can install the stage without owning TX but you certainly can't use it without owning it as well. Do you own the product? If so, your specific questions about the TX product should either ...
by chulett
Thu Jul 20, 2006 12:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job to get XML file as output
Replies: 4
Views: 1915

Re: Job to get XML file as output

I have created a paralell job which takes sequential file, XML Output and another Sequential file for storing the output. A couple of points. Does it need to be a parallel job for what you are doing? Secondly, get rid of the 'sequential file for storing the output', it isn't needed. The XML Output ...
by chulett
Thu Jul 20, 2006 12:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: getting topic tag in uppercase
Replies: 11
Views: 2887

This continues to make absolutely no sense to me. Perhaps you should post a clear explanation of your job design, what comes in and what should go out - and what you mean by 'parsing' the XML. Typically, you would read the file into the job using the Folder stage and it would be 'parsed' by an XML I...
by chulett
Wed Jul 19, 2006 7:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MS Access 2007 to Support Multi-Valued Data Types
Replies: 2
Views: 889

Nice closing quote from the article:

So, my clear and certain advice to developers is not to use multi-valued fields. They have nothing to offer us except potential pain.
by chulett
Wed Jul 19, 2006 5:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sybase and Oracle errors
Replies: 27
Views: 9465

That too. :wink:

Unless they've changed dsenv to add set -a (allexport) to the file, it sets the export to happen automatically whenever a variable is assigned a value.
by chulett
Wed Jul 19, 2006 5:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sybase and Oracle errors
Replies: 27
Views: 9465

Re: sybase ok.

anyway i just installed the sybase open client, but how do i set SYBASE and SYBASE_OCS is that to make sybase work? Same as you are doing for Oracle, in the dsenv file. SYSBASE is like ORACLE_HOME and SYBASE_OCS get the version number, I believe. All of this is documented by the way, both in the Pl...
by chulett
Wed Jul 19, 2006 5:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Folder stage equivalent in PX
Replies: 8
Views: 5233

Right, so you can use it to process multiple files in a directory. However, the 'feed the whole file as a single field to XML' part isn't there nor I believe the ability to pull a list of filenames. Is that correct?

You may need to 'roll your own' for that particular functionality if you need it.
by chulett
Wed Jul 19, 2006 5:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: can be put DS Job Sequence in Shared container
Replies: 3
Views: 853

That's true... so as Vincent said - in a way. :wink: