×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I stand corrected. Thanks Chuck.
Celebrating 10-Years of SQL Performance Excellence
http://centerfieldtechnology.com/training.asp
-----Original Message-----
Subject: Re: SQL INSERT help
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
midrange.com
