fastload issue with inmod path

Tools & Utilities
Enthusiast

fastload issue with inmod path


Hi!


With fastload, I am using an inmod library to feed data.


Things are working well and fast when the inmod dll has a simple path like in our dev environnement say, e:\Code\Test\MyInmod.dll. 


In the fastload script, the code will be : 


INMOD=e:\Code\Test\MyInmod.dll;


and its OK


Issue is that the dll will be embedde in a standard software installation on Window. therefore the path of the INMOD DLL will be typically c:\Program Files\MySoftware\MyInmod.dll.


In the fastload script, the code would then be : INMOD=c:\Program Files\MySoftware\MyInmod.dll;


In such a case fastload cannot find the inmod dll :(


I just get an error message 'Unable to load INMOD'


I have made various tries with ", ' chars at various places :


INMOD="c:\Program Files\MySoftware\MyInmod.dll";


INMOD='c:\Program Files\MySoftware\MyInmod.dll';


INMOD="c:\Program Files\MySoftware\"MyInmod.dll;


INMOD='c:\Program Files\MySoftware\'MyInmod.dll;


looks like fastload is unable to load an inmod dll when the path includes a blank.


Any advice to make it compliant with usual practices on Windows ?


Thx

PS

a SHOW VERSION in my fastload session displays

     FastLoad Version 13.10.00.010 for Win 32 running Windows Sockets

     FastLoad  : 13.10.00.22

     FastCmds  : 13.10.00.17

     FastIO    : 13.10.00.06

     FastMBCS  : 13.00.00.02

     FastNtfy  : 13.01.00.00

     FastPars  : 13.10.00.01

     FastSQL   : 13.10.00.28

     FastUtil  : 13.10.00.05

     Fdlosdep  : 13.01.00.00

     Teradata Data Connector  : 13.10.00.09

     PMPROCS   : 13.10.00.14

     PMRWFMT   : 13.10.00.09

     PMTRCE    : 13.10.00.02

     PMMM      : 13.00.00.01

     PMHEXDMP  : 13.10.00.01

     PMUNXDSK  : 13.10.00.15

     ICUVER    : TDICU, 13.10.00.02

     CLIV2     : 13.10.00.30

     MTDP      : 13.10.00.23

     MOSIos    : 13.10.00.12

     MOSIDEP   : 13.10.00.11

     OSENCRYPT : N/A

     OSERR     : 13.10.00.01

Tags (1)
7 REPLIES
Teradata Employee

Re: fastload issue with inmod path

Try this:

INMOD="c:\Progra~1\MySoftware\MyInmod.dll";

while I investigate whether spaces are supported.

-- SteveF
Enthusiast

Re: fastload issue with inmod path

Hi!

Good point !

It does work. As there is a Windows API (if I remember well) to compute the 'short' path from a path with blanks.

With Unix, the trick is not directly available but this is not a standard practice to have such kind of path for installed software and filesystem links can do the trick  so globally the workaround is OK.

However, I have declared an incident at TAYS :  RECED7RWS

A JIRA has been created too : JIRA SA-27626 

Teradata Employee

Re: fastload issue with inmod path

Ok. We already have JIRA issues opened for these but we will just eventually close the one you opened as a duplicate.

Thanks!

-- SteveF
Enthusiast

Re: fastload issue with inmod path

Oups, I  clicked too much faster

The missing part was :

Thanks for this simple workaround !

Enthusiast

Re: fastload issue with inmod path

Hi,

Hi i am a beginer for INMOD routines.

Can anyone pls explain how i can use INMOD with fastload to get data from oracle tables and insert it directly into teradata tables.

can i get an example on how can i create a INMOD routine for this task.

thanks in advance..

Teradata Employee

Re: fastload issue with inmod path

If you have access to TPT, then you should use that. We provide a seamless way of moving data from Oracle to Teradata without the need to write custom INMODs.

If you write your own INMOD you have to have access to ODBC or some other 3rd party software to read from Oracle.

You did not indicate on which platform you are running. If you are running on Windows, you can use the OLE-DB Access Module to retrieve data from Oracle. That would be faster than using ODBC and INMODs.

But TPT is still the best option. It runs on all of our supported platforms and does not use names pipes to move the data.

-- SteveF
Enthusiast

Re: fastload issue with inmod path

Thank you very much for ur suggestions.

Our Teradata version is 13.10.

We are using informaticawith FLOAD to load data from oracle but it's giving very bad performance when loading huge tables having more than 200 millions of data.

Can u give some information on how can i use OLEDB module to improve this process.

Thanks !