We have the DataExport product that will give you DBF output from
either PFs or SQL SELECT statements. It uses CL commands, puts the
output in the IFS. It does various spreadsheet formats, too.
I have found that using a SELECT here can be the best way - then you
control the way the data is defined, to match you DBF layout.
I'm on vacation for the next 2 weeks - woohoo - but you can get a
30-day supported evaluation. Call 888.rjs.soft or email
sales@xxxxxxxxxxxxxxx - there is a manual for it at
www.rjssoftware.com under the support tab there.
BTW, it is not expensive.
At 07:21 AM 12/15/2006, you wrote:
We may purchase a software package which will accept transaction
data from our MRP system. There are special file formats which must
be populated in order for this package to be able to read the data
downloaded from the System i.
Their software wants the data downloaded to a "TransAct.DBF" file -
from which then they will pick out the data and process it.
I looks like the .DBF is a FoxPro or Dbase database format.
How would I get the System i5 data into this format - without too much hassle?
Don F. Cavaiani
'Treat every person with kindness and respect, even those who are
rude to you. Remember that you show compassion to others not because
of who they are but because of who you are.'--Andrew T. Somers
"When faced with the choice of being 'right' or being 'kind', choose
the kind option every time."
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives