Variables

This document describes the predefined variables that are available in the Exchange module.

These variables are available:

  • triton.table
  • triton.field
  • element.no
  • ascii.file
  • ascii.file.name
  • run.number
  • try.number
  • xch.type
  • redo.type
  • cntl.type
  • import.company
  • export.company
  • startup.company
  • no.rec.read
  • no.rec.write
  • no.err.rejects
  • no.cond.rejects
  • no.rec.skip
Note: Note that, with the exception of import.company, export.company and startup.company, the variables are implemented as a define, and cannot directly be used in queries, for example do not write: where daxch008.runn = :run.number but write instead: where daxch008.runn = :1 wherebind (1, run.number)

triton.table

VARIABLE NAME triton.table

TYPE string

FORMAT ppmmmnnn pp=package mmm=module nnn=table number

DESCRIPTION The LN table which is currently exported or imported.

triton.field

VARIABLE NAME triton.field - LN field name

TYPE string of length 18

FORMAT ppmmmnnn.cccccccc pp=package mmm=module nnn=table number cccccccc=field code

DESCRIPTION This variable contains the name of the LN field to which the condition may be corresponding. The field name will contain 8 characters of the table name also eg. tiitm001.item. This is valid only if the condition is used at field relations level.

element.no

VARIABLE NAME element.no - Element number of array

TYPE numeric

DESCRIPTION This is the element number of an array, if the LN field accessed by variable 'triton.field' is of type array. This variable along with triton.field specifies the field to be updated using the condition. This field is only valid if the condition is used at field relations level.

ascii.file

VARIABLE NAME ascii.file

TYPE domain daxch.casf

DESCRIPTION The ASCII file that is used in the current table relation.

ascii.file.name

VARIABLE NAME ascii.file.name

TYPE domain daxch.path

DESCRIPTION The physical ASCII file name (full path) of the sequential file currently being read (import) or written (export)

run.number

VARIABLE NAME run.number

TYPE domain daxch008.runn

DESCRIPTION Current Run Number.

try.number

VARIABLE NAME try.number

TYPE domain daxch008.tryn

DESCRIPTION Current Try Number

xch.type

VARIABLE NAME xch.type

TYPE domain daxch.txch

DESCRIPTION The type of exchange.

redo.type

VARIABLE NAME redo.type

TYPE domain daxch008.redo

DESCRIPTION Type of redo taken from form field Processing Type.

cntl.type

VARIABLE NAME cntl.type

TYPE domain daxch008.cntl

DESCRIPTION Control Type

import.company

VARIABLE NAME import.company - Company number for import

TYPE long

DESCRIPTION This is a numeric field of type 'long'. It contains the company number for which the import is being done. This company number will be as specified on the screen during 'Import Data' program or if not entered there then it will be as specified on batch level. This variable is only valid in conditions used in import.

export.company

VARIABLE NAME export.company - Company number for export

TYPE long

DESCRIPTION This is a numeric field of type 'long'. It contains the company number for which the export is being done. This company number will be as specified on the screen during 'Export Data' program or if not entered there then it will be as specified on batch level. This variable is only valid in conditions used in export.

startup.company

VARIABLE NAME startup.company

TYPE long

DESCRIPTION This is a numeric field of type 'long'. It contains the company number from which the run is executed. It is the company in which the log table is updated.

no.rec.read

VARIABLE NAME no.rec.read - Number of records read

TYPE Numeric(long)

DESCRIPTION This variable contains the number of records read from the ascii file specified for the batch line. This variable can be useful for conditions to be used for a 'stop mechanism'.

no.rec.write

VARIABLE NAME no.rec.write - Number of records written

TYPE Numeric(long)

DESCRIPTION This variable contains the number of written records (inserted or updated) for a batch line from the ascii file specified for the batch line. This variable can be useful for conditions to be used for a 'stop mechanism'.

no.err.rejects

VARIABLE NAME no.err.rejects - Number of records rejected due to errors

TYPE Numeric(long)

DESCRIPTION This variable contains the number of records rejected because of errors like reference does not exist, domain range is invalid, etc. while processing records from an ascii file for the batch line. This variable can be useful for conditions to be used for a 'stop mechanism'.

no.cond.rejects

VARIABLE NAME no.cond.rejects - Number of records rejected due to conditions

TYPE Numeric(long)

DESCRIPTION This variable contains the number of records rejected because of conditions like

  • add, overwrite or delete conditions, etc. while processing records from an ascii file for the batch line. This variable can be useful for conditions to be used for a 'stop mechanism'.

no.rec.skip

VARIABLE no.rec.skip

TYPE long

DESCRIPTION The number of records which are skipped without any action.