RE: [UV] ODBC Account Flavor

2004-04-20 Thread Anthony Youngman
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

2004-04-19 Thread Tom Firl
 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