During data export, the content of character fields is left-aligned and filled up with spaces (blanks).
During data import, the blanks after the field content are removed.
Long character fields are typically stored in a database in columns of type LONG. Because they can far exceed the length of a line of an ASCII file and since they may also contain line delimiters, these kinds of fields cannot be stored inside a normal ASCII file. Additional input/output files are required for this purpose, for which a special field type (M) has to be specified in table SMO7ASCSTR .
The content of numeric fields is right-aligned and filled up with spaces (blanks). A decimal point (".") is used for decimal numbers.
Note
If you do not want to use a decimal point, you can define that another character (a comma, for example) should be used instead (see parameter file CRMASCAD ).
Binary data can consist of all kinds of data including data that can be used in ASCII files for control or formatting purposes. Therefore, this kind of data cannot be stored as text data in normal ASCII files. Additional input/output files are required for this purpose, for which a special field type (R) has to be specified in table SMO7ASCSTR .
Date fields have the format DD.MM.YY.
Note
You can use a different date format by changing the parameter #AToDate in file CRMASCAD .