NLS String Manipulation

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

NLS String Manipulation

Post by roy »

Hi All,
I need to run a routine on some NLS strings.
I have a Server job version of it.
But since it will not be available in a standard PX job I need to think of other options to perform it's functionality.
So far the only thing worth while I came up with is 1 of 2 options:
1. use server jobs for data extraction and perform that routine there.
2. try to build a PX routine that has the same functionality.
basically this routine does a visual to logical transformation on the string so widows will show it in a reasonable mannor.

Any Sugestions will help.

Thanks in advance,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Eric
Participant
Posts: 254
Joined: Mon Sep 29, 2003 4:35 am

Post by Eric »

You could use a Server Transformer (including the routine) on the Parallel Canvas?
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

And how will it impact my parallel processing?
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
T42
Participant
Posts: 499
Joined: Thu Nov 11, 2004 6:45 pm

Post by T42 »

You could build a custom operator (BuildOP maybe) that would handle this. How well do you know C++?

Edit: Even the thought of "Server Transfomer" ... is a nightmare on performance.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

My thoughts exactly.
If we'll expiriance run stability or performance issues we'll probably end up rebuilding the basic code's logic in c++ to build a custom PX routine/BuildOP.
Since the routine's logic is mainly string manipulation, implementing it is more simple then building a com dll implementing DS API for windows applications to interact wiht DS, so I'm quite confident I'll manage it ;).

if we experiance stability issues using BTransformer and server performance is satisfactory we might do this in a server job.
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply