| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
