Archives of the TeradataForum

Message Posted: Thu, 02 Jun 2005 @ 19:55:29 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Anomy,

To avoid the Access Module Error you need to add the path on your windows script or the JCL some thing like this:

     ______________________________________________________________
     @echo off
     REM
     **************************************************************
     path %path%;c:\program files\ncr\teradata client\bin;
     path %path%;c:\program files\ncr\teradata client\ncr ole db access
     module;
     REM
     **************************************************************
     ______________________________________________________________

The following script will call the job or invoke the Mload. Save it as a ".bat" file and let your scheduler invoke it.

Note the path to the Oledb_Axsmod.dll in win2k vs. NT.

Hope this helps.

Mohommod

     _______________________________________________________________

     :label1
     echo Starting MultiLoad Job for the Address  Table
     rem *** create a file (lf) containing a single linefeed
     echo.>lf
     rem *** redirect to file null to suppress output message from copy
     copy /a c:\MainDir\control\logon+lf+c:\MainDir\ddl\addressml
     c:\MainDir\ddl\addressml.temp >null
     mload c:\MainDir\log\addressrml_log
     if errorlevel=1 goto exit
     del c:\MainDir\ddl\addressml.temp
     ______________________________________________________________
     rem *** End Here.

	<Prev	Next>		<<First	<Prev	Next>	Last>>