Skip to Content
0
Former Member
Apr 17, 2008 at 05:49 PM

Abend on CHAR assigned to NUMC to Query

189 Views

Hi all,

An existing pgm is in such a way that CHAR type variable (data element) retrieved from a table is assigned to another variable type NUMC (in a transparent table).

This NUMC variable is used for a join in another query with a table of same field but type CHAR.

Eg :

x1(char) = x2 (NUMC)

Door no. is CHAR in table , NUMC in transparent table in a query join.

This causes dump.

probably error in assignment statement itself or when query is executed..

there's a space( or dot - not sure) in x1 which is not accepted by x2.

Any help on this?

Thanks.