How can i inport a dll in datastage designer
Moderators: chulett, rschirm, roy
How can i inport a dll in datastage designer
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?
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?
Re: How can i inport a dll in datastage designer
Did they not also tell you how to do this?PeterPol wrote:But they (IBM) have told me that I can use external dll's in Designer without using the original source.....
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
(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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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!
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!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.