We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR?
Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any data to the right of the real data inserted becomes spaces?
How do we get our Oracle Data Model requiring VARCHAR 255 keys to work on an AS/400?
Note the key works from AS/400 programs and commands, it is failing IBM DB2 ODBC client server access. We can insert from the varchar, but afterwards we cannot query back out of the DB2/400 without a terminal error.