This sounds like an ODBC rather than a perl problem:
Have you enabled the account for ODBC? If it has not been created as a SQL
Schema, you need to explicitly set up ODBC in that account using the HS.ADMIN
menu in the HS.ADMIN account. (LOGTO HS.ADMIN, run HS.ADMIN, select option 3 to
enable an account).
BUT BEFORE YOU DO SO...
I would suggest reading the UniODBC and UCI guides before doing so unless it is
just a test account. There are a couple of steps you need to perform before it
is likely to be successful: as a minimum you need to ensure any fields you are
working with use D/I types (not A/S) and have their SQL types, M/S and any
associations fully defined. You will also need to include them in an @SELECT
phrase in the dictionary to make columns visible.
There's a few other things that you should really do to make a clean ODBC-like
view, but that will probably be enough for testing the concept. Oh, and
remember to run HS.UPDATE.FILEINFO after any dictionary changes: ODBC uses a
file information cache that only updates after this command.
I have a draft article about using UniVerse ODBC/OleDB I can probably send you
if you email me off-list: sorry to anyone else but it won't be publically
available until next month (it is being printed in a newsletter first).
Brian
>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/
