Search found 42189 matches

by chulett
Thu Jun 07, 2007 7:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: more than 10 char in developer name causes 'access denied'
Replies: 4
Views: 1242

Welcome! :D

Apparently, this is somewhat of of a known issue. At least in certain versions. Probably best to contact your Support provider and see if there is a patch for this or if you need to limit the length of your userids.
by chulett
Thu Jun 07, 2007 7:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: using a group by in Oracle stage
Replies: 11
Views: 3983

Also, I had a chat with one of the instructors who said "If Oracle takes too much time processing the query then DS will fail" Umm... let's play Jeopardy: "What is false?". Let's not worry about that right now. When you get back to your job and try this again, let us know what issue(s) you are havi...
by chulett
Thu Jun 07, 2007 7:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 7.5.0 vs 7.5.1 vs 7.5.2
Replies: 3
Views: 953

A very basic answer: Yes. Without the 'vice-versa' part. Older versions can be imported into newer releases and will be automagically 'converted' during the process. There is no such backwards equivalent. The difference between them? Pretty much the same as any other software: bug fixes, new feature...
by chulett
Thu Jun 07, 2007 7:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is the difference between DataStage 7.5.2 and 7.5.0.1
Replies: 8
Views: 1705

7.5.2 would be a newer release than 7.5.0.1, but I assume you already recognize that. If you are asking what changed between those releases, only the vendor knows for certain. The 'readme' that comes with any version lists changes from previous releases, but who knows how all encompassing it is? I ...
by chulett
Thu Jun 07, 2007 7:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete
Replies: 17
Views: 4636

The former. It has no clue how many rows any given sql has affected.
by chulett
Thu Jun 07, 2007 7:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sql from file in DB2/UDB API
Replies: 10
Views: 5078

What, getting data out of a DB2 table using OCI stage?? I'd like to see that! Puh-leeze. Just mentioning that it does work in the OCI stage, therefor there is a reasonable expectation that it should work as well in the DB2 stage. Of course, maybe it just be broke there. It looks like it is not reso...
by chulett
Thu Jun 07, 2007 6:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Upgrade Datastage to 7.5.1.A and the SAP R3 Plugin Pack 5.2
Replies: 1
Views: 1260

It sure sounds like a upgrade related issue. Best to call your Support provider, open a case, that's really where you should be taking this issue next if you haven't already.
by chulett
Thu Jun 07, 2007 6:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dependencies page in batch job.
Replies: 6
Views: 1624

What i got frm ur Q is: U want Come on... we're not your bestest l33t buddies on the other end of an IM or text message. This is a support forum for professionals. Seeing as how English isn't the first language of a great many people here, let's take a extra moment to use real words spelled all the...
by chulett
Thu Jun 07, 2007 6:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: extracting required string from routine return value
Replies: 11
Views: 2434

If you truly don't want to see them, redirect standard error to /dev/null when you launch your script. Or use DCount to count the output and take the last one.
by chulett
Thu Jun 07, 2007 6:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file question
Replies: 9
Views: 1819

If you 'know' it will always be too big to cache, don't set it - it will save a little startup time. Will it hurt to set it? No. It will try and you'll get a message it could not be cached.
by chulett
Wed Jun 06, 2007 5:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reset Warnings..
Replies: 5
Views: 1535

You should RESET the job only if it needs to be reset. Check first and conditionally issue that command if the previous run aborted. That being said, simply resetting a job doesn't open or validate a sequential file as far as I know. Now, if it had aborted for some reason, the reset itself can log a...
by chulett
Wed Jun 06, 2007 2:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle plug-in reverse compatibility
Replies: 2
Views: 705

Sure, but the secret is the version of the Oracle client you use to do that. From what I've seen, you'll probably want to use a 9i client for that.
by chulett
Wed Jun 06, 2007 10:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Handling Nulls in Aggregator
Replies: 4
Views: 1295

Wow... Ken dropping a Mario reference. Who woulda thunk it? :wink:
by chulett
Wed Jun 06, 2007 8:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sql from file in DB2/UDB API
Replies: 10
Views: 5078

Works fine from the OCI stages from what I recall. Not something I do very often (hardly ever) but have done it.
by chulett
Wed Jun 06, 2007 7:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How do i find a Job by target?
Replies: 9
Views: 2864

Am I right providing my project folder as "DsxPath" ? Maybe this only works on a unix/linux system? No, it will work on any system. No, you do not provide it a path to your Projects, but instead create a ".dsx" export from the Manager of the source of all jobs in your project. Then point it to that...