Hi all,

My customer has challenged me and other 3rd part developers to prepare
some tests for different DBMS.
They have given us a sort of 'pseudo query SQL statement' that we must
implement and run against the databases we are choosing...

This one is very simple... insert 1 milion records.

Here is the table

create table TB_LargeTable (
OneID INTEGER,
OneStatus char(1),
OneDate TimeStamp
);


they sent us a script with a milion rows of:

insert into TB_LargeTable values ( 1 , 'A' , '20020101' );
insert into TB_LargeTable values ( 2 , 'C' , '20020101' );
insert into TB_LargeTable values ( 3 , 'A' , '20020102' );
.... until a milion
insert into TB_LargeTable values ( 1000000 , 'T' , '20020821' );

What would be the best way to run this script?
Will FB understand this date format YYYYMMDD?
( Of course I have tried to run the script. After 2 hours nothing has
been done, I figured out that I was missing something.)
Is there a native tool (ie. isql) that could handle file this large?
How can I use it?

Please don´t get me wrong , but others has ran this same script for
different RDMS and they run just fine in under an our. I guess I must
use the right tool to run this script.
All the systems are the same. Win2k Pro 512 MB, 60 Gbytes.
All the RDBMS are installed locally, so we are running the script on
the same machine where the SQL Server is.


Best regards,
Clément