Re: [U2] DataVu Query [ad]

[David Jordan]

Hi Steve
There have been 2 betas and I have been on both and requests were made through 
the Rocket newsletter.   The issues are probably a combination of people 
implementing on a broader spectrum of environments than was tested and also an 
issue of not being as intuitive to install.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: Thursday, 8 September 2011 11:27 AM
To: U2 Users List
Subject: Re: [U2] DataVu Query [ad]

That is cool. Wish we could have done a beta and help shake some of these out.

Thank you Rocket for continuing to push the platform.
___
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] DataVu Query [ad]

[Steve Romanow]

That is cool. Wish we could have done a beta and help shake some of these
out.

Thank you Rocket for continuing to push the platform.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] DataVu Query [ad]

[David Jordan]

I spoke to Jackie Burhans at Rocket about the issues raised in this list on 
behalf of the user group and she is putting a team onto looking at how to 
improve the documentation and installation process for DataVu.   This is a 
product U2 users want to persevere with as it will make U2 stronger in the 
market and reduce the potential for competitor products pushing U2 out of a 
site.  It needs some issues ironing out, but the potential is great.

Regards

David Jordan
VP U2UG

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

Re: [U2] Catalog In Place

[Wjhonson]

The help on VCATALOG only seems to imply that it returns "verifies" or "does 
not verify".
How does that tell me if it was catalogued at all, cataloged locally, normally, 
or globally ?






-Original Message-
From: Glenn Sallis 
To: U2 Users List 
Sent: Wed, Sep 7, 2011 4:02 pm
Subject: Re: [U2] Catalog In Place


Hi Will,
Everything is possible!
Your friend in this case is the VCATALOG (verify catalog) command.
If you want to do it all in one routine, execute the VCATALOG command 
rom your program, capture and do a check on the output which should 
ndicate how the program was cataloged.Then you could do a CASE 
tatement to choose how you want to catalog it this time depending on 
our specific criteria.
Be careful though, I don't know how complex your application is, so you 
ay be playing with fire. You don't want to get into a situation where 
ifferent accounts are using different versions of object code and your 
rograms get out of sync.
My advice, make sure you catalog correctly the first time!
Grüße
lenn

Am 08.09.2011 00:24, schrieb Wjhonson:
 Task: Write a BASIC helper program that will, figure out whether or not this 
outine was previously catalogued locally, normally or globally and then, 
utomatically, after executing a BASIC on it, execute the appropriate CATALOG on 
t as well.

 Possible?

 Useful?
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 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

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

Re: [U2] Catalog In Place

[Glenn Sallis]

Hi Will,

Everything is possible!

Your friend in this case is the VCATALOG (verify catalog) command.

If you want to do it all in one routine, execute the VCATALOG command 
from your program, capture and do a check on the output which should 
indicate how the program was cataloged.Then you could do a CASE 
statement to choose how you want to catalog it this time depending on 
your specific criteria.


Be careful though, I don't know how complex your application is, so you 
may be playing with fire. You don't want to get into a situation where 
different accounts are using different versions of object code and your 
programs get out of sync.


My advice, make sure you catalog correctly the first time!

Grüße
Glenn



Am 08.09.2011 00:24, schrieb Wjhonson:

Task: Write a BASIC helper program that will, figure out whether or not this 
routine was previously catalogued locally, normally or globally and then, 
automatically, after executing a BASIC on it, execute the appropriate CATALOG 
on it as well.

Possible?

Useful?
___
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] Catalog In Place

[Wjhonson]

Task: Write a BASIC helper program that will, figure out whether or not this 
routine was previously catalogued locally, normally or globally and then, 
automatically, after executing a BASIC on it, execute the appropriate CATALOG 
on it as well.

Possible?

Useful?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] DataVu Query

[Bill Haskett]

:-)

Bill Haskett


- Original Message -
*From:* jscha...@gmail.com
*To:* U2 Users List 
*Date:* 9/7/2011 7:38 AM
*Subject:* Re: [U2] DataVu Query
I've managed to get this installed, define a "repository", 
successfully connect to it, and construct a simple query. When I run 
it I get a pop up that says:


Applications Error
BIC4. 5

Any thoughts?

So far, I would not give this to an end user under any circumstances. 
Running an ODBC query from Excel/MS Query is vastly simpler. I have 
not completely given up hope yet since I'm early in the process of 
learning the product and getting used to the interface. Perhaps I'll 
pause my normal process of "click on stuff and see what it does" and 
read the 351 page "Getting Started" PDF.




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

Re: [U2] DataVu Query

[Jeff Schasny]

I've managed to get this installed, define a "repository", successfully 
connect to it, and construct a simple query. When I run it I get a pop 
up that says:


Applications Error
BIC4. 5

Any thoughts?

So far, I would not give this to an end user under any circumstances. 
Running an ODBC query from Excel/MS Query is vastly simpler. I have not 
completely given up hope yet since I'm early in the process of learning 
the product and getting used to the interface. Perhaps I'll pause my 
normal process of "click on stuff and see what it does" and read the 351 
page "Getting Started" PDF.


