linux/unix data base

[Guest.Visitor]

Is there a linux/unix data base product that views its database the same way the AS/400 does? I would like to be able to write some java programs that would allow me to CHAIN (or what ever the read by key is called ) and other file operations the same as the AS/400. Thanks for your input.

[Guest.Visitor]

Hi Thomas, My strong advice generally is to learn SQL and use JDBC, that's the way of the world, even on the 400. JDBC 2.0 makes this easier. IMO it is a mistake to use Record level I/O in java other than to get something going quickly in a way familiar to RPG/COBOL programmers -- I'm sure that's why IBM provided it. Java does provide RandomAccessFile, which can provide the IO you're looking for, but it's out there by itself. The rest is stream oriented or JDBC ( SQL based. ) I recall an article in JavaWorld that built something using RandomAccessFile, you can search there. It's possible that someone has ported/built a DBase, Btrieve or other C database allowing record type IO. You might search for these and linux/unix and hope A) that they are multiuser, enterprise ready and B) someone has provided a java interface. Otherwise you'd have to build JNI wrappers, which sort of kills the "quick and easy " idea. Best, Joe Sam Joe Sam Shirah Autumn Software Consulting/Development/Outsourcing Please Note New Email: jshirah@attglobal.net Visit our User Group at: http://www.jax400.com