John Hester | 1 Jul 01:10 2010

Re: [U2] Retrieving data from remote SQL DB from Universe via ODBC?

Check out the UniVerse ODBC Guide included in the documentation on the
UV installation media.  If you don't have it, you can get it here:

http://www.rocketsoftware.com/u2/pubs/library/

It's pretty straightforward.  You'll also need the ODBC client available
here:

http://www.rocketsoftware.com/u2/downloads/

-John

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Ken Ford
Sent: Wednesday, June 30, 2010 2:45 PM
To: u2-users <at> listserver.u2ug.org
Subject: [U2] Retrieving data from remote SQL DB from Universe via ODBC?

Fellow U2 users,
The Universe documentation suggests that it is possible to retrieve data
from a remote SQL DB on a Windows server from Universe using ODBC.  We
do the reverse here at present, but haven't done what I am attempting.
Can anyone verify or shed some light on how to do this, please?  We have
Universe 10.3 running on AIX and have ODBC in use.

Thanks,
Ken Ford,
FirstMac Pty Ltd,
Brisbane, QLD
(Continue reading)

Neil Richards | 1 Jul 01:40 2010

Re: [U2] Retrieving data from remote SQL DB from Universe via ODBC?

As you are AIX you will also need the ODBC clients for AIX which are not provided by Rocket Software or Universe.

I use a product from fusionware www.fwic.net<http://www.fwic.net> called the legacy MV2SQL bridge
thats provides fast read and write access to our SQL server or Oracle databases with minimal programming.
I remember Robert Houben writing a blog on this subject at http://www.fwic.net/NewsInfo/FusionWareIntegrationBlogs/tabid/116/EntryId/6/Easy-access-to-SQL-data-from-MV-BASIC.aspx

Neil
________________________________
From: u2-users-bounces <at> listserver.u2ug.org [u2-users-bounces <at> listserver.u2ug.org] On Behalf Of
John Hester [JHester <at> momtex.com]
Sent: Wednesday, June 30, 2010 4:10 PM
To: U2 Users List
Subject: Re: [U2] Retrieving data from remote SQL DB from Universe via ODBC?

Check out the UniVerse ODBC Guide included in the documentation on the
UV installation media. If you don't have it, you can get it here:

http://www.rocketsoftware.com/u2/pubs/library/

It's pretty straightforward. You'll also need the ODBC client available
here:

http://www.rocketsoftware.com/u2/downloads/

