SQL0304N Problem(AS/400 zoned,packed decimal)

[jip102]

Hi All!
My DB is AIX5.3 DB2V8.1(FixPack10)
And DCS catalog AS/400(AS/400 830 OS/400 ver 5.1.5)
I only execute " select CODE(typeecimal) from COMLIB.TB00Z" ,

SQL0304N A value cannot be assigned to a host variable because the value is not within the range of the host
variable's data type.

 

[Mercury2]

Try out:

select Cast( CODE as Decimal(5, 0) ) from COMLIB.TB00Z

 

[jip102]

hi all
I have big problem.
my db is AIX5.3 DB2V8.2(FixPack 12)
and DCS catalog AS/400(5.1 830)
the problem is:
As/400->table nickname:web400.s@ch01a(federate wrapper)
AIX5.3 DB2V8.2->SNDCH01A
COLUMN->RECSTS(char(1))

db2 " insert into web400.s@ch01a(RECSTS) select RECSTS from SNDCH01A fetch first 1 rows only"

error:
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1822N Unexpected error code "-332" received from data source "WEB400".
SQL0332N There is no available conversion for the source code page "970" to the target code page "".SQLSTATE=560BD.