Ken

Your problem I guess is that cobol programmers frequently dont care about
the IMAGE schema and you are doing stuff with ODBC.

What you need to do is load up IMAGESQL and key in HELP SPLIT.

Character fields can be SPLIT into one or more fields of a different type.

Try it as packed and if that if that doesn't work try integer.

UK Ken
(The LINKWAY ODBC chap)
"Born, Ken" <[log in to unmask]> wrote in message
news:91606302p3u@enews1.newsguy.com...
> 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.
>
> I tried various PC Translations in ODBC setup and received mixed results.
> Any ideas?
>