Question on Import Statement syntax
GCC Consulting
gccconsulting at comcast.net
Tue Sep 19 08:21:35 PDT 2006
> -----Original Message-----
> From:
> filepro-list-bounces+gccconsulting=comcast.net at lists.celestial
> .com
> [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.c
> elestial.com] On Behalf Of John Esak
> Sent: Tuesday, September 19, 2006 9:41 AM
> To: Phil Hausman
> Cc: Fplist (E-mail)
> Subject: RE: Question on Import Statement syntax
>
> Phil,
>
> Why not put the various IMPORT types into different CALL
> tables and then base which CALL you use on the criteria you
> have in the CALLING table?
> Would that be too much work?
>
> John
If the import is just one file at a time, this might better be a "chain"
rather the a "call". Granted, the call table would be held in memory but is
seems like excess overhead to keep calling the same processing table.
One could even track the delimiter being used and if it changed, chain back
to the starting table and then chain out to the new table. However, I doubt
that a delimiter would change in the same file.
Richard
>
>
> > -----Original Message-----
> > From: filepro-list-bounces+john=valar.com at lists.celestial.com
> > [mailto:filepro-list-bounces+john=valar.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
>
> _______________________________________________
> 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