Decius: I assume your databases are both DB2. If you go to the control center and left-mouse-click a table then you see options for to copy it into a different DB2 database. The CC would let you see the command it will use. Maybe this is the command you need. TIA Juan Lanus TECNOSOL
LeGrand Decius wrote: > Hello everyone, > > > > Is there a DB2 SQL syntax to insert data from one database table to > another database table. > > I would like to avoid exporting and importing data. > > > > This what I have in mind. > > > > > > Example: > > > > Database Names: (MEMDB1 and MEMDB2) > > UserName: test > > Schemas (tst and prod) > > > > connect to MEMDB1 user test; > > connect to MEMDB2 user test; > > insert into MEMDB1.tst.Specialty (id_number, specialty) > > select id_number, specialty from MEMDB2.prod.Specialty; > > disconnect current; > > > > Thanks in advance... I'm open to all recomendations. > > > ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
