blob: c85a1e990b9751dc5ff3d824c73077a39a210c55 (
plain)
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
|
BEGIN {
chdir 't' if -d 't/lib';
@INC = '../lib';
require Config; import Config;
if ($Config{'extensions'} !~ /\bOS2(::|\/)REXX\b/) {
print "1..0\n";
exit 0;
}
}
#extproc perl5 -Rx
#! perl
use REXX;
$db2 = load REXX "sqlar" or die "load";
tie $sqlcode, REXX, "SQLCA.SQLCODE";
tie $sqlstate, REXX, "SQLCA.SQLSTATE";
tie %rexx, REXX, "";
sub stmt
{
my ($s) = @_;
$s =~ s/\s*\n\s*/ /g;
$s =~ s/^\s+//;
$s =~ s/\s+$//;
return $s;
}
sub sql
{
my ($stmt) = stmt(@_);
return 0 if $db2->SqlExec($stmt);
return $sqlcode >= 0;
}
sub dbs
{
my ($stmt) = stmt(@_);
return 0 if $db2->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");
print "\n", $rexx{'MSG'};
exit 1;
}
sql(<<) or error("connect");
CONNECT TO sample IN SHARE MODE
$rexx{'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 $rexx{'NAME'}\n";
}
sql(<<) or error("close");
CLOSE c1
sql(<<) or error("rollback");
ROLLBACK
sql(<<) or error("disconnect");
CONNECT RESET
exit 0;
|
