On Thu, Jan 13, 2000 at 10:17:06AM -0500, Sean Porterfield wrote:
>
> > Now, if someone can get the data transfer to Excel spreadsheet on Linux, I
> won't
> > need to dual boot anymore...
>
> Can Excel import XML? I hacked a utility called asdbget which uses FTP and
> some AS/400 specific magic to retreive files from the 400 and put translate
> them in to ASCII XML format (which has a header describing the complete
> file layout).
>
> The theory is that you could pipe it to a quick hack of a perl script using
> XML::Parser that could translate it into any other format.
>
>
> I don't know anything about XML (yet?) but I'm extremely interested in your
> AS400 magic! I'd really like to be able to use ODBC to get data from AS/400
> files. I don't always need to get the whole file (although a lot of times,
> I do need the whole file or can work with it if I do get the whole file.)
>
> I'm about to embark on a project where I'll need to update a database on
> Linux periodically with data from the AS/400. Obviously I need an automatic
> way of doing this. I know this isn't exactly on topic (well, not even close
> anymore, I guess...) Anyone doing this? Is there an appropriate forum for
> this discussion?
I use IBM's toolbox for java to get data from our 400 to a tab separated
textfile. I also have a little TCL script, which needs java, tclblend
and jt400 to get the output of a select from our 400 to a table in mysql
or postgresql.
Should I post it to this list, it's quiet small (about 100 lines each)?
--
Esda Feinstrumpffabrik GmbH
Abt. EDV, Frank Richter [EMAIL PROTECTED]
Hauptstr. 76, D-09392 Auerbach IBMMAIL(DEMDK9DK)
+---
| This is the LINUX5250 Mailing List!
| To submit a new message, send your mail to [EMAIL PROTECTED]
| To subscribe to this list send email to [EMAIL PROTECTED]
| To unsubscribe from this list send email to [EMAIL PROTECTED]
| Questions should be directed to the list owner/operator: [EMAIL PROTECTED]
+---
