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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
|
BEGIN {
chdir 't' if -d 't/lib';
@INC = '../lib';
require Config; Config->import;
if ($Config{'extensions'} !~ /\bOS2(::|\/)REXX\b/) {
print "1..0\n";
exit 0;
}
}
use OS2::REXX;
sub stmt
{
my ($s) = @_;
$s =~ s/\s*\n\s*/ /g;
$s =~ s/^\s+//;
$s =~ s/\s+$//;
return $s;
}
sub sqlcode
{
OS2::REXX::_fetch("SQLCA.SQLCODE");
}
sub sqlstate
{
OS2::REXX::_fetch("SQLCA.SQLSTATE");
}
sub sql
{
my ($stmt) = stmt(@_);
return 0 if OS2::REXX::_call("sqlexec", $sqlexec, "", $stmt);
return sqlcode() >= 0;
}
sub dbs
{
my ($stmt) = stmt(@_);
return 0 if OS2::REXX::_call("sqldbs", $sqldbs, "", $stmt);
return sqlcode() >= 0;
}
sub error
{
my ($where) = @_;
print "ERROR in $where: sqlcode=", sqlcode(), " sqlstate=", sqlstate(), "\n";
dbs("GET MESSAGE INTO :MSG LINEWIDTH 75");
my $msg = OS2::REXX::_fetch("MSG");
print "\n", $msg;
exit 1;
}
REXX_call {
$sqlar = DynaLoader::dl_load_file("h:/sqllib/dll/sqlar.dll") or die "load";
$sqldbs = DynaLoader::dl_find_symbol($sqlar, "SQLDBS") or die "find sqldbs";
$sqlexec = DynaLoader::dl_find_symbol($sqlar, "SQLEXEC") or die "find sqlexec";
sql(<<) or error("connect");
CONNECT TO sample IN SHARE MODE
OS2::REXX::_set("STMT" => stmt(<<));
SELECT name FROM sysibm.systables
sql(<<) or error("prepare");
PREPARE s1 FROM :stmt
sql(<<) or error("declare");
DECLARE c1 CURSOR FOR s1
sql(<<) or error("open");
OPEN c1
while (1) {
sql(<<) or error("fetch");
FETCH c1 INTO :name
last if sqlcode() == 100;
print "Table name is ", OS2::REXX::_fetch("NAME"), "\n";
}
sql(<<) or error("close");
CLOSE c1
sql(<<) or error("rollback");
ROLLBACK
sql(<<) or error("disconnect");
CONNECT RESET
};
exit 0;
|
