Such a statement works for me on V5R3M0. If the release of DB2 does
not support the table expression in the VALUES(), then remove the
VALUES() and make the insert a full subselect of literal values and
fields. For example:
insert into mylibrary/myfile (warehouse, product#, description)
select 'WH','123456789', M.description from product_master M
where M.prdno = '123456789'
Or IMO, better than above:
insert into mylibrary/myfile (warehouse, product#, description)
select 'WH', M.prdno, M.description from product_master M
where M.prdno = '123456789'
Regards, Chuck
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
