The exchange scheme code.
The exchange scheme is created in the Exchange Schemes (daxch0501m000) session.
Field Relations (Import) (daxch0122s000)Use this session to create relations between logical ASCII file fields and LN table fields per batch in an exchange scheme. Nota The relation on table level is created in the Table Relations (Import) (daxch0521m000) session.
Exchange Scheme The exchange scheme code. The exchange scheme is created in the Exchange Schemes (daxch0501m000) session. Batch The batch code in an exchange scheme. A batch is created in the Batches (daxch0104m000) session. Table Rel A sequential number that identifies the table relation. It makes the table relation unique in the batch. Table The LN table name that must contain data from the ASCII file. ASCII File The code of the ASCII file that contains data that is transferred to a LN table during an import procedure. Nota The ASCII file code represents the logical ASCII file. The ASCII file code is created in the ASCII Files (daxch0102m000) session. Serial No. Enter a serial number to make the field relation unique in the table relation. The serial number is only used as an identifier and does not have to be sequential. Nota The number is increased automatically: when you define a new field relation, LN enters a number of value ten greater than the field relation with the highest value. Because numbers like 10, 20, 30, and so on are used, it is easy to insert field relations at a later stage. Table Field Enter the code of the field in the LN table that is filled with data from a field in an ASCII file during an import procedure. Array Element The element number of an array field. This field is only used if the LN field is defined as an array field in the data dictionary. The elements in an array can be filled individually. Nota The element number cannot exceed the array depth. Field Value Se la casella di controllo è selezionata,, the data transfer is based on the data in an ASCII file field. Nota Select the ASCII file field in the following field. Field Value Enter the code of the ASCII file field that contains data that is transferred to a field in the LN table during an import procedure. Conversion Enter a conversion code. To modify data in a field relation, use a conversion code before the data of an ASCII file field is transferred to the LN table field. Nota Conversion tables are created in the Conversion Tables (daxch0105m000) session. Condition If this check box is selected, the import process can be manipulated by using conditions. Nota The conditions are created in the Conditions (daxch0114m000) session. Condition The condition that is used in the transfer of data from the ASCII file field to the LN table field. The return value of the condition will be used to fill the LN table field. Nota Conditions are defined in the Conditions (daxch0114m000) session. Conversion Enter a conversion code. Use a conversion code to modify data in a field relation before the return value of a condition is transferred to the LN table field. Nota Conversion tables are created in the Conversion Tables (daxch0105m000) session. Constant Se la casella di controllo è selezionata, a constant value is loaded into the LN table field. Constant The value that will be assigned to the LN table field during import. Conversion Enter a conversion code. Use a conversion code to modify data in a field relation before the constant value is transferred to the LN table field. Nota Conversion tables are created in the Conversion Tables (daxch0105m000) session. Increment Se la casella di controllo è selezionata,, the import is based on increment. Start Value Enter the initial serial number of the field relation in a table relation that starts the data transfer. The start value is filled by LN if one of the higher-level fields in the index changes. Nota This field can only be filled if the Increment check box on the General tab of the Field Relations (Import) (daxch0122s000) session under Based on is selected. Increment Value Define a value to update the start value of the field relation during an import process. Esempio If the start value is 25 and the increment value is 10, the values used for the LN table fields are 25, 35, 45, and so on. Nota This field can only be used if the Increment check box on the General tab of the Table Relations (Import) (daxch0121s000) session under Based on is selected. Default Se la casella di controllo è selezionata,, the default value, as defined in the data dictionary, is transferred to the LN table field. Text Se la casella di controllo è selezionata, additional information is added to the table relation. The text is generated in the text editor. Click Text to start the text editor. Text Number Se la casella di controllo è selezionata, the physical ASCII file field contains a text number. Do not select this check box if the physical ASCII file contains a number that must be converted into the contents of a text number. Nota This check box can only be selected if the LN table field has a text domain and the ASCII file is numeric. Append Text Se la casella di controllo è selezionata, the text to be imported is appended to the existing text. You can only select this check box if the LN table field is a text field and the Text Number check box is cleared. If the Append Text check box is cleared, new text is copied to a new text record and the text number is written to the current record. Text Language The language code of the text in the ASCII file field. If a language is defined, the text is stored in that specific language during an import. A language can be defined in these situations:
Nota The language is defined in the Linguaggi software (ttaad1110s000) session. Text Lang. Field Enter the name of the ASCII file field that can be used to define the language if it is not known at the time of setting up the exchange scheme. A Text Language field can be defined in these situations:
Overwrite field Se la casella di controllo è selezionata, and an existing record is overwritten, the LN field is overwritten if no condition is specified, or the return condition returns true. This condition is defined in the following field, if required. Condition Enter a condition code. If an existing record is inserted, then the value of the field is overwritten if the return value of the overwrite condition is true. You can automatically generate a condition if you click Create/Edit. In that case, the condition for overwriting code contains the ASCII file code with the extension .OVR. Preconditions for the over write condition:
Nota The condition must be of the Boolean type. Update Field Se la casella di controllo è selezionata, a record is updated when the return value of the update condition is true. Condition Enter a condition code. The field is updated when the return value of the update condition is true. Records that must be updated with an import based on indicators, or based on audit, start with the letter u. You can automatically generate a condition if you click Create/Edit. In that case, the condition for overwriting code contains the ASCII file code with the extension .UPD. Precondition for the update condition:
Nota This condition is of the Boolean type.
| |||