Database Output

[cflick1]

Has anyone developed or used a UBE that does a Database Output to a CSV file on the IFS, submitted to run on the Enterprise Server (AS/400 specifically)? Or does anyone know if this can be done? Client is running Xe in a coexistence environment, and the AS/400 (running on V5R1) as the enterprise server. They currently perform Database Output to CSV files to the local PC that is running the UBE locally.

Chris Flick
Independent Consultant
OW Xe SP15_1
AS/400 V5R1
Coexistence

 

[pcaenaro]

Hi Chris,

I have seen UBEs with database output but always to a JDE table.
But you can use a Table Conversion to do this.

Regards

Philippe CAENARO
----- Original Message -----
From: cflick1 <[email protected]>
To: <[email protected]>
Sent: Wednesday, August 15, 2001 7:54 AM
Subject: Database Output


file on the IFS, submitted to run on the Enterprise Server (AS/400
specifically)? Or does anyone know if this can be done? Client is running
Xe in a coexistence environment, and the AS/400 (running on V5R1) as the
enterprise server. They currently perform Database Output to CSV files to
the local PC that is running the UBE locally.
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Numbe
r=18717



One World B7332 SP14.2 AS400

 

[Carl_Fisher]

Yes we have done this, but only on Intel NT. I am not sure about the requirement for AS400 to specify an IFS.

You need to set the correct pathcode for the IFS and direct the CSV output there in Database Output. Note the Pathcode has to be from the Enterprise Server. Obviously this UBE Version will then only work o the Enterprise Server.

OW733.3 Xe SP 14.2
Enterprise Server - Intel NT + Oracle 8.0.6
Client - Citrix TSE + 4 NT PC's for development

 

[tom_brown]

We have written loads of CSV file output from reports which can be run on
either enterprise server or local - as long as the server can see the
network path specified by the user in processing options then the csv file
will be created. Can you AS/400 see the rest of your network? If so, use
the bsfn 'export to flat file' to create a csv file anywhere on the
network...

hope this helps..

tom brown

 

[cflick1]

Re: RE: Database Output

Tom,

I have some questions to clarify what you mentioned in your reply, which I appreciate you replying in the first place.

Currently, we have UBE's that perform database output in the UBE (insert only operation to a comma delimited file) to csv files, but they are setup to run locally and output to the local PC (C:/). What we would like to do is run these jobs on the enterprise server (AS/400), so they can be run from any PC/Client, and perform the database output to csv files on the IFS, which the client PC would have a drive mapped to these files on the IFS. We don't want the user to have the option to specify the network path. Our AS/400 can see the rest of the network. The network path that I am wanting to use is the IFS.

Do you have any example(s) of how you are doing this on the enterprise server, and is your enterprise server an AS/400? How do I specify the network path in the UBE database output, and how would I use the 'export to flat file' bsfn inconjunction with it?

Thanks!

Chris Flick
Independent Consultant
OW Xe SP15_1
AS/400 V5R1
Coexistence

 

[tom_brown]

RE: RE: Database Output

I am not too familiar with the AS/400 these days Chris, so I'm not sure how
my comments will translate to your system - we are using NT machines.
Assuming your AS/400 can see the whole network, and potentially create files
using UNC file names such as \\myserver\mycsvfile.csv then you should be ok.

The 'Export to Flat file' bsfn requires the string you would like to export
and the file name(and another parm which you seem to need to pass, but seems
to do nothing). If the file does not exist, the file will be created which
the first call to the bsfn is executed, if it does exist, lines will be
appended. Therefore, you can call the function over and over and build up a
csv file. Each line will need to be formatted manually in your program
using concat statements. Concat your first field to be output, then a
comma, then the second field etc..., then output the line using the bsfn.

So the trick is not to use database output at all, as this will not allow
you to control the file name and location(not in my version anyway).

We then use processing options so we can soft code the file location...

Hope this helps

Tom Brown

OW 733.1
NT Servers
Oracle