How can i inport a dll in datastage designer

[PeterPol]

Hi everyone,

We have stille problems with importing a c++ (Borland Dll) into designer.

Our ETl envioroment stands on a Windows machine and we uses Parallel- and Server jobs.

For parallel jobs we can make an external routine that can use .os file (library file). For the server job enviroment you can make UnviVerse routines with the General Calling Interface (GCI).

With GCI you make routines from c or cpp (C) sources.
- You must compile these sources with the VS .NET c++ compiler
- Than you make a library for these sources.
- Finaly you uses GCI to make a DLL and put these dll to the GCI library list so you can call it in a server routine.
- Importing a dll directly is not supported

But they (IBM) have told me that I can use external dll's in Designer without using the original source.....

Can enyone tell me if it's possible to use an external dll in Designer without changing the dll?

[chulett]

But they (IBM) have told me that I can use external dll's in Designer without using the original source.....

Did they not also tell you how to do this?

[PeterPol]

Nope!!

We have now make a call to IBM for this problem..

But maybe can someone help us.....

[chulett]

Maybe. If I had a clue I'd help, but this is not my cup o' tea. When you do get the solution, please post it back here.

[ray.wurlod]

In Manager, choose Import > External Function Definitions
(see Manager Guide, page 8-17)

This places an entry in the Routines branch of the Repository describing the external (ActiveX) function, how many arguments it has, and the DLL in which it resides and the automation class within that DLL.

Note that this option is only enabled if your DataStage server is on a Windows platform (there's no such thing as ActiveX on UNIX).

[chulett]

Which would explain why I've never seen that option light up.

[PeterPol]

In Manager, choose Import > External Function Definitions

We have tried that solution but for us it's not working. We get the message: error loading type library\DLL.

What do we do wrong????

[ray.wurlod]

The DLL in question must be an OLE server, so as to expose ActiveX objects. Is yours?

[PeterPol]

he DLL in question must be an OLE server, so as to expose ActiveX objects. Is yours?

I don't understand your reply?? How can I make an OLE Server for this dll?

[chulett]

I guessing that, since the question does not make any sense, that the answer wouldn't either. Is there someone else there whom you could run the question by, see if they understand the change needed?

[ray.wurlod]

Read the Manager Guide (page 8-17). The only external functions that can be imported are ActiveX (OLE) functions. Therefore the DLL must have been constructed as an OLE server.

Exactlly how this is achieved depends on the language and the environment, and I don't profess to be an expert - the last time I did one of these was in Visual Basic 5.0!