DS Job & dll library

ppalka · Post by **ppalka** » Tue Jul 19, 2005 2:01 am

Hi,

Can we execute in DS Job any program from dynamic library (dll)?

Regards,
Piotrek

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Jul 19, 2005 2:03 am

The dlls and their usage mechanism are explained clearly in the manual

ppalka · Post by **ppalka** » Tue Jul 19, 2005 3:22 am

You mean chapter: "Importing External ActiveX (OLE) Functions" or something else?

Regards,
Piotrek

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Jul 19, 2005 3:57 am

It is part of the dsjob dlls that comes as online manuals pdf.

ppalka · Post by **ppalka** » Tue Jul 19, 2005 4:09 am

Sainath.Srinivasan wrote:It is part of the dsjob dlls that comes as online manuals pdf.

I found only infrmation about using DS API. But it is not what i'm looking for. I have an external program implemented as dll library and I need to execute it. Just like a command stage works, but not for exe or shell command.

Regards,
Piotrek

ray.wurlod · Post by **ray.wurlod** » Tue Jul 19, 2005 5:54 am

You will need to be much more precise. Most DLLs contain multiple entrypoints, exposing more than one function. The individual functions are callable. It may be that your particular DLL contains only one function, but you did not say so.

It's not easy to call them, but you can set the functions up as being callable through the GCI from DataStage BASIC. You can then create a Routine containing that call. Download the GCI manual from IBM's UniVerse web site.

ppalka · Post by **ppalka** » Tue Jul 19, 2005 6:06 am

ray.wurlod wrote: It's not easy to call them, but you can set the functions up as being callable through the GCI from DataStage BASIC. You can then create a Routine containing that call. Download the GCI manual from IBM's UniVerse web site.

So I think it will be much easier and faster to re-write source code of that library to standard executable app

Regards,
Piotrek

kduke · Post by **kduke** » Tue Jul 19, 2005 9:39 am

Why not use the dsjob command?

ds_developer · Post by **ds_developer** » Tue Jul 19, 2005 12:19 pm

DataStage on Windows can use ActiveX dlls. You have to import them using Manager - go to Import then External Function Definitions. If I remember correctly, the import process will create 2 routines (one you call and it calls the other). On v6.x, there was a bug related to in/out parameters in your call (search the forum, I think I posted some details). I doubt the bug has been fixed in 7.x.

John

ray.wurlod · Post by **ray.wurlod** » Tue Jul 19, 2005 3:25 pm

Yes, but why would you want to run a job if the job's already running and calling a function exposed in the DLL?

ds_developer · Post by **ds_developer** » Tue Jul 19, 2005 4:42 pm

I'm sorry Ray, I did not read the posting clearly.
John