15.10 - About the Access Module Initialization String - Access Module

Teradata Tools and Utilities Access Module Reference

prodname
Access Module
vrm_release
15.10
category
Programming Reference
featnum
B035-2425-035K

About the Access Module Initialization String

When referencing the operating mode in the initialization string, do not use batch or prompt; only noprompt and the blank value are valid. (This does not apply to using Teradata PT.)

Syntax

where:

 

Option

Description

noprompt

  • Removes the prompt for data source specifications.
  • Shows a progress dialog box during load or export operations.
  • If jobid is not mentioned along with the option, the first job (the default job) is executed.
  • batch

  • Removes the prompt for data source specifications.
  • Prevents the progress dialog box from being displayed during load operations.
  • Allows the Teradata OLE DB Access Module to operate without user interaction.
  • If jobid is not mentioned along with the option, the first job (the default job) is executed.
  • ''

  • The syntax symbolizes empty initialization string or blank string.
  • Prompts for data source specifications by opening the Teradata OLE DB AXSMOD dialog box.
  • Shows a progress dialog box during load or export operations.
  • If jobid is not mentioned along with the option, the first job (the default job) is executed.
  • jobid = jobnum

  • jobid is the keyword.
  • jobnum is a positive integer value specified by the user to execute a particular job from the amj file.
  • Access Module Commands

    The initialization string for the Teradata OLE DB Access Module consists of a single specification of the operating mode for the access module; however, to launch the Teradata OLE DB Access Module, the initialization string for BTEQ and the load and export utilities must be empty (""). (If the initialization string contains prompt, the script fails.) For the specific commands and command options for each supported Teradata utility, see “Access Module Calls” on page 19.

     

    Table 2: Commands for Teradata Utilities 

    Client Utility

    Command

    Description

    BTEQ

    EXPORT

    IMPORT

    Use single straight quotes.

    See the descriptions of the EXPORT and IMPORT commands in the Basic Teradata Query Reference (B035‑2414).

    FastExport

    EXPORT

    IMPORT

    Use single straight quotes.

    See the descriptions of the EXPORT and IMPORT commands in the Teradata FastExport Reference (B035‑2410).

    FastLoad

    AXSMOD

    Use double straight quotes.

    See the descriptions of the AXSMOD command in the Teradata FastLoad Reference (B035‑2411).

    MultiLoad

    IMPORT

    Use single straight quotes.

    See the descriptions of the IMPORT command in the Teradata MultiLoad Reference (B035‑2409).

    TPump

    AXSMOD

    IMPORT

    Use single straight quotes.

    See the descriptions of the AXSMOD and IMPORT commands in the Teradata Parallel Data Pump Reference (B035‑3021).