Search found 21 matches

by lclapp
Tue Jul 12, 2005 8:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control compile only option and PX jobs
Replies: 1
Views: 1110

Version Control compile only option and PX jobs

If I utilize the compile option when I promote my jobs from VC to another project, where are the compiles done?javascript:emoticon(':?:') Question The answer would seem to be the DS server being promoted to...but when has DS done the obvious. The question has to to with jobs that utilize the C++ com...
by lclapp
Thu Apr 21, 2005 3:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: date conversion
Replies: 5
Views: 1680

Handling the xml date portion

Ans = FIELD(Arg1," ",1,1) This will give you back the date portion without have to handle checking for the '/' and such. It is shown as a function but would work in a derivation if all you need is the date value in the xml format. You can then Iconv and Oconv to get the right format.
by lclapp
Tue Nov 23, 2004 4:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple HASH Lookups
Replies: 6
Views: 1600

Multiple HASH Lookups

We have several cases where the results of one hash lookup are needed in order to do the next hash lookup. I know we can utilize multiple transform stages but I was wondering if anyone knew how to do this in one transform stage.

leslie
by lclapp
Wed May 19, 2004 4:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Removing (,/ -) from the phone column
Replies: 24
Views: 8239

Close only counts in horseshoes, hand granades or nuclear warfare :D Would there be any overhead savings using inline vs the function DIGITS?...leslie
by lclapp
Wed May 19, 2004 3:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Encrypting the Flat File
Replies: 5
Views: 2507

Another approach may be through the use of the Filter Command box on the ff stage. I have this to unzip(input) or zip(output) and I don't see why you couldn't use a command line encryption program. Mind you, I have not done seems possible :?:
by lclapp
Wed May 19, 2004 3:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Removing (,/ -) from the phone column
Replies: 24
Views: 8239

Ans = Oconv(Arg1,"MCN") You can create a function or use inline....leslie