Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Abend on CHAR assigned to NUMC to Query

Former Member
0 Kudos

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.

2 REPLIES 2

Former Member
0 Kudos

hi ,

there is one thing to remember when we filling the value with a number it will take like this. .. 24 as 24 only but when it is numeric it is like 0024 like ...so when on the assignment there may be some proble...or if u pass the same no of zeros to the character it will work i think..

regards,

venkat.

0 Kudos

To be specific

character field is moved to NUMC field..

NUMC is not accepting space ? right ?

how to handle this..

This is not a problem with zeros. but space in the middle

example : CHAR 13 4 is moved to NUMC .