RE: [sqr-users] Loading fixed length flat file into Sybase table

[the dragon <ceprn@hotmail.com>]

That's the only choice you have.  One insert = one tag to the database, and 
each record needs to be inserted.
 
I beleieve that's the way it is with any RDBMS and any application.
 
What is it you're looking for?
 
peace,
clark 'the dragon' willis
PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the only 
real finite asset that you have, and once used it can never be recovered, so 
don't waste it by giving it away. I work to live; I don't live to work. "Time 
is the coin of your life. It is the only coin you have, and only you can 
determine how it will be spent. Be careful lest you let other people spend it 
for you." -- Carl Sandburg (1878 - 1967) It is impossible to defeat an ignorant 
man in argument. -- William G. McAdoo Religion is regarded by the common people 
as true, by the wise as false, and by the rulers as useful. -- Seneca "I 
distrust those people who know so well what God wants them to do because I 
notice it always coincides with their own desires." - Susan B. Anthony> Date: 
Thu, 27 Sep 2007 14:57:38 -0400> From: madhudvm@gmail.com> To: 
sqr-users@sqrug.org> Subject: [sqr-users] Loading fixed length flat file into 
Sybase table> > Hi,> > What is the better way to load the data from fixed 
length flat file into a> sybase database table using SQR. Number of rows in the 
file vary from 10,000> to 50,000> > I'm doing something like the code below, 
but my concern is for each insert> statement it goes to the database and could 
be performance issue.> 
**************************************************************************************************************************>
 open 'aaaa.txt' AS 100 for-reading record=600:fixed status=#z> > while 1> > 
read 10 into $name:40 $Id:30 $location:50> > if #end-file> > break> > end-if> > 
begin-sql> > insert into cust (name, Id, location)> > values ($name, $ID, 
$location)> > end-sql> > add 1 to #inserts> > if #inserts >= 100> > begin-sql> 
> commit transaction> > begin transaction> > end-sql> > move 0 to #inserts> > 
end-if> end-while> 
************************************************************************************************************>
 Thanks!!> Maddy> 
_________________________________________________________________
Help yourself to FREE treats served up daily at the Messenger Café. Stop by 
today.
http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctWLtagline

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users