6258

data management with 'qdata'

if you know sql and batch files you can use this to manage simple database tasks, import mainframe files and run automated batch data processing

in conjuntion with a file transfer program (like qweb) you might even be able to get some real work done!

qdata output datasource table1;table2;table3

    outputs three files in a CSV format separated by a random string

    ((-))

qdata /data=datasource /input=file

    inputs a number of files in CSV format

    optionally separated by a random string

    prefixed with formatting specs (see output of above)

qdata output odbc-data-source table /fixed=5,8+0,3 taildelim=TRUE names=FALSE

    outputs three fixed-width columns of a table named "table"
    - with the second column right-aligned and padded with zeroes

qdata sql datasource "sp_list_tables 'dbo.db'"

    executes a sql stored procedure

qdata sql datasource "q_list_groups" /param=%user%

    executes a parameterized DAO query, passing the environment variable "user" as the first parameter

qdata /input=file /format=CAT

    executes one or more qdata commands in the "CAT"file

    including sql/output (unless verification is specified)

qdata help

    explains more options than listed here

recently completely rewritten so the commands make more sense....and so that the timestamp-synchronization features are faster

Shareware Notice

If you want to get documentation, DLL import LIBS, email tech support, and other advanced features, make a check for $19.95 out to:

  Prime Data Corp. #QSS0021
    111 Broadway 11th Fl
    New York, NY 10006

Include the product id number (#QSS0021), your e-mail address, and your real address.