2 chdir 't' if -d 't/lib';
4 require Config; import Config;
5 if ($Config{'extensions'} !~ /\bOS2(::|\/)REXX\b/) {
16 $db2 = load REXX "sqlar" or die "load";
17 tie $sqlcode, REXX, "SQLCA.SQLCODE";
18 tie $sqlstate, REXX, "SQLCA.SQLSTATE";
32 my ($stmt) = stmt(@_);
33 return 0 if $db2->SqlExec($stmt);
39 my ($stmt) = stmt(@_);
40 return 0 if $db2->SqlDBS($stmt);
47 print "ERROR in $where: sqlcode=$sqlcode, sqlstate=$sqlstate\n";
48 dbs("GET MESSAGE INTO :msg LINEWIDTH 75");
49 print "\n", $rexx{'MSG'};
53 sql(<<) or error("connect");
54 CONNECT TO sample IN SHARE MODE
56 $rexx{'STMT'} = stmt(<<);
57 SELECT name FROM sysibm.systables
59 sql(<<) or error("prepare");
62 sql(<<) or error("declare");
63 DECLARE c1 CURSOR FOR s1
65 sql(<<) or error("open");
69 sql(<<) or error("fetch");
72 last if $sqlcode == 100;
74 print "Table name is $rexx{'NAME'}\n";
77 sql(<<) or error("close");
80 sql(<<) or error("rollback");
83 sql(<<) or error("disconnect");