Re: V6 export to V5 DBMS
From: Wallis Pereira <wpereira_at_ISI.EDU>
Date: 27 Feb 92 23:02:36 GMT
Message-ID: <20828_at_venera.isi.edu>
Date: 27 Feb 92 23:02:36 GMT
Message-ID: <20828_at_venera.isi.edu>
Robin,
A dump to the INSERT statement is one way, (the only way I know).
Try this:
SELECT 'INSERT INTO DEPT', ' VALUES (' || DEPTNO || ',' ||
INSERT INTO DEPT
'''' || DNAME || '''' || ',' || '''' || LOC || ''''
|| ');'
FROM DEPT;
This results in:
VALUES(10, 'ACCOUNTING','NEW YORK');
.
.
.
etc.
Got this from the Advanced Forms 3.0 class. I recommend it.
Wally Pereira
wpereira_at_isi.edu
Received on Fri Feb 28 1992 - 00:02:36 CET