At 01:47 PM 12/12/2000 -0600, Born, Ken wrote:
>Greetings,
>I am perplexed with the following.  We have a database schema for a set as
>SET NAME:
>    ARRESTEE-NAMES,DETAIL
>
>       ITEMS:
>          ARRESTEE-KEY,         X8            <<SEARCH ITEM>>
>
>But the data contains the following:
>
>ARRESTEE-KEY     = (!A
>ARRESTEE-KEY     =      @V
>ARRESTEE-KEY     = (
>ARRESTEE-KEY     = (8#
>
>Why would someone define a X8 and populate it something else?  The reason
>why this is important is that I want to use ODBC to link the tables up, and
>the link is not connecting the tables correctly.  I thought about re-mapping
>the IMAGE/SQL but since it is a char(8) field, I cannot convert it to
>INTEGER.  I don't even believe I could add records to the database via ODBC
>because I have no clue what values are the above.

My first guess is that some program somewhere is using the "@" list
construct, and its buffer for the dataset is mis-aligned with the fields in
the dataset, causing unexpected values in the field you are looking at.