Re: 0.15.6!!

[Frank Richter <frichter@xxxxxxxx>]

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               frichter@esda.com
Hauptstr. 76, D-09392 Auerbach        IBMMAIL(DEMDK9DK)
+---
| This is the LINUX5250 Mailing List!
| To submit a new message, send your mail to LINUX5250@midrange.com.
| To subscribe to this list send email to LINUX5250-SUB@midrange.com.
| To unsubscribe from this list send email to LINUX5250-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---