Dear Eric,
Thanks for Reply.
As per example below, Do I need to provide the same columns of existing table ?
And below example will insert data in new external table and also it will create .unl file for new external table? Am I correct?
Kindly revert.
CREATE EXTERNAL TABLE emp_ext
( name CHAR(18) EXTERNAL CHAR(18),
address VARCHAR(40) EXTERNAL CHAR(40),
empno INTEGER EXTERNAL CHAR(6)
)
USING (
FORMAT 'FIXED',
DATAFILES
(
"DISK:/work2/mydir/emp.fix"
)
);
INSERT INTO employee SELECT * FROM emp_ext;
------------------------------
AMIT PATEL
------------------------------
Original Message:
Sent: Fri February 19, 2021 03:15 AM
From: Eric Vercelletto
Subject: backup tables
Hi Amit,
I would prefer inserting the existing tables contents into external tables which are the image of the existing tables.
Unload is slow
or HPL but much more complex to activate
------------------------------
[eric] [Vercelletto] []
[Founder]
[kandooerp.org]
[Pont l'Abbé] [France]
[+33 626 52 50 68]
Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Original Message:
Sent: Fri February 19, 2021 02:10 AM
From: AMIT PATEL
Subject: backup tables
Hello All,
Kindly let me know , I have to drop 220 tables from production environment and each table around 1 million rows (300000).
These table dropping is part of some activity so that day Backup will not run.
Concern database has around 5K tables.
So what type of backup should I take?
Will Unload work ere?
Thanks
Amit Patel
------------------------------
AMIT PATEL
------------------------------
#Informix