I see a lot of talk about this CONVERT.SQL command.  I have never used it.
 So out of curiosity I'll ask a couple of noob questions...

I saw a demo on ODBC for Universe, and the person suggested setting up a new
account and creating clean dictionaries for existing files.  (by using F
pointers).
I realize ODBC is a whole other bag of nuts entirely.

Could you do this with DataVu, or does that CONVERT.SQL command make changes
to the hash file itself, or does it just add dictionaries for SQL?  (I have
never used SQL in Universe - never saw the point really I guess).

On Wed, Sep 7, 2011 at 3:09 AM, Mecki Foerthmann <mec...@gmx.net> wrote:

> I haven't tried the slashes. Maybe that does the trick.
>
>
>
> On 07/09/2011 00:08, Wjhonson wrote:
>
>> I also have a weirdness with that server name.
>> Either it wanted the \\ in front or it didn't I can't remember which.
>> I do remember fiddling with that field.
>> Too bad it can't query "What drives are you attached to anyway?" and give
>> me those as options :)
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> -----Original Message-----
>> From: Mecki Foerthmann<mec...@gmx.net>
>> To: u2-users<u2-users@listserver.**u2ug.org<u2-users@listserver.u2ug.org>
>> >
>> Sent: Tue, Sep 6, 2011 4:03 pm
>> Subject: Re: [U2] DataVu Query [ad]
>>
>>
>> David,
>> I bet you are right, but what users want is to be able to install
>> oftware like that without having to search the documentation for hours.
>>  don't mind if I have to search for and download a JDBC driver from the
>> et to connect to SQL Server, DB2 or Oracle data sources but I expect a
>> ocket product to work straight away for U2.
>>  get a screen that asks me for the UD server name and even though that
>> ame one works for SB client, VSG, UniAdmin and tools like mvDeveloper
>> t won't connect in DataVu.
>> ll I found so far is that I need this driver (hell knows where to get
>> t from) and a file called bi.jdbc,drivers (or something like that) that
>> eeds to be created somewhere by the administrator.
>> ell, I am the administrator and I haven't got a clue how to do that!
>>
>> n 06/09/2011 23:22, David Jordan wrote:
>>  Mecki
>>  You do not need a JDBC driver, it uses uniobjects.   There is a video
>> showing
>> ow to install and read the documentation.   The installation is not
>> intuitive,
>> ut it is not hard.   I made the mistake first not to read the
>> documentation
>> hich takes you through step by step.
>>
>>  Regards
>>  David Jordan
>>
>>  -----Original Message-----
>>  From: 
>> u2-users-bounces@listserver.**u2ug.org<u2-users-boun...@listserver.u2ug.org>[mailto:
>> u2-users-bounces@**listserver.u2ug.org<u2-users-boun...@listserver.u2ug.org>
>> ]
>> n Behalf Of Gerd Forthmann
>>  Sent: Wednesday, 7 September 2011 1:00 AM
>>  To: U2 Users List
>>  Subject: Re: [U2] DataVu Query [ad]
>>
>>  Well, I can't even connect to the host. A get an error message U2DB1004.
>>  I reckon you guys really need to make this a lot easier if you want
>> people tto
>> se this and buy the other modules.
>>  In the documentation it says something about a JDBC driver that needs to
>> be
>> nstalled but isn't included in the package and some obscure file that
>> needs to
>> e created somewhere and contains connection data but to me this is just
>> Greek
>> nd doesn't mean anything.
>>  Other products like mvDeveloper just work without having to find a driver
>> omewhere and create any files by hand.
>>  I bet you can do better than that.
>>
>>  Mecki
>>  -------- Original-Nachricht --------
>>
>>> Datum: Fri, 2 Sep 2011 17:20:14 +0000
>>> Von: Daniel 
>>> McGrath<DMcGrath@**rocketsoftware.com<dmcgr...@rocketsoftware.com>
>>> >
>>> An: U2 Users 
>>> List<u2-users@listserver.u2ug.**org<u2-users@listserver.u2ug.org>
>>> >
>>> Betreff: Re: [U2] DataVu Query [ad]
>>> Okay, so once you download DV Query there is a quick start guide that
>>> will tell you what you need to do.
>>>
>>> You need to run CONVERT.SQL on your files so that it has access to
>>> them, but you don't need to worry about creating the schemas with VSG
>>> or using HS.ADMIN like you would otherwise. Actually, there is a way
>>> to just use UPDATE.SQL.PRIVILEGES to get around this
>>> (https://u2tc.rocketsoftware.**com/documentation/1410030.asp<https://u2tc.rocketsoftware.com/documentation/1410030.asp>
>>> )**, although we
>>>
>> ecommend you do the CONVERT.SQL way.
>>
>>> If you are running older versions of U2 you may need to update
>>> XTOOLSUB, which is also a Tech note on TechConnect.
>>>
>>> -----Original Message-----
>>> From: 
>>> u2-users-bounces@listserver.**u2ug.org<u2-users-boun...@listserver.u2ug.org>
>>> [mailto:u2-users-bounces@**listserver.u2ug.org<u2-users-boun...@listserver.u2ug.org>]
>>> On Behalf Of Steve
>>> Romanow
>>> Sent: Friday, September 02, 2011 11:14 AM
>>> To: U2 Users List
>>> Subject: Re: [U2] DataVu Query [ad]
>>>
>>> On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett<wphask...@advantos.net**>
>>> wrote:
>>>
>>>> Steve:
>>>>
>>>> Really?  I was looking at DataVu for UniData and I understood that I
>>>> did need to SQL'ize all my data.  So, if I hosted a number of
>>>> accounts I'd have to go through the entire process of figuring how
>>>> to duplicate the accounts for SQL file access, keep them all
>>>> straight, and fight with all that this entails.
>>>>
>>>> Are you sure I misunderstood this?
>>>>
>>>> Thanks,
>>>>
>>>> Bill Haskett
>>>>
>>>> ------------------------------**------------------------------**
>>>> --------
>>>> --
>>>> --
>>>> ----- Original Message -----
>>>> *From:* slestak...@gmail.com
>>>> *To:* U2 Users 
>>>> List<u2-users@listserver.u2ug.**org<u2-users@listserver.u2ug.org>
>>>> >
>>>> *Date:* 9/2/2011 9:47 AM
>>>> *Subject:* Re: [U2] DataVu Query [ad]
>>>>
>>>>> On Fri, Sep 2, 2011 at 12:45 PM, John
>>>>> Thompson<jthompson333@gmail.**com <jthompson...@gmail.com>>
>>>>>   wrote:
>>>>>
>>>>>> For example:
>>>>>>
>>>>>> If my goal was to teach a fairly savvy computer user to get data
>>>>>> out of
>>>>>> U2
>>>>>> into, lets say Excel... without the user coming to ask me to write
>>>>>> some query for them...
>>>>>>
>>>>>> What would be the pros/cons of doing the ODBC way, vs. doing it
>>>>>> the DataVu way?
>>>>>>
>>>>>> Forgive my ignorance... Does that make sense?
>>>>>>
>>>>>> On Fri, Sep 2, 2011 at 12:41 PM, Daniel
>>>>>> McGrath<DMcGrath@**rocketsoftware.com <dmcgr...@rocketsoftware.com>
>>>>>>
>>>>>>> wrote:
>>>>>>> I'm not entirely sure on what you want here?
>>>>>>>
>>>>>>> DataVu (the free Query and paid Report&     Dashboard products) are
>>>>>>> querying, reporting and dashboard tools whereas ODBC is just an
>>>>>>> interface.
>>>>>>>
>>>>>>>
>>>>>>> -----Original Message-----
>>>>>>> From: 
>>>>>>> u2-users-bounces@listserver.**u2ug.org<u2-users-boun...@listserver.u2ug.org>[mailto:
>>>>>>> u2-users-bounces@listserver.**u2ug.org<u2-users-boun...@listserver.u2ug.org>]
>>>>>>> On Behalf Of John Thompson
>>>>>>> Sent: Friday, September 02, 2011 10:36 AM
>>>>>>> To: U2 Users List
>>>>>>> Subject: Re: [U2] DataVu Query [ad]
>>>>>>>
>>>>>>> Is there a comparison chart of DataVu vs. ODBC?
>>>>>>>
>>>>>>> I am planning on investigating both for reporting purposes, but,
>>>>>>> I was just curious if there was anything out there that listed
>>>>>>> the pros and cons of both in a nice little table.
>>>>>>>
>>>>>>>
>>>>>>> On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath<
>>>>>>> dmcgr...@rocketsoftware.com
>>>>>>>
>>>>>>>> wrote:
>>>>>>>> Free as in free beer on the house.
>>>>>>>>
>>>>>>>> Just install and run. There is no need to authorize.
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>> Dan
>>>>>>>>
>>>>>>>> -----Original Message-----
>>>>>>>> From: 
>>>>>>>> u2-users-bounces@listserver.**u2ug.org<u2-users-boun...@listserver.u2ug.org>[mailto:
>>>>>>>> u2-users-bounces@listserver.**u2ug.org<u2-users-boun...@listserver.u2ug.org>]
>>>>>>>> On Behalf Of John Thompson
>>>>>>>> Sent: Friday, September 02, 2011 10:20 AM
>>>>>>>> To: U2 Users List
>>>>>>>> Subject: Re: [U2] DataVu Query [ad]
>>>>>>>>
>>>>>>>> Is this a licensed product?  Or does it come with the U2
>>>>>>>> licenses we have purchased?
>>>>>>>>
>>>>>>>> On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath<
>>>>>>>> dmcgr...@rocketsoftware.com
>>>>>>>>
>>>>>>>>> wrote:
>>>>>>>>> Since DataVu Query recently came up here, I thought I should
>>>>>>>>> let you all know we have just released a new version of the
>>>>>>>>> free DataVu Query tool
>>>>>>>>> (v2.0.1)
>>>>>>>>>
>>>>>>>>> We have introduced new capabilities to combine your queries and
>>>>>>>>>
>>>>>>>> results.
>>>>>>>
>>>>>>>>   You can filter and quickly create charts with just a couple of
>>>>>>>>> clicks.
>>>>>>>>> Also, a new quick start wizard guides you through the steps to
>>>>>>>>> connect to your U2 data so you can quickly get up and running
>>>>>>>>> with
>>>>>>>>> U2 DataVu Query. You can download this from our downloads page.
>>>>>>>>>
>>>>>>>>> Don't forget we have videos available on U2DevZone on the
>>>>>>>>>
>>>>>>>> 'Accelerate'
>>>
>>>> page.
>>>>>>>>>
>>>>>>>>> Regards,
>>>>>>>>>
>>>>>>>>> Dan McGrath
>>>>>>>>> U2 Product Manager
>>>>>>>>> Rocket Software
>>>>>>>>> Web: www.rocketsoftware.com/u2
>>>>>>>>>
>>>>>>>>> ______________________________**_________________
>>>>>>>>> U2-Users mailing list
>>>>>>>>> U2-Users@listserver.u2ug.org
>>>>>>>>> http://listserver.u2ug.org/**mailman/listinfo/u2-users<http://listserver.u2ug.org/mailman/listinfo/u2-users>
>>>>>>>>>
>>>>>>>>>  --
>>>>>>>> John Thompson
>>>>>>>> ______________________________**_________________
>>>>>>>> U2-Users mailing list
>>>>>>>> U2-Users@listserver.u2ug.org
>>>>>>>> http://listserver.u2ug.org/**mailman/listinfo/u2-users<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<http://listserver.u2ug.org/mailman/listinfo/u2-users>
>>>>>>>>
>>>>>>>>  --
>>>>>>> John Thompson
>>>>>>> ______________________________**_________________
>>>>>>> U2-Users mailing list
>>>>>>> U2-Users@listserver.u2ug.org
>>>>>>> http://listserver.u2ug.org/**mailman/listinfo/u2-users<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<http://listserver.u2ug.org/mailman/listinfo/u2-users>
>>>>>>>
>>>>>>>  --
>>>>>> John Thompson
>>>>>> ______________________________**_________________
>>>>>> U2-Users mailing list
>>>>>> U2-Users@listserver.u2ug.org
>>>>>> http://listserver.u2ug.org/**mailman/listinfo/u2-users<http://listserver.u2ug.org/mailman/listinfo/u2-users>
>>>>>>
>>>>>>  The odbc way requires you to use VSG to normalize your U2 data.
>>>>> DataVue does not.
>>>>> ______________________________**_________________
>>>>> U2-Users mailing list
>>>>> U2-Users@listserver.u2ug.org
>>>>> http://listserver.u2ug.org/**mailman/listinfo/u2-users<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<http://listserver.u2ug.org/mailman/listinfo/u2-users>
>>>>
>>>>  On this page
>>>
>>> http://www.rocketsoftware.com/**u2/u2/products/datavu/offer<http://www.rocketsoftware.com/u2/u2/products/datavu/offer>
>>>
>>> it states
>>>
>>> "No VSG Schemas for UniData or HS.ADMIN setup for UniVerse are
>>> required to access your U2 data. Click here to download this free tool
>>> together with its example database to get started using U2 DataVu Query."
>>> ______________________________**_________________
>>> U2-Users mailing list
>>> U2-Users@listserver.u2ug.org
>>> http://listserver.u2ug.org/**mailman/listinfo/u2-users<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<http://listserver.u2ug.org/mailman/listinfo/u2-users>
>>>
>> ______________________________**________________
>> 2-Users mailing list
>> 2-us...@listserver.u2ug.org
>> ttp://listserver.u2ug.org/**mailman/listinfo/u2-users<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<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<http://listserver.u2ug.org/mailman/listinfo/u2-users>
>



-- 
John Thompson
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to