Re: [U2] PC based UniBasic program editor for 64 bit OS

2011-09-02 Thread Brian Leach
Hi Will You do need to install UniObjects - I don't include it as early on there were some version incompatibilities so it was important to have a version that matched the database. Nowadays you can just use the version that comes with the free client package that accompanies the personal

Re: [U2] PC based UniBasic program editor for 64 bit OS

2011-09-02 Thread Mecki Foerthmann
Doug, Your scenario may work for the classical programmer who just types in code that somebody else has written on paper all day, but who actually does this these days? Certainly not me! And it is not the number of lines of code you can type in a certain amount of time, it is the quality of

Re: [U2] Red Hat Enterprise Linux 64 bit and Universe 11.1.4 - Experiences?

2011-09-02 Thread John Thompson
I believe with EXT4, JFS, or XFS filesystems you can expand them only - while it is mounted. However if you are running RHEL 5 with EXT3, then you have to unmount the partition before you expand. JFS is of course what AIX uses. You can use JFS in Linux, if you set your filesystems up that way

Re: [U2] PC based UniBasic program editor for 64 bit OS

2011-09-02 Thread Bill Brutzman
Doug: Keep up the good work on the XLr8 Editor. The XLr8 Editor is an outstanding product at an amazingly low price. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] DataVu Query [ad]

2011-09-02 Thread Daniel McGrath
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

Re: [U2] DataVu Query [ad]

2011-09-02 Thread John Thompson
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

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Daniel McGrath
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-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:20 AM To: U2

Re: [U2] Red Hat Enterprise Linux 64 bit and Universe 11.1.4 - Experiences?

2011-09-02 Thread Michael Pflugfelder
With RedHat 5, LVM EXT3 filesystems, you can do online resizing. First, you need to increase the size of the logical volume with lvextend. Then you need to resize the filesystem with resize2fs. I did it a few weeks ago on a virtual machine without users noticing any difference.

Re: [U2] DataVu Query [ad]

2011-09-02 Thread John Thompson
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

Re: [U2] Red Hat Enterprise Linux 64 bit and Universe 11.1.4 - Experiences?

2011-09-02 Thread John Thompson
Well there ya go. I stand corrected. I was probably getting confused with shrinking vs. extending. I think to shrink you have to unmount. My mistake. On Fri, Sep 2, 2011 at 12:33 PM, Michael Pflugfelder mpflugfel...@ratex.com wrote: With RedHat 5, LVM EXT3 filesystems, you can do online

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Steve Romanow
On Fri, Sep 2, 2011 at 12:36 PM, John Thompson jthompson...@gmail.com wrote: 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

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Daniel McGrath
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

Re: [U2] PC based UniBasic program editor for 64 bit OS

2011-09-02 Thread Wjhonson
Slight amplification. You need to install UniObjects LOCALLY. We have uniobjects installed, but it runs on the same network server as Universe. Since I don't type my keystrokes on the network server (but on my own PC connecting through an Accuterm telnet window) it can't see that UniObjects is

Re: [U2] Red Hat Enterprise Linux 64 bit and Universe 11.1.4 - Experiences?

2011-09-02 Thread John Thompson
Thanks for pointing that out. I've dealt with too many filesystems over the years, and they are all starting to blur together :( On Fri, Sep 2, 2011 at 12:37 PM, John Thompson jthompson...@gmail.comwrote: Well there ya go. I stand corrected. I was probably getting confused with shrinking

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Daniel McGrath
Thanks Steve. Yes, DV Report (as well as Dashboard) is a separate product that is licensed. -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 10:41 AM To: U2 Users List

Re: [U2] DataVu Query [ad]

2011-09-02 Thread John Thompson
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

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Daniel McGrath
Can you let me know which page so I can address it? I just successfully started downloading, so I'm not sure where to look. Thanks, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday,

