×
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.
Easy.
DB2 for i SQL reference
What's new for IBM i 7.2
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/db2/rbafzwhatsnew.htm?lang=en-us
...
Support for INSERT and CREATE TABLE AS to run SELECT from a remote RDB
...
create table rob.scrapme as (
select * from gdihq.erplxf.rco
with data
Table SCRAPME created in ROB.
select * from rob.scrapme
SELECT statement run complete.
Want me to test further? Ok.
STRCMNTRC CFGOBJ(LANLINSYS) CFGTYPE(*LIN) MAXSTG(32m)
strsql
create table rob.scrapme as (
SELECT * FROM gdihq.rob.brms WHERE LIBRARY = '*IFS')
with data
ENDCMNTRC CFGOBJ(LANLINSYS) CFGTYPE(*LIN)
PRTCMNTRC CFGOBJ(LANLINSYS) CFGTYPE(*LIN) FMTTCP(*YES)
TCPIPADR('10.17.6.33')
Yep, it only transferred across the selected rows.
I tested this going from 7.2 to 7.1
and from 7.1 to 7.2.
Works fine.
7.1-15142-TR10
7.2-15135-TR2
Rob Berendt
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
