1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
/**************************************************
* isql
*
**************************************************
* This code was created by Peter Harvey @ CodeByDesign.
* Released under GPL 18.FEB.99
*
* Contributions from...
* -----------------------------------------------
* Peter Harvey - pharvey@codebydesign.com
**************************************************/
#include <stdio.h>
#include <stdlib.h>
#include <sqlext.h>
#include <ini.h>
char *szSyntax =
"\n" \
"**********************************************\n" \
"* unixODBC - isql *\n" \
"**********************************************\n" \
"* Syntax *\n" \
"* *\n" \
"* isql DSN [UID [PWD]] [options] *\n" \
"* *\n" \
"* Options *\n" \
"* *\n" \
"* -b Batch. No prompting etc *\n" \
"* -dx Delimit cols with x *\n" \
"* -w Wrap results in an HTML table *\n" \
"* -c Column names on first row. *\n" \
"* Only used when -d. *\n" \
"* -v Verbose. *\n" \
"* --version version *\n" \
"* *\n" \
"* Notes *\n" \
"* *\n" \
"* isql supports redirection and piping *\n" \
"* for batch processing. *\n" \
"* *\n" \
"* Examples *\n" \
"* *\n" \
"* cat My.sql | isql WebDB MyID MyPWD -w *\n" \
"* *\n" \
"* Each line in My.sql must contain *\n" \
"* exactly 1 SQL command except for the *\n" \
"* last line which must be blank. *\n" \
"* *\n" \
"* Please visit; *\n" \
"* *\n" \
"* http://www.unixodbc.org *\n" \
"* pharvey@codebydesign.com *\n" \
"* nick@easysoft.com *\n" \
"**********************************************\n\n";
#define MAX_DATA_WIDTH 300
#ifndef max
#define max( a, b ) (((a) > (b)) ? (a) : (b))
#endif
int OpenDatabase( SQLHENV *phEnv, SQLHDBC *phDbc, char *szDSN, char *szUID, char *szPWD );
int ExecuteSQL( SQLHDBC hDbc, char *szSQL, char cDelimiter, int bColumnNames, int bHTMLTable );
int ExecuteHelp( SQLHDBC hDbc, char *szSQL, char cDelimiter, int bColumnNames, int bHTMLTable );
int CloseDatabase( SQLHENV hEnv, SQLHDBC hDbc );
void WriteHeaderHTMLTable( SQLHSTMT hStmt );
void WriteHeaderNormal( SQLHSTMT hStmt, SQLCHAR *szSepLine );
void WriteHeaderDelimited( SQLHSTMT hStmt, char cDelimiter );
void WriteBodyHTMLTable( SQLHSTMT hStmt );
void WriteBodyNormal( SQLHSTMT hStmt );
void WriteBodyDelimited( SQLHSTMT hStmt, char cDelimiter );
void WriteFooterHTMLTable( SQLHSTMT hStmt );
void WriteFooterNormal( SQLHSTMT hStmt, SQLCHAR *szSepLine );
int DumpODBCLog( SQLHENV hEnv, SQLHDBC hDbc, SQLHSTMT hStmt );
|
