in reply to Multiple SQL statements
UPDATE: Thanks bobione - fixed that problem :)#!/usr/bin/perl -w use DBI; use strict; my $foo=DBI->connect('DBI:Sybase:server=FOO', user, pass)||die "Connec +tion Failed! $DBI::errstr\n"; my $sql="CREATE TABLE dbo.foo\n(bar int NOT NULL)\nCREATE TABLE dbo.fo +otoo\n(bar int NOT NULL)"; my $fooexec=$foo->prepare($sql); $fooexec->execute()||die "SQL failed: $!\n"; $fooexec->finish(); $foo->disconnect(); exit (0);
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: Multiple SQL statements
by bobione (Pilgrim) on Jul 19, 2001 at 18:58 UTC |