comp.lang.idl-pvwave archive: archive » SQL access without Dataminer

Home » Public Forums » archive » SQL access without Dataminer

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: SQL access without Dataminer [message #34044 is a reply to message #33927]

Thu, 13 February 2003 02:42

R.Bauer
Messages: 1424
Registered: November 1998

Senior Member

Jonathan Greenberg wrote:
> Does anyone know if IDL has any SQL access capability without purchasing
> Dataminer? Are there any freeware SQL interface libraries for IDL?
>
> --j
>

In prinziple I am using at the moment something like this.

line=''
READ,line
txt=['use DATABASE ;',line]
del_file,'data.sql'
put_file,'data.sql',txt

SPAWN,'mysql -h 127.0.0.1 -u data -P3306 < data.sql',result

This is more a question to Randall.

Is it possible to write a dlm using mysql as it is now with parameter
submission I did by spawn in this example?

Another nice command is

mysqlshow --host=127.0.0.1 --user=data

SEE ALSO
isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1),
mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1),
msql2mysql (1), perror (1), replace (1), safe_mysqld (1),
which1 (1), zap (1),

regards

Reimaar

--
Reimar Bauer

Institut fuer Stratosphaerische Chemie (ICG-I)
Forschungszentrum Juelich
email: R.Bauer@fz-juelich.de
------------------------------------------------------------ -------
a IDL library at ForschungsZentrum Juelich
http://www.fz-juelich.de/icg/icg-i/idl_icglib/idl_lib_intro. html
============================================================ =======

Report message to a moderator

[Message index]

		SQL access without Dataminer By: Jonathan Greenberg on Sat, 08 February 2003 12:04
		Re: SQL access without Dataminer By: Randall Skelton on Tue, 11 February 2003 16:44
		Re: SQL access without Dataminer By: MKatz843 on Mon, 10 February 2003 09:55
		Re: SQL access without Dataminer By: R.Bauer on Thu, 13 February 2003 02:42

Previous Topic:	Re: Questions about using CATCH
Next Topic:	Re: QROMB and parameters

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Oct 08 19:21:36 PDT 2025

Total time taken to generate the page: 0.00369 seconds