Home » RDBMS Server » Networking and Gateways » AS400 SQL & NULLS
AS400 SQL & NULLS [message #367757] Fri, 03 March 2000 05:04
Dave N
Messages: 1
Registered: March 2000
Junior Member
I'm using SQL on the AS400 in an SQLRPGLE PGM, using in the oracle access mgr. to access oracle on a unix box.

Problem: I select a record containing null values in certain columns, change a key field then try to do an insert into the same table. I get am sqlcod 969 record dose not add joblog shows MCH3601. If I exclude the null columns on the insert it works fine.

Ques: How can I insert the record with out excluding the columns that contain the nulls values?
Example:
DHeader ds
d Comp 10a varchar (Key)
d Item 10a varchar (key)
d Itm_cls 1a varchar *(this field has Nulls)
dhdind s 1b 0 dim(3)
exec sql select * from itm_mstr into :header:hdind
where item ='1234567890'
eval Comp = 'New_COMP'
exec sql Insert * into itm_mstr
values :header:hdind
Previous Topic: Automating Oracle8 Client Install
Next Topic: ODBC problem connecting with TCP/IP
Goto Forum:
  


Current Time: Sun Feb 25 21:59:05 CST 2024