-John

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org<mailto:u2-users-bounces <at> listserver.u2ug.org>
[mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Ken Ford
Sent: Wednesday, June 30, 2010 2:45 PM
(Continue reading)

John Hester | 1 Jul 02:01 2010

Re: [U2] Retrieving data from remote SQL DB from Universe via ODBC?

Sorry, I see that I misunderstood the client-server orientation when I
responded the 1st time.  The correct documentation to reference when UV
is the ODBC client is the UV BCI guide.  We have data going both
directions and use a 3rd party ODBC driver from OpenLink to query MS SQL
from UV.  I think they also support AIX.

-John

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Neil Richards
Sent: Wednesday, June 30, 2010 4:40 PM
To: U2 Users List
Subject: Re: [U2] Retrieving data from remote SQL DB from Universe via
ODBC?

As you are AIX you will also need the ODBC clients for AIX which are not
provided by Rocket Software or Universe.

I use a product from fusionware www.fwic.net<http://www.fwic.net> called
the legacy MV2SQL bridge thats provides fast read and write access to
our SQL server or Oracle databases with minimal programming. I remember
Robert Houben writing a blog on this subject at
http://www.fwic.net/NewsInfo/FusionWareIntegrationBlogs/tabid/116/EntryI
d/6/Easy-access-to-SQL-data-from-MV-BASIC.aspx

Neil
________________________________
From: u2-users-bounces <at> listserver.u2ug.org
[u2-users-bounces <at> listserver.u2ug.org] On Behalf Of John Hester
(Continue reading)

David Wolverton | 1 Jul 02:17 2010
Picon
Picon

Re: [U2] AUTO: Haydon Bishop is out ofthe office.(returning 26/06/2010)

Honestly... if he fixes this or unsubscribes I'll lose half the humor and
joy of my work life....

You guys rock....

DW

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Michael Martin
Sent: Friday, June 25, 2010 3:42 PM
To: U2 Users List
Subject: Re: [U2] AUTO: Haydon Bishop is out ofthe office.(returning
26/06/2010)

Out of office slam
Why does he torment always
Hayden Bishop Die 

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Keith Conley
Sent: Friday, June 25, 2010 3:25 PM
To: U2 Users List
Subject: Re: [U2] AUTO: Haydon Bishop is out ofthe office.(returning
26/06/2010)

Please resubmit this in Haiku form.

Thanks.
(Continue reading)

Don Robinson | 1 Jul 15:26 2010
Picon

[U2] Copying Universe files with an Index.

Hello all,

I'm using Universe on AIX and I have a need to copy an Universe file from one account to another for historical
usage. Using the AIX cp command takes a couple of minutes but the Index is not useable.
Using Universe COPY or Basic read and write takes much longer.

I believe the problem is due to Universe storing the full path to the Index files in the header of the data file.

Is there anyway to "fix" the header without corrupting the file?

What's the best way to handle this?
 
Thanks,
Don Robinson
_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Perry Taylor | 1 Jul 15:27 2010

Re: [U2] Copying Universe files with an Index.

Have a look at the SET.INDEX command.  The path to the index files is store in the file header and you'll need to
use SET.INDEX to change it to reflect the new location of the index files.

Perry

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org [mailto:u2-users-bounces <at> listserver.u2ug.org] On
Behalf Of Don Robinson
Sent: Thursday, July 01, 2010 7:26 AM
To: u2-users <at> listserver.u2ug.org
Subject: [U2] Copying Universe files with an Index.

Hello all,

I'm using Universe on AIX and I have a need to copy an Universe file from one account to another for historical
usage. Using the AIX cp command takes a couple of minutes but the Index is not useable.
Using Universe COPY or Basic read and write takes much longer.

I believe the problem is due to Universe storing the full path to the Index files in the header of the data file.

Is there anyway to "fix" the header without corrupting the file?

What's the best way to handle this?
 
Thanks,
Don Robinson
_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
(Continue reading)

inquieti | 1 Jul 15:42 2010

Re: [U2] AUTO: Haydon Bishop is out ofthe office.(returning 26/06/2010)


I've ordered "I've seen Haydon Bishop" t-shirts.

David Wolverton wrote:
> 
> Honestly... if he fixes this or unsubscribes I'll lose half the humor and
> joy of my work life....
> 
> You guys rock....
> 
> DW
> 
> -----Original Message-----
> From: u2-users-bounces <at> listserver.u2ug.org
> [mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Michael Martin
> Sent: Friday, June 25, 2010 3:42 PM
> To: U2 Users List
> Subject: Re: [U2] AUTO: Haydon Bishop is out ofthe office.(returning
> 26/06/2010)
> 
> Out of office slam
> Why does he torment always
> Hayden Bishop Die 
> 
> -----Original Message-----
> From: u2-users-bounces <at> listserver.u2ug.org
> [mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Keith Conley
> Sent: Friday, June 25, 2010 3:25 PM
> To: U2 Users List
> Subject: Re: [U2] AUTO: Haydon Bishop is out ofthe office.(returning
(Continue reading)

Peter S. Goldberger | 1 Jul 15:44 2010

Re: [U2] AUTO: Haydon Bishop is out ofthe office.(returning 26/06/2010)

Maybe he just can't find his office

inquieti wrote:
> I've ordered "I've seen Haydon Bishop" t-shirts.
>
> David Wolverton wrote:
>   
>> Honestly... if he fixes this or unsubscribes I'll lose half the humor and
>> joy of my work life....
>>
>> You guys rock....
>>
>> DW
>>
>> -----Original Message-----
>> From: u2-users-bounces <at> listserver.u2ug.org
>> [mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Michael Martin
>> Sent: Friday, June 25, 2010 3:42 PM
>> To: U2 Users List
>> Subject: Re: [U2] AUTO: Haydon Bishop is out ofthe office.(returning
>> 26/06/2010)
>>
>> Out of office slam
>> Why does he torment always
>> Hayden Bishop Die 
>>
>> -----Original Message-----
>> From: u2-users-bounces <at> listserver.u2ug.org
>> [mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Keith Conley
>> Sent: Friday, June 25, 2010 3:25 PM
(Continue reading)

Don Robinson | 1 Jul 15:54 2010
Picon

Re: [U2] Copying Universe files with an Index.

Perry,

THANKS!

I just didn't look in the right manual, it's in userref.
Don Robinson

 

________________________________
From: Perry Taylor <perry.taylor <at> zirmed.com>
To: U2 Users List <u2-users <at> listserver.u2ug.org>
Sent: Thu, July 1, 2010 9:27:49 AM
Subject: Re: [U2] Copying Universe files with an Index.

Have a look at the SET.INDEX command.  The path to the index files is store in the file header and you'll need
to use SET.INDEX to change it to reflect the new location of the index files.

Perry

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org [mailto:u2-users-bounces <at> listserver.u2ug.org] On
Behalf Of Don Robinson
Sent: Thursday, July 01, 2010 7:26 AM
To: u2-users <at> listserver.u2ug.org
Subject: [U2] Copying Universe files with an Index.

Hello all,

I'm using Universe on AIX and I have a need to copy an Universe file from one account to another for historical
(Continue reading)

Address | 1 Jul 15:57 2010
Picon

Re: [U2] AUTO: Haydon Bishop is out ofthe office.(returning 26/06/2010)

Hayden Bishop -- The Man, The Myth, The Legend.

--- On Thu, 7/1/10, Peter S. Goldberger <peterg <at> eoftech.com> wrote:

From: Peter S. Goldberger <peterg <at> eoftech.com>
Subject: Re: [U2] AUTO: Haydon Bishop is out ofthe office.(returning 26/06/2010)
To: "U2 Users List" <u2-users <at> listserver.u2ug.org>
Date: Thursday, July 1, 2010, 9:44 AM

Maybe he just can't find his office

inquieti wrote:
> I've ordered "I've seen Haydon Bishop" t-shirts.
>
> David Wolverton wrote:
>   
>> Honestly... if he fixes this or unsubscribes I'll lose half the humor and
>> joy of my work life....
>>
>> You guys rock....
>>
>> DW
>>
>> -----Original Message-----
>> From: u2-users-bounces <at> listserver.u2ug.org
>> [mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Michael Martin
>> Sent: Friday, June 25, 2010 3:42 PM
>> To: U2 Users List
>> Subject: Re: [U2] AUTO: Haydon Bishop is out ofthe office.(returning
>> 26/06/2010)
(Continue reading)


Gmane