Question on Import Statement syntax
George Simon
GSimon at americanriverintl.com
Tue Sep 19 06:58:01 PDT 2006
As you have discovered, multiple import statements are not allowed.
Perhaps using xlate to convert different record delimiters into one of
your choosing is the answer.
If not, maybe you can "call" different tables just having the import
line based on the delimiter given.
In other words, have a normal import line as if you were only dealing
with a single delimiter. Preceding lines could "call" other tables
based on whatever criteria you are using to determined the delimiter and
then they would skip over the "normal" import line. This would give you
a single import line, which would allow the table to pass syntax, and
yet have different import statements.
I have not tested this idea, but I think it might work.
-----Original Message-----
From: filepro-list-bounces+george=worldest.com at lists.celestial.com
[mailto:filepro-list-bounces+george=worldest.com at lists.celestial.com] On
Behalf Of Phil Hausman
Sent: Tuesday, September 19, 2006 8:12 AM
To: Filepro List
Subject: Question on Import Statement syntax
I have a process that reads non-filePro files from multiple sources -
the
files are delimited and unfortunately, the sources don't all use the
same
record delimiter. I would like to maintain a single processing table
but
I can't seem to get the syntax correct to allow the import statement to
be
variable based on a parameter. I tried moving the value of the record
delimiter to variable xy and including r=(xy) in the import statement
but I
get a syntax error. Multiple import statements do not appear to be
allowed. Can anyone help on this?
Thanks in advance,
Phil
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list
More information about the Filepro-list
mailing list