Re: Reading text file by Powerbuilder program

chaiw@ibm.net (Chaiw Kok Kee) wrote in article <3488b25b.0@news1.ibm.net>... > Is it true that there is a limit to the size of text file that can be > read by Powerbuilder? > > My problem is, I'm using a Powerbuilder application to load ASCII text > file into Informix database. Users have been complaining of missing > record now and then. When I tried to reload all the data (amounting to > 78777 records/5MB+) after deleting the whole table, only 70000+ went in > although there is no error reported. Attempt to split the file into > 10,000 each and loading resulted only 2009 records out of 10,000 > successfully insert. Only manage to load in when the file size is 2,000 > records (average 70 char per rec). > > My supplier told me that the limit of text file size is 32765 byte which > I feel is ridiculous for a high end development tool. > > I would appreciate any advise from expert. > -- > Chaiw Kok Kee > Consultant > Multi-Purpose Information Technology > kkchaiw@mit.com.my > www.jaring.my/mphb/ > what fuctions/how are you loading the ascii file into the inf4 db