RE: [UV] ODBC Account Flavor
All our accounts (including ODBC) are either PI or PI/Open flavour. However, as this is very close to IDEAL, it's no surprise that we don't have any (serious) problems. (If you exclude the fact that HS.UPDATE.FILEINFO seems to close the wIntegrate connection rather too often for comfort :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Firl Sent: 20 April 2004 01:05 To: U2-Users Distribution List (E-mail) Subject: [UV] ODBC Account Flavor I'm plowing through a project to setup a standard UV-ODBC table and column definition for our application. Our application database accounts are setup as PICK flavored accounts. For ODBC, we're going to setup a separate account for each application account with file pointers to the DATA portion of files and cleaned-up local dictionary files. I've been told by IBM that the "ODBC account must be IDEAL flavor". I know that isn't totally true as I have a proof-of-concept system setup where the ODBC account is setup as PICK flavor. Like application accounts, is the flavor of the ODBC account simply a matter of preference? Or are there "limitations" with ODBC and PICK flavored accounts that I should be aware of? Tom Firl Columbia Ultimate -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] ODBC Account Flavor
> My only .02 is that the fully compliant schema seems to > interact better with > odbc SQL clients - probably because using CREATE-TABLE > commands makes the > dictionaries exactly what they should be, and the creation of > things like > UV_TABLES. > We probably won't go so far as to define a SQL schema on the account, but I can definitely see how it removes many of the difficulties in getting and ODBC interface up and running. Thanks for your response... the level of feedback I'm looking for. Tom Firl Columbia Ultimate -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] ODBC Account Flavor
We've got some websites accessing pre-existing pick flavoured accounts, and another application accessing a fully compliant SQL Schema in a pick flavoured account - a new account built from scratch with CREATE-SCHEMA etc. Both are working fine - from universe 9.6 through to 10.1. My only .02 is that the fully compliant schema seems to interact better with odbc SQL clients - probably because using CREATE-TABLE commands makes the dictionaries exactly what they should be, and the creation of things like UV_TABLES. Andrew Gissing CTI Logistics -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[UV] ODBC Account Flavor
I'm plowing through a project to setup a standard UV-ODBC table and column definition for our application. Our application database accounts are setup as PICK flavored accounts. For ODBC, we're going to setup a separate account for each application account with file pointers to the DATA portion of files and cleaned-up local dictionary files. I've been told by IBM that the "ODBC account must be IDEAL flavor". I know that isn't totally true as I have a proof-of-concept system setup where the ODBC account is setup as PICK flavor. Like application accounts, is the flavor of the ODBC account simply a matter of preference? Or are there "limitations" with ODBC and PICK flavored accounts that I should be aware of? Tom Firl Columbia Ultimate -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users