Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL0304N Problem(AS/400 zoned,packed decimal)

Status
Not open for further replies.

jip102

Programmer
May 1, 2006
12
KR
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(type:Decimal) 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.


 
Try out:

select Cast( CODE as Decimal(5, 0) ) from COMLIB.TB00Z
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top