--

Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com

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

Re: [U2] DataVu Query [ad]

[Jeff Schasny]

I've just been setting up DataVu Query as well and the first thing I've 
noticed is that the documentation installed by the setup process does 
not match the version of the software installed. Screens are completely 
different.


Daniel McGrath wrote:

CONVERT.SQL is only for UniData.

DataVu uses UOJ and JDBC. When you actually *run* the queries it does it via 
SQL. Remember that DataVu can use more than one data source, including SQL 
databases. This keeps everything uniform and always you to use those data 
sources together in a more seamless manner.

Regards,
Dan

Sent from my Verizon Wireless 4GLTE smartphone

  


--

Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com

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

Re: [U2] DataVu Query [ad]

[Daniel McGrath]

CONVERT.SQL is only for UniData.

DataVu uses UOJ and JDBC. When you actually *run* the queries it does it via 
SQL. Remember that DataVu can use more than one data source, including SQL 
databases. This keeps everything uniform and always you to use those data 
sources together in a more seamless manner.

Regards,
Dan

Sent from my Verizon Wireless 4GLTE smartphone

- Reply message -
From: "Steve Romanow" 
To: "U2 Users List" 
Subject: [U2] DataVu Query [ad]
Date: Wed, Sep 7, 2011 7:07 am



I am really confused.  If it uses UniObjects, there should be very
little need for the ODBC driver and CONVERT.SQL.

Can we get a clarification on this?
___
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] DataVu Query [ad]

[Steve Romanow]

I am really confused.  If it uses UniObjects, there should be very
little need for the ODBC driver and CONVERT.SQL.

Can we get a clarification on this?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] DataVu Query [ad]

[John Thompson]

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  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
>> To: u2-users
>> >
>> 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[mailto:
>> u2-users-bounces@**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 +
>>> Von: Daniel 
>>> McGrath
>>> >
>>> An: U2 Users 
>>> List
>>> >
>>> 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
>>> )**, 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
>>> [mailto:u2-users-bounces@**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
>>> 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

Re: [U2] DataVu Query [ad]

[Mecki Foerthmann]

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
To: u2-users
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-boun...@listserver.u2ug.org 
[mailto: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 +
Von: Daniel McGrath
An: U2 Users List
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), 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-boun...@listserver.u2ug.org
[mailto: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
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
*Date:* 9/2/2011 9:47 AM
*Subject:* Re: [U2] DataVu Query [ad]

On Fri, Sep 2, 2011 at 12:45 PM, John
Thompson
   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
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-boun...@listserver.u2ug.org [mailto:
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. ODB

Re: [U2] DataVu Query [ad]

[Mecki Foerthmann]

It doesn't give me a choice which connector to use.
As I said, I can connect to UD 5.2 and UD 7.2 on two different servers 
with any other client software on my PC (SBClient, UniAdmin, 
mvDeveloper, VSG) by just entering the server name.



On 07/09/2011 02:45, David Jordan wrote:

Hi Mecki

You should not need a jdbc driver, this is why I suspect you maybe using the 
data connector for RDBMs databases instead of U2 data connector which uses 
uniobjects.

David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Wednesday, 7 September 2011 9:02 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] DataVu Query [ad]

David,

I bet you are right, but what users want is to be able to install software like 
that without having to search the documentation for hours.
I don't mind if I have to search for and download a JDBC driver from the net to 
connect to SQL Server, DB2 or Oracle data sources but I expect a Rocket product 
to work straight away for U2.
I get a screen that asks me for the UD server name and even though that name 
one works for SB client, VSG, UniAdmin and tools like mvDeveloper it won't 
connect in DataVu.
All I found so far is that I need this driver (hell knows where to get it from) 
and a file called bi.jdbc,drivers (or something like that) that needs to be 
created somewhere by the administrator.
Hell, I am the administrator and I haven't got a clue how to do that!


On 06/09/2011 23:22, David Jordan wrote:

Mecki
You do not need a JDBC driver, it uses uniobjects.   There is a video showing 
how to install and read the documentation.   The installation is not intuitive, 
but it is not hard.   I made the mistake first not to read the documentation 
which takes you through step by step.

Regards
David Jordan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On 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 
use this and buy the other modules.
In the documentation it says something about a JDBC driver that needs to be 
installed but isn't included in the package and some obscure file that needs to 
be created somewhere and contains connection data but to me this is just Greek 
and doesn't mean anything.
Other products like mvDeveloper just work without having to find a driver 
somewhere 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 +
Von: Daniel McGrath
An: U2 Users List
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), although we 
recommend 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-boun...@listserver.u2ug.org
[mailto: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
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
*Date:* 9/2/2011 9:47 AM
*Subject:* Re: [U2] DataVu Query [ad]

On Fri, Sep 2, 2011 at 12:45 PM, John
Thompson
   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
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-