Re: Reading text file by Powerbuilder program

Chaiw Kok Kee wrote: > > 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/ Go to Powersoft's Customer Service & Support site (http://support.sybase.com/fd_search.html) and search for document ID 42020. The article describes how to read a file larger than 32766 bytes. It's a simple loop.