Search found 53125 matches

by ray.wurlod
Sun Feb 04, 2007 4:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Store procedure stage
Replies: 17
Views: 4690

You wait until IBM brings out a version of the Stored Procedure stage that supports Teradata.

If you can make a good business case (that is, one where IBM makes another squillion), you could submit an enhancement request.
by ray.wurlod
Sun Feb 04, 2007 2:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to remove special characters in a transformer
Replies: 5
Views: 1682

Why can't you write them to a file?
by ray.wurlod
Sun Feb 04, 2007 2:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence or Unique identifer across tables in PX ?
Replies: 13
Views: 3674

The sequence does have to exist and to have been initialized.
by ray.wurlod
Sun Feb 04, 2007 2:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: writing a warning to the log in a parallel job
Replies: 5
Views: 1491

All warnings in parallel jobs have to be logged by the conductor process. You have access to routines like UtilityWarningToLog() within before/after subroutines - you would need to create your own - or, as others have noted, using BASIC Transformer stage or server shared container. The burning quest...
by ray.wurlod
Sun Feb 04, 2007 2:21 pm
Forum: Site/Forum
Topic: Getting logged out during session
Replies: 17
Views: 9495

Still on IE6. Fairly heavily protected system (e.g. firewall, antivirus, no cookies, no pop-ups, no ads).
by ray.wurlod
Sat Feb 03, 2007 4:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding exporting datamodel
Replies: 53
Views: 13005

Sometime we'll catch up and have a discussion about Dads. Mine, too, was a union man - a merchant seaman. Similar approach to the one you described, maybe approaching it from the other side (if it's not worth doing to the best of your ability it's not worth doing at all). He was perforce skilled in ...
by ray.wurlod
Sat Feb 03, 2007 2:45 pm
Forum: Site/Forum
Topic: Getting logged out during session
Replies: 17
Views: 9495

More information. I get reliably asked to login again when I choose Search from one of the forums, then choose a topic from the search results. If I use the browser's Back button to return to the point from where I chose Search, I find that I am not logged out, and can continue as previously. It see...
by ray.wurlod
Sat Feb 03, 2007 2:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pivot & Filter - Alternative option
Replies: 12
Views: 2530

You did not make that clear till now.
Your only solution will require four separate output links, separately constrained, since they will have different metadata.
by ray.wurlod
Sat Feb 03, 2007 2:34 pm
Forum: General
Topic: Looking for Ascential datastage Forum
Replies: 9
Views: 4082

There is, of course, the server forum here

Someone started a "competitive forum" in Yahoo groups but I don't know what became of it.
by ray.wurlod
Sat Feb 03, 2007 2:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ABOUT AIX VERSION
Replies: 9
Views: 1327

DataStage will run on AIX. Obviously there are version dependencies, which you can ascertain from the IBM website. Depending on where you are in the world you may or may not be able to purchase directly from IBM; in some locations they work through a reseller network. It may also be that, with the a...
by ray.wurlod
Sat Feb 03, 2007 1:19 am
Forum: General
Topic: Folder stage and network folder
Replies: 18
Views: 5619

DSguru2B wrote:I had a hunch.

Perhaps we should call you Igor? :lol:
by ray.wurlod
Sat Feb 03, 2007 1:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Get The status of the job
Replies: 9
Views: 3323

Yep, mentioned in August 2005 and have been using it without problems. (I've never used the "run after job subroutine only if successful" - it rather defeats the purpose to my mind. Presumably there are statistics gathering after-job subroutines that could benefit, but it's my practice always to gat...
by ray.wurlod
Sat Feb 03, 2007 1:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata Multiload- For a Datatype Varchar with Null fileds
Replies: 1
Views: 739

Welcome aboard. :D Please don't send private emails asking questions such as this, unless you wish to engage in some kind of commercial support arrangement. You need to inform DataStage (Sequential File stage) that null is represented in your text file as "NULL" (or however it is that they are actua...
by ray.wurlod
Sat Feb 03, 2007 1:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: calling external program via http
Replies: 5
Views: 1453

Write yourself any kind of executable that will do it, and invoke that using an Execute Command activity, which will capture both the output and exit status of your executable. DataStage BASIC does not have the callHTTP library that UniVerse BASIC does, as the latter was introduced in version 10 of ...
by ray.wurlod
Sat Feb 03, 2007 12:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Equivalent CHAR
Replies: 11
Views: 3265

If you are asking what character is represented by UniChar(5489275482321009) you're out of luck. There isn't one. The Unicode convention provides either for a 16-bit architecture (maximum of 65,536 different characters) or a 32-bit architecture (maximum of 4,294,967,296 different characters). The 64...