Question on Import Statement syntax

John Esak john at valar.com
Tue Sep 19 17:55:29 PDT 2006


> John,
> Thanks very much for your help.   I'll give it a try.
>
> Much appreciated,
> Phil

No problem, hope it is at least a possible way out...

Someone mentioned this would be lots of overhead... and CHAIN might be a
better choice. Don't use CHAIN much, so I didn't think of it.  Besides, I
rarely, if ever, do IMPORTS while actually standing in the file I'm
IMPORTING "into". Instead, I stand in a *stand* file on one record and do
the IMPORT in a loop. Each record I import, I do a lookup free to the
desired file and post the data into it, write it, then get the next IMPORT
record. When there are none left... it's done. So, using this method, you
would only have to determine the delimiter scheme, CALL the approppriate
IMPORT table and loop until all the records are imported. Only one CALL as I
would do it

John




More information about the Filepro-list mailing list