Dumping a collation table is the first step in modifying the table.

To dump a collation table:

  1. In the Data Administration tool, choose Admin > Dump Data and Definitions > Collation. The Dump Collation Tables dialog box appears.
  2. In the Output File field, type a dump name (_tran.df is the default), then choose OK.
  3. Enter the name of the code page with which the file will be written out.

The _tran.df file contains the collation table for your database. The following figure shows a sample _tran.df file.

Sample _tran.df file

UPDATE DATABASE "?"
  COLLATION-TRANSLATION-VERSION 1.0-16
  COLLATION-NAME "basic"
  INTERNAL-EXTERNAL-TRAN-TABLE 
  ?
  EXTERNAL-INTERNAL-TRAN-TABLE 
  ?
  CASE-INSENSITIVE-SORT 
  /*000-015*/ 000 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 
  /*016-031*/ 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 
  /*032-047*/ 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 
  /*048-063*/ 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 
  /*064-079*/ 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 
  /*080-095*/ 080 081 082 083 084 085 086 087 088 089 090 091 092 093 094 095 
  /*096-111*/ 096 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 
  /*112-127*/ 080 081 082 083 084 085 086 087 088 089 090 123 124 125 126 127 
  /*128-143*/ 176 177 178 179 180 185 186 187 188 191 192 193 194 195 196 197 
  /*144-159*/ 200 201 202 203 204 205 206 213 217 218 219 220 223 242 000 158 
  /*160-175*/ 255 173 189 156 207 190 221 245 249 184 229 174 199 240 199 238 
  /*176-191*/ 248 241 253 252 239 230 244 250 247 251 229 175 172 171 243 168 
  /*192-207*/ 065 065 065 065 065 143 146 067 069 069 069 069 073 073 073 073 
  /*208-223*/ 068 078 079 079 079 079 079 158 157 085 085 085 085 089 222 000 
  /*224-239*/ 065 065 065 065 065 143 146 067 069 069 069 069 073 073 073 073 
  /*240-255*/ 068 078 079 079 079 079 079 246 157 085 085 085 085 089 222 089 
  CASE-SENSITIVE-SORT 
  /*000-015*/ 000 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 
                                          . 
                                          . 
                                          . 
  /*240-255*/ 208 110 111 111 111 228 111 246 155 117 117 117 117 121 231 121 
.PSC
cpstream=ibm850
.0000005361
Note: The IBM850 code page that appears in the trailer of the sample _tran.df file in the figure is not the code page name of the database. It is the code page that was used to write out the data definition (.df) file.