Présentation	Documentation				L'équipe	Sérialisation
	Programmes	Objets	Libs Utilitaires	Libs Internes
	Editeur	Syntaxes	Windows	Versions

SCR/AL1 - TOME I. Les programmes

43. SCR4W_OD : gestion de bases de données ODBC

Syntaxe

Syntax : scr4w_od <-parm args> ...
 
Parm Args     Description
-------------------------
-listdsn           : list all registred Data Sources
-listtbls dsn      : list all tables for DSN dsn (for all DSNs if dsn empty)
-infos dsn         : list version infos for DSN dsn
-query dsn "sql"   : exec query on dsn and display result dataset
-sql dsn "sql"     : exec sql on dsn
-sqln dsn "sql"    : translate (do NOT exec) sql into dsn driver native SQL
-sqlfile dsn file  : exec lines (sql code) from file on dsn
-addaccess dsn descr file : add MS Access Data Source
-user user pwd     : set user name and password on DSN
-h                 : display this help
-v                 : verbose
 
Examples
--------
scr4w_od -listdsn
    display all registred Data Sources
scr4w_od -listtbls access1
    display in SCR/AL1 format the table definitions from dsn access1
scr4w_od -user JMP JMP -query informix "Select * from clients"
    open DSN informix for user JMP, password JMP
    execute the SQL cmd and display each record of the result set
scr4w_od -sql access1 "INSERT INTO client VALUES(17, 'Bureau du Plan')"
    open DSN access1 and insert a new record
scr4w_od -sqlfile access1 sqlfile
    execute all command in sqlfile on dsn access1
 
Syntax of sqlfile
-----------------
Each line contains a SQL command.
If the first character is the plus character (+), the result data set
is displayed.
 
Example
-------
+SELECT * from client ORDER BY name
DELETE from client WHERE name='Bureau du Plan'