Try removing the ";" (semi-colon) from your SQL query. It isn't required.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ang Suan Yong Sent: Tuesday, 2 May 2006 8:36 PM To: U2-Users New Lists Subject: [U2] UniVerse + PERL Dear All Is it possible to use Perl connect to UniVerse backend to run some UV Command , like CREATE FILE , SELECT FILE? Current im trying using DBD::ODBC , the uv connection is find but statement execution failed . any idea ?? use DBD::ODBC; my $db = DBI->connect('dbi:ODBC:UVSOURCE',"userid","password") || die("Connection failed") ; my $cmd="SELECT * FROM VOC;" ; my $stmt= $db->prepare($cmd); Error Shown as below : DBD::ODBC::db prepare failed: [IBM][UVODBC][2700828] Error ID = 23 , Severity: ERROR Facility: DBCAPERR - Line 1, column 15 (around "VOC"): SQL statement referenced a nonexistent table or view. Thanks & Regards ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
