Re: [U2] External database
Thanks for reply. Can you guide me by some example to do this task. In fact I have little bit experience of ODBC drivers and their usage. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/External-database-tp39618p39625.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] External database
Many thanks, In fact I am running old version of UniVerse 9.6 and due to is limitation of 2GB file, I am designing an interface to transfer data from U2 data files to Oracle. In this regard I have heard about ODBC drivers but very little knowledge how to use them. I will be grateful if you can guide by an example how to configure ODBC/BCI driver for this task. Regards Rauf -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/External-database-tp39618p39626.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] External database
Many thanks for the reply. I am running U2 9.6 old version which has not this functionality. Can you please guide further to do this task. I have not good knowledge in terms of ODBC drivers and interface of databases. Thanks in advance. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/External-database-tp39618p39627.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] External database
Seems rather extreme to go to Oracle just to get around 2GB file limit ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of asad50089 Sent: Sunday, 13 January 2013 9:18 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] External database Thanks for reply. Can you guide me by some example to do this task. In fact I have little bit experience of ODBC drivers and their usage. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/External-database-tp39618p39625.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] External database
On 13/01/13 09:02, Phil Walker wrote: Seems rather extreme to go to Oracle just to get around 2GB file limit ;-) Agreed. But if he wants some advice, there's a few things I'd say. First he's better just upgrading to the latest UV :-) Or can he use distributed files? Asad - if you don't know what they are, you break the file into bits, each one of which can be 2Gb ... Oh - and if you're worried about disk space in UV, I think for every two gig of UV data, Oracle will take five or six gig to store it :-) The other thing is, look at Pickwiki. There's loads of useful code there, and the ODBC guide was actually written against 9.6! Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of asad50089 Sent: Sunday, 13 January 2013 9:18 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] External database Thanks for reply. Can you guide me by some example to do this task. In fact I have little bit experience of ODBC drivers and their usage. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/External-database-tp39618p39625.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] External database
If the only issue is the 2Gig limit, you can use Universe distributed files. -Original Message- From: asad50089 asadr...@live.com To: u2-users u2-users@listserver.u2ug.org Sent: Sun, Jan 13, 2013 12:20 am Subject: Re: [U2] External database Many thanks, In fact I am running old version of UniVerse 9.6 and due to is limitation of 2GB file, I am designing an interface to transfer data from U2 data files to Oracle. In this regard I have heard about ODBC drivers but very little knowledge how to use them. I will be grateful if you can guide by an example how to configure ODBC/BCI driver for this task. Regards Rauf -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/External-database-tp39618p39626.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] External database
UV 9.6 also supports 64-bit files On Jan 13, 2013, at 3:17 AM, asad50089 asadr...@live.com wrote: Thanks for reply. Can you guide me by some example to do this task. In fact I have little bit experience of ODBC drivers and their usage. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/External-database-tp39618p39625.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] External database
As long as your OS and the filesystem is already 64-bit enabled - you should be able to resize the UV file to 64BIT (make sure you have a verified backup first :)). Otherwise, use UV distributed file create a logical file view of your UV physical files. Note that BCI is a programmatic API interface only - that implements OBDC calls, it's not a DB-level interface of likes of EDA or UV/Net, etc. Useful largely with batch-like operations to push/pull data. Since you already use Nabble, search the U2 forums there for UV ODBC setup... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of asad50089 Sent: Sunday, 13 January 2013 7:20 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] External database Many thanks, In fact I am running old version of UniVerse 9.6 and due to is limitation of 2GB file, I am designing an interface to transfer data from U2 data files to Oracle. In this regard I have heard about ODBC drivers but very little knowledge how to use them. I will be grateful if you can guide by an example how to configure ODBC/BCI driver for this task. Regards Rauf ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users