Update image columns

[Stuart Blackburn]

We have an urgent problem that we need to resolve and our Sybase
experience is limited. We're using Sybase ASE 15.0.3

Table structures are as follows:

Table T1:
C1 numeric(18)
C2 image
C3 int
C4 varchar

Table T2:
C1 numeric(18)
C2 image

Sequence of events are as follows:

1. Application A inserts the following record into T1 (1,null,
5,'junk')
2. Application B inserts the following record into T2 (1,<an jpeg
image>)
3. After step #2 happens, we need a trigger on T2 to fire that will
UPDATE T1.C2 with the contents of T2.C2. We have no issues getting
this to work with numeric or varchar columns, but we haven't had any
luck getting it to work for the image columns.

Any help would be greatly appreciated.

Thanks