Execute a SQL query or a file
Parameters
Data Source Name: name of the ODBC source for the connexion to the database
Authentification
- Login: a login to connect to the database
- Password: the password associated to the login
Outputs
You have three kinds of outputs:
1. Result to table: in this case a table is created automatically with the result
When you execute this treatment you can see the result in Table Manager in the bottom of the screen.
2. Result to file: in this case a CSV file is created with the result
File Format:
- in the result file you indicate “\r\n” for a CRLF (Carriage Return Line Feed)
- if you have a lot of column in the result file you indicate the Text Delimiter
When you execute this treatment you can see the result in a CSV file below .
3. Result to file: in this case a XML file is created with the result
When you execute this treatment you can see the result in a file with an extension CSV below
Query
Your request SQL can either be in a File Query or to be in Text Query:
1. Use File query: indicate the repertory and file name
2. Use Text Query: to write the Select Command
Get the world's favorite Script generator at http://www.paseosoft.com/