Buddy,
thanks for the light bulb!
I loaded the data into a temporary table and it loaded all 60,000+ rows but
it did it fast and no error messages.
Then I just deleted all the null rows and zippo, I got it!
Makes a big diff between temp tables and actual tables.
Bernie Lis
----- Original Message -----
From: "Walker, Buddy" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Thursday, September 29, 2005 3:47 PM
Subject: [RBG7-L] - RE: Loading data into a table
Bernie
Try
PROJECT TEMPORARY newTable FROM GoodTable USI ALL WHE COUNT = 0
LOAD the data into newtable
DEL Rows FROM newtable whe colname is null
APPEND newTable to GoodTable
Buddy
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard
Lis
Sent: Thursday, September 29, 2005 3:37 PM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Loading data into a table
I have an ascii file with currency values, 1 value per row.
There are 64,000 + rows in the ascii file - only 40 of them have data.
The rest are null
How can I get rid of the null rows before loading them into the table?
If I load them with null rows I keep getting the message that it cannot
be null even if messages are off. This means I have to press ok 60,000
+ times.
If I eliminate not null constraint, The database gets humongus (is there
such a word).
Any ideas?
Bernie Lis