Re: [U2] DataVu Query [ad]

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

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Steve Romanow
On Fri, Sep 2, 2011 at 12:46 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote: Can you let me know which page so I can address it? I just successfully started downloading, so I'm not sure where to look. Thanks, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Wjhonson
John don't you use Accuterm? -Original Message- From: John Thompson jthompson...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Sep 2, 2011 9:46 am Subject: Re: [U2] DataVu Query [ad] For example: If my goal was to teach a fairly savvy computer user to get data

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Wjhonson
Give us the direct link to the download page -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Sep 2, 2011 9:46 am Subject: Re: [U2] DataVu Query [ad] Can you let me know which page so I can address it? I

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Wjhonson
We’re sorry, but that page doesn’t exist… Ha! So Rocket is looking to hire a website developer? -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Sep 2, 2011 9:31 am Subject: Re: [U2] DataVu Query [ad]

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Steve Romanow
On Fri, Sep 2, 2011 at 12:48 PM, Wjhonson wjhon...@aol.com wrote: Give us the direct link to the download page -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Sep 2, 2011 9:46 am Subject: Re: [U2]

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Daniel McGrath
If you click on DataVu Query here ( http://www.rocketsoftware.com/u2/resources/downloads ) it should take you where you need to go. And thanks Steve, I'll get that address straight away. -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] DataVu Query [ad]

2011-09-02 Thread John Thompson
Yes... but, Accuterm FTWIZ can be quite slow when pulling a lot of data. Although, I have not had much time to mess with the New Version of Accuterm 7, so it may have improved. Also the last time I checked, its difficult for FTWIZ to get data from multiple files, unless you want to spend your

Re: [U2] PC based UniBasic program editor for 64 bit OS

2011-09-02 Thread Glenn Sallis
Will, In my original email, I already stated: It sounds to me like you are missing the UODOTNET library, which needs to be on *your local machine* in order to expedite the connection to the server. Here, your local machine = the machine you have installed mvDeveloper on, to which the

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Wjhonson
I loaded to the Pickwiki, code which will output the first 10 VOC entries as an HTML table and then launch it with Accuterm into whatever browser you have. I don't know anything about FTWIZ, looks like a file transfer tool, doesn't seem closely related to me. You can use the core concepts of

Re: [U2] PC based UniBasic program editor for 64 bit OS

2011-09-02 Thread Wjhonson
Well then could MVDeveloper be installed on the same server as Universe and just launched via a shortcut link. -Original Message- From: Glenn Sallis u...@glennsallis.de To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Sep 2, 2011 9:59 am Subject: Re: [U2] PC based

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Bill Haskett
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

Re: [U2] PC based UniBasic program editor for 64 bit OS

2011-09-02 Thread Doug Averch
Hi Mecki: Obviously, I'm passionate about tools. Before 2004, the only thing I could use was a line by line editor or full screen editors for Unix or full screen editors for Windows. Neither of those are viable options after spending years in Microsoft tools with code completion, syntax

Re: [U2] PC based UniBasic program editor for 64 bit OS

2011-09-02 Thread Glenn Sallis
Not if the server is running Linux or Unix. As for a Windows server, I really don't know and I cannot imagine it is worth the effort finding out. The UniObjects libraries are an indispensible set of libraries, in fact, absolutely necessary, to have on your machine if you are doing anything

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Daniel McGrath
I think you will find savvy computer users will find this fairly easy to use. Your best bet would be to check out 'Building Queries' video on U2 Dev Zone https://u2devzone.rocketsoftware.com/accelerate/resources/videos/u2datavu/u2-datavu-part-4-query-building/view Regards, Dan -Original

Re: [U2] DataVu Query [ad]

2011-09-02 Thread John Thompson
Ok thanks. I'll check it out. On Fri, Sep 2, 2011 at 12:59 PM, Wjhonson wjhon...@aol.com wrote: I loaded to the Pickwiki, code which will output the first 10 VOC entries as an HTML table and then launch it with Accuterm into whatever browser you have. I don't know anything about FTWIZ,

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Steve Romanow
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

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Wjhonson
This requires a repository? It doesn't query directly into the Universe database itself? -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Sep 2, 2011 10:09 am Subject: Re: [U2] DataVu Query [ad] I

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Daniel McGrath
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.

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Wols Lists
On 02/09/11 17:47, Steve Romanow wrote: The odbc way requires you to use VSG to normalize your U2 data. DataVue does not. I'm sure someone will correct me if I'm wrong, but ... Aiui, ODBC (on UV at least) is no longer a native data access technology, but it sits on top of OleDB. So if you can

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Daniel McGrath
Think of repository as a 'project' It stores the metadata about your how you built your queries locally, but it runs the actually queries and retrieves the data from your U2 database itself. -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Red Hat Enterprise Linux 64 bit and Universe 11.1.4 - Experiences?

2011-09-02 Thread Dan Fitzgerald
Well, I'm gonna start asking my linux questions HERE. Every linux geek I asked said it couldn't be done... Date: Fri, 2 Sep 2011 12:37:28 -0400 From: jthompson...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] Red Hat Enterprise Linux 64 bit and Universe 11.1.4 -

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Bill Haskett
Steve: Sorry, but I don't think that's right. I remember getting excited and downloading the product. Then when I was reviewing the installation instructions I seemed to run into a myriad of issues I'd have to overcome in development, let alone in production. For instance, according to

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Wjhonson
Wow. That's a dog who is not going to run. Setting Up a UniData Account n order to access your files in U2 Data Vu, you need to properly set up our UniData account. To do this you must add your account to the D.ACCOUNT file, use the CONVERT.SQL command to make your files SQL ompliant,

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Steve Romanow
Bill, I think you are correct. I was hoping and praying for straight UoJ connection to data, not shoehorned SQL. Steve ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] DataVu Query [ad]

