Calling 'DLL' from DataStage routine

yaminids · Post by **yaminids** » Thu Jan 27, 2005 12:53 pm

Hello there,
I am trying to call a 'DLL' from a routine. Is it possible to do so.
Thanks in advance.
-Yamini

ogmios · Post by **ogmios** » Thu Jan 27, 2005 1:50 pm

On UNIX... no.

Ogmios

sonia jacob · Post by **sonia jacob** » Thu Jan 27, 2005 2:53 pm

ogmios wrote:On UNIX... no.

Ogmios

my apologies if the discussion is taken in a different direction.

So Ogmios, does that mean its possible on windows. If so how?

ogmios · Post by **ogmios** » Thu Jan 27, 2005 3:02 pm

If your DataStage server runs UNIX, you're out of luck for sure. And most of my DataStage experience is on UNIX.

For your question maybe have a look at viewtopic.php?t=87402

Ogmios

ray.wurlod · Post by **ray.wurlod** » Thu Jan 27, 2005 3:19 pm

So Ogmios, does that mean its possible on windows. If so how?

The mechanism is the GCI (General Calling Interface). You need to set up a function definition (so that, when the function is called, data types can be converted from/to DataStage's "typeless" environment. This GCI definition must exist in a GCI file.

Within the administrator's account there is a menu called GCI.ADMIN; or you can learn all the underlying commands.

It can also be done on UNIX, except that it's not DLLs that you invoke; it's shared libraries, and there are more steps; among them the need to re-build your dssh executable (which is fraught with danger if not done right, and is likely to have your support provider make the sign that wards off the evil eye!).

Although Ascential does not publish any information about the GCI it is available within the product. Guidance can be found in the
UniVerse GCI Guide which is available at no charge from IBM.

yaminids · Post by **yaminids** » Fri Jan 28, 2005 1:46 pm

Hello there,

Thank you all for your help.

-Yamini

DSXchange