Search found 42189 matches

by chulett
Mon Aug 09, 2004 11:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Handling XML document as INPUT FILE
Replies: 5
Views: 2590

From what I understand, you should use the Folder stage in conjunction with (to feed) the XML Input stage. Works well as long as the XML files are not "too big".
by chulett
Mon Aug 09, 2004 11:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error while accessing oracle using oraoci8 stage
Replies: 2
Views: 1047

Yes, the OCI8 stage must use an 8 client to connect. You can connect to a 9i database with it, but it must be using an 8i client.

If your client and database are both 9i then suggest you use the OCI9 stage instead. Hmmm... was that available in 5.x? :?
by chulett
Mon Aug 09, 2004 6:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Templates I found on my version 7 client
Replies: 9
Views: 2625

I just went in and hit 'create job from template' and the list is empty... It will be until you create some. All it is right now is a better way to handle you creating something that you call a 'template' job and people remembering to use (and not overwrite) it. Think of it like how Office handles ...
by chulett
Sat Aug 07, 2004 7:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: I want to make Auto Job Generation utility.
Replies: 4
Views: 847

Yes, it can be done. A colleage of mine did exactly that, but having worked for Ascential for some time gave him a leg up on someone like you or me trying to work this out on our own. It is not all that simple and not something that someone can just "tell you", but it can be done. But as Kim said, b...
by chulett
Sat Aug 07, 2004 7:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsapi processes for a job
Replies: 16
Views: 8052

Bummer... sorry. :oops:

I started with 3.1 but some of these subtle "do it this way in x.x but this other way in y.y and don't forget it was broken for awhile in x.yr3" have long since fled my mind. I need to get me a copy of your magic notebook, this is all too much for a mere Muggle. :wink:
by chulett
Fri Aug 06, 2004 8:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: execute stored proc in job?
Replies: 5
Views: 2156

It is available, Tony - in 7.5 . In addition to the DRS (Dynamic Relational Stage) which is a whole 'nuther animal, there is a new SP or Stored Procedure stage. It allows usage of stored procedures as Source, Target or Lookup stages. Haven't taken it for a spin yet, but it is definitely there. Oracl...
by chulett
Fri Aug 06, 2004 8:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Scheduling of DataStage Jobs in UNIX
Replies: 1
Views: 1166

There's no need to do this outside of DataStage. Do this from the Director: * Highlight the job * Add to Schedule * Select 'Every' * De-select the current day of the week * Select the '1' on the Calendar * Set the time 09:00 AM It will create a cron entry to run your job on the first of every month...
by chulett
Fri Aug 06, 2004 1:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Focus database
Replies: 1
Views: 812

The old EDA software from Information Builders has been renamed to something like 'iWay' from what I recall. I believe that you can get an iWay adapter for Focus that DataStage could leverage. :? Check here for starters.
by chulett
Fri Aug 06, 2004 9:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsapi processes for a job
Replies: 16
Views: 8052

He doesnt' mean superuser as in root... he means the 'admin' user as in 'dsadm' or whatever name you've assigned to that role.
by chulett
Fri Aug 06, 2004 8:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Display column
Replies: 4
Views: 1070

On the issue of "Display Size", I think you'll find this has always been the case - it's just that it is being more tightly enforced. There was something in the readme about this, I believe. It was annoying to see the 'View Data' issue you noted when we upgraded to 7.0.1 where all columns are minimi...
by chulett
Thu Aug 05, 2004 7:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Which jobs are running?
Replies: 8
Views: 2237

Check page 341 of the Universe User Reference. FWIW, for RUNNING it simply says "Lists all UniVerse processes that are not yet suspended."
by chulett
Thu Aug 05, 2004 3:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi Client Manager?
Replies: 10
Views: 3222

Am I supposed to install the MCM before installing a second version of the clients? Or, do I install the new client version and then the MCM? Doesn't matter. Just don't try to use MCM without two client flavors installed. And as Roy mentioned, make sure you install the two clients to separate direc...
by chulett
Thu Aug 05, 2004 2:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Nulls and Compare Strings
Replies: 4
Views: 1309

Re: Nulls and Compare Strings

One more simple question for you guys but not for me, how do we compare 2 strings without casesensitive. I mean A##rr and A##RR should show as equal. My requirement do not allow me change one of the columns case that is I cannot use Upcase or DownCase to change the case and compare. Sure you can! S...
by chulett
Thu Aug 05, 2004 2:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi Client Manager?
Replies: 10
Views: 3222

I've used the older Client Switcher but not the new Multi Client Manager yet. I'd say go with the latter as it is supported whereas the older one is not. Besides, I doubt the older one supprts 7.5, but the new one will support 7.0. :wink:
by chulett
Thu Aug 05, 2004 11:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error compiling generated subroutine
Replies: 8
Views: 2086

What does it show when you click on More?

ps. Both Stage Variables and Constraints won't show red when in error.