Collating Sequence For Data

If you are merging data from multiple sources using EBCDIC, you need access to SQL tables that are stored in databases created with the correct collating sequence. To get the data to come out in the correct sort sequence or to be included correctly when specified in WHERE clauses, all tables that are used with this pre-processor must be created in a database that specifies the EBCDIC collating sequence. See the chapter Create Database for more details on creating databases with EBCDIC collating sequences.