2011-09-02 Thread David Wolverton
I think this was another Rocket acquisition that was 're-engineered' so it could talk to U2. Hence the reason it's using SQL. I could be wrong... but I don't think I am! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf

Re: [U2] List Voc Like ....

2011-09-02 Thread Wjhonson
LIST VOC LIKE ...'DOG' fails, listing everything LIST VOC LIKE '...DOG' passes, listing just those items ending in DOG The online HELP documentation gives no examples of using the quotes, they just state it without an example. Or rather the example is just the 'string' by itself without it's

Re: [U2] List Voc Like ....

2011-09-02 Thread Jeff Schasny
LIST VOC WITH @ID LIKE ...DOG... no quotes, especially not single quotes which woulf indicate an explicit record ID Wjhonson wrote: LIST VOC LIKE ...'DOG' fails, listing everything LIST VOC LIKE '...DOG' passes, listing just those items ending in DOG The online HELP documentation gives no

Re: [U2] List Voc Like ....

2011-09-02 Thread Wjhonson
I want ends with so you don't use the trailing ellipses just ...DOG The LIKE can take single or double quotes without care (that's in the documentation) You missed the point of my message which was that putting the ellipses outside the quotes makes the statement fail. That's why it fails, not

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Daniel McGrath
Just to clarify, this is only an issue for UniData (because by default it denies SQL access, until you update the privileges). In UniVerse it is as simple as pointing it to your host, typing in your credentials and selecting the account. In fact, I just did it on my machine with the SBDEMO

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Wjhonson
After 45 minutes of trying different things I finally got to step 1. -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Sep 2, 2011 1:25 pm Subject: Re: [U2] DataVu Query [ad] Just to clarify, this is

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Daniel McGrath
If you can think of any instructions that made it hard to work, instructions that are missing or anything else that will make it easier for first time users (eg, Gotcha's that might affect some people we have missed), let us know. The best way for us to make it better is if people give us some

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Steve Romanow
On Fri, Sep 2, 2011 at 4:41 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote: If you can think of any instructions that made it hard to work, instructions that are missing or anything else that will make it easier for first time users (eg, Gotcha's that might affect some people we have

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Wjhonson
Uh yeah. Ok here's one. Instead of error BD10456342!!.blah gobbly gook maybe something a human can understand :) Having, as I have, a brilliant mind, it only took me five minutes or so to figure out that possibly, it can't figure out what files are in my account because it's seeing a menu

Re: [U2] DataVu Query [ad]

2011-09-02 Thread Steve Romanow
This is what I get. I cannot access ApplicationData on my machine, which bothers me. meh. win7. http://screencast.com/t/c3QI4gs6 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users