| Variables |  |
| This document describes the predefined variables that are available in the Exchange module. The following 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 ERP LN table which is currently exported or imported. triton.field VARIABLE NAME triton.field - ERP 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 ERP 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 ERP 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. Related topics Functions Libraries |