RunSQL

Wed, 09/24/2008 - 20:17 |  hdanzl
0

RunSQL.nxscript will execute a SQL command and allow to format the output with delimeters, quoting etc. This can be used to very quickly export some data to a CSV (or similar) file.

How to use?: 

You can call it like this (for a local server with no user/password):

nxCommand /Type:cmdExecScript /Script:runsql.nxscript /database:dbname 
  /sql:"select * from t1" /delimiter:%20 /qualifier:%22 > export.txt

This will create nice CSV formated file of the given query.

Category: 
Server Side Command Scripts
Current Version: 
1.00
Supported Products: 
NexusDB V3
AttachmentSize
runSQL.zip916 bytes
Login or register to post comments |  Print this chapter |  Send to friend |  PDF version |  metadata Tags:
Home

Powered by Drupal and Drupal Theme created with Artisteer.