I have interbase database (version 6.0.1) in which I am importing data from an external table created from other interbase database (version 7.1)
External table is defined as
CREATE TABLE EXT_ANALITIKA EXTERNAL 'C:\External\From_AST\EXT_ASTTT.TXT' (
And stored procedure for importi9ng is defined as
CREATE PROCEDURE SET_EXT_ ASTTT
AS BEGIN
INSERT INTO ASTTT (
*... )
SELECT *... FROM ext_ ASTTT
WHERE id not in (select id from ASTTT);
END
External table have size over 1.2GB and over 2.600.000 records.
I am using small application for importing which is scheduled to work once a day.
Every day I have somehow difference of 40.000 records between 2 tables without any visible reason. When I start stored procedure from interbase manager manually I then can import the difference. Is something wrong with this version of interbase(6.0.1)? Maybe that version can’t support so big file size?
External table is defined as
CREATE TABLE EXT_ANALITIKA EXTERNAL 'C:\External\From_AST\EXT_ASTTT.TXT' (
And stored procedure for importi9ng is defined as
CREATE PROCEDURE SET_EXT_ ASTTT
AS BEGIN
INSERT INTO ASTTT (
*... )
SELECT *... FROM ext_ ASTTT
WHERE id not in (select id from ASTTT);
END
External table have size over 1.2GB and over 2.600.000 records.
I am using small application for importing which is scheduled to work once a day.
Every day I have somehow difference of 40.000 records between 2 tables without any visible reason. When I start stored procedure from interbase manager manually I then can import the difference. Is something wrong with this version of interbase(6.0.1)? Maybe that version can’t support so big file size?