AXSMOD - FastLoad

Teradata FastLoad Reference

Product
FastLoad
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose  

The AXSMOD command specifies the name and optional initialization string for an access module that provides data to the Teradata FastLoad utility on network‑attached client systems. For more information about specific access modules, see the Teradata Tools and Utilities Access Module Reference (B035‑2425).

Syntax  

where

 

Syntax Element

Description

initstring

Optional initialization string for the access module.

The initialization string can contain double quotes, but not single quotes.

name

Name of the access module file to be used to import data. These access modules include:

  • OLE DB Access Module (oledb_axsmod.dll on Windows platforms)
  • Named Pipes Access Module
  • Teradata WebSphere® MQ Access Module (client version)
  • Teradata WebSphere® MQ Access Module (server version)
  • Teradata Access Module for JMS (libjmsam.so on AIX, Solaris SPARC, Solaris Opteron, Linux and z/Linux platforms, libjmsam.sl on HPUX pa RISC and HPUX Itanium platforms, and libjmsam.dll on Windows platforms)
  • See the Teradata Tools and Utilities Access Module Reference (B035‑2425) for the name of the access module file for each platform.

     

    A personal shared library file name can be used if custom access module is used.

    The AXSMOD option is not required for importing disk files on either networkattached or mainframeattached client systems, or magnetic tape files on mainframeattached client systems. It is required for importing magnetic tape and other types of files on networkattached client systems.

    To specify the OLE DB Access Module, Named Pipes Access Module, or the WebSphere MQ Access Module for specific platforms, see the Teradata Tools and Utilities Access Module Reference (B035‑2425).

    Usage Notes  

    Table 25 describes the things to consider when using the AXSMOD command.

     

    Table 25: Usage Notes for AXSMOD

    Topic

    Usage Notes

    When to Use the AXSMOD Command

    The AXSMOD command is not required for loading:

  • Disk files on either network or mainframeattached client systems
  • Magnetic tape files on mainframeattached client systems
  • It is required for loading magnetic tape and other types of files on networkattached client systems.

    Command Placement

    When using an access module, the AXSMOD command must be stated before the DEFINE command in the Teradata FastLoad job script. If the AXSMOD command is stated after the DEFINE command, Teradata FastLoad terminates with an error message.

    Example  

    The following example provides the volume set name and owner as initialization parameters for the REELlibrarian access module, called libprmrl.so:

    AXSMOD libpmrl.so “V FastLoad O lmn” ;

    where

  • libpmrl.so is the name of the access module
  • FastLoad is the name of the volume set
  • lmn is the owner of the volume set