WinSQL Professional

User's Guide

Revision 4.0

Thank you for using WinSQL professional. WinSQL is a simple yet powerful utility for programmers, DBAs and system administrators.

This guide provides you detailed instructions on how to use the program. Although the user interface is very intuitive and easy to understand, you might find this guide useful when doing some advanced features.

If you find any area in the document that needs improvement, please contact us at support@indus-soft.com

Getting Started__________________________________________________________ 1

Requirements_________________________________________________________ 1

Installation and setup___________________________________________________ 1

Registering WinSQL ODBC Drivers_______________________________________ 1

Uninstalling WinSQL____________________________________________________ 2

Configuring ODBC______________________________________________________ 3

Opening the ODBC administrator_________________________________________ 3

Different kinds of DSN__________________________________________________ 3

User DSN_____________________________________________________________________ 3

System DSN___________________________________________________________________ 4

File DSN______________________________________________________________________ 4

Creating a new DSN____________________________________________________ 4

Running Queries________________________________________________________ 6

Establishing connection to a back-end database______________________________ 6

DSN-Less Connections___________________________________________________________ 6

Connection options_____________________________________________________ 7

Server side cursor_______________________________________________________________ 7

Auto commit transactions_________________________________________________________ 7

Running Queries_______________________________________________________ 8

Opening more than one query sets_________________________________________ 8

Query Set Workbook_____________________________________________________________ 9

Displaying results in Grid or Text_________________________________________ 9

Comments____________________________________________________________ 9

SQL syntax___________________________________________________________ 9

Catalog Tip__________________________________________________________ 10

Parameterized queries_________________________________________________ 10

Syntax highlighting____________________________________________________ 11

Limitation___________________________________________________________ 11

SQL Wizard__________________________________________________________ 11

Show native SQL_______________________________________________________________ 12

Configuration options__________________________________________________ 12

# of history command____________________________________________________________ 13

# of records for browsing_________________________________________________________ 13

# of records to return from a query__________________________________________________ 13

Parameter string________________________________________________________________ 14

Maximum errors allowed in export___________________________________________________ 14

Screen refresh rate______________________________________________________________ 14

Write SQL string with result set____________________________________________________ 14

Sticky catalog tip_______________________________________________________________ 14

Result set Fonts________________________________________________________________ 14

Right align numeric values________________________________________________________ 14

Show warning messages_________________________________________________________ 14

Parse comments locally__________________________________________________________ 14

Select a complete row in grid______________________________________________________ 14

Query terminator string__________________________________________________________ 15

Terminator must be on a new line___________________________________________________ 15

Terminator string is case sensitive__________________________________________________ 15

Supported functions_____________________________________________________ 16

How to use scalar functions_______________________________________________________ 16

String functions________________________________________________________________ 16

Numeric functions______________________________________________________________ 18

Time, Date, and Interval functions__________________________________________________ 20

System functions_______________________________________________________________ 22

Viewing and Printing Database Catalog____________________________________ 23

Providing filters_______________________________________________________ 23

Browsing data________________________________________________________ 24

Applying Filter_________________________________________________________________ 24

Sorting records________________________________________________________________ 24

Using Insert / Update record wizard_______________________________________ 24

Using Strings and Dates in the wizard________________________________________________ 25

Ignoring a field and NULL values___________________________________________________ 26

Executing Stored Procedures____________________________________________ 26

Using new table wizard_________________________________________________ 27

Reverse Engineering a table design_______________________________________ 27

Printing_____________________________________________________________ 27

Publishing HTML Pages_________________________________________________ 28

Export templates______________________________________________________ 28

Creating new HTML template______________________________________________________ 28

Using existing HTML template_____________________________________________________ 30

Using Database Diff____________________________________________________ 31

Understanding how objects are compared____________________________________________ 32

Generated Report_______________________________________________________________ 33

Starting the wizard_____________________________________________________ 35

Example_____________________________________________________________ 35

Populating primary tables_________________________________________________________ 35

Let’s get started________________________________________________________________ 36

Text file______________________________________________________________________ 39

Number of records to generate_____________________________________________________ 40

Transaction support_____________________________________________________________ 41

Running queries while data is being generated_________________________________________ 41

Populating secondary tables______________________________________________________ 42

Ignoring a field_______________________________________________________ 42

Drawing Entity-Relationship Diagrams____________________________________ 43

Toolbar buttons_______________________________________________________ 43

Saving and Reading the file______________________________________________ 44

Exporting Data________________________________________________________ 45

Export templates______________________________________________________ 45

Starting a new export____________________________________________________________ 45

Using existing templates__________________________________________________________ 47

Export Template File Editor______________________________________________ 48

Command Line Options_________________________________________________ 49

Usage:______________________________________________________________ 49

Examples____________________________________________________________ 50

Incorrect usage_______________________________________________________ 50

WinSQL Plug-in_______________________________________________________ 52

XML file format________________________________________________________ 52

Plug-in Elements______________________________________________________ 54

Extension nodes______________________________________________________ 57

Database Diff Report____________________________________________________ 59

How does it work_____________________________________________________ 59