data management with 'qdata'

static link version

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!

example syntax

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.

--- Home --- © 1996 Prime Data Corp. --- Links ---

LinkExchange Member