RE: [UD] Union Query
I will be the first to admit that I know next to nothing about SQL in the UV/UD world. Can you use the output of the SQL SELECT in UV/UD? Thanks. Steve At 05:14 PM 5/1/04 +1000, you wrote: Gordon J. Glorfield wrote: > In that case, I'm sorry to say, there is no way to logically > do what you're asking with UD. Gordon, you should now better! ;^) sql> SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE UNION SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE_OTHER; All you need here Ed is a VOC pointer to each file that is SQL compatible - ie no "." dots etc. There is no need to build a schema or set up ODBC or do anything complicated in UniData just to query a file with SQL from the command line. Cheers, Ken >> -Original Message- >> From: Burwell, Edward [mailto:[EMAIL PROTECTED] >> LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP >> >> or >> >> LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP >> >> How would a virtual dictionary know which file to get the >> NAME ADDRESS CITY and STATE from? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How far can U2 scale?
Dear Dawn et al. From reading other posts on this matter about UV/UD scaling, I expect that as far as the PRDBMS and hardware, the sky is the limit. And with Claus Derlien's comment about 3 users at France Telecom, the sky is pretty high up there. But I wonder about the applications. I know that the LIS that I was supporting until recently used a single place to get a transaction number. Now when you have 100 users, locking/reading/writing that single record was not a big deal. But if you had 1000 users? I think that you would start having problems. So I suspect that the scaling problems are not at the UV/UD and hardware layers but within the applications. Control Record locking. The transaction Number generation that I referred to earlier. Things like that. I believe that as the user counts got bigger, the application would have to be checked on to see where it would need to be modified to match the greater number of users than was imagined when the application was written. Steve At 08:50 AM 4/23/04 -0500, you wrote: At what point in the life of application software would it be so large that you could not (or would not want to) support it with your existing UniData or UniVerse database? Is there a point where you would be better served by DB2 or Oracle, for example due to the scale you are working with? I hear people talk about moving way from U2 in order to do ODBC and use standard industry tools (and most find that the grass is not greener for those purposes), but I don't hear about switching because of running into scaling issues. However, we sometimes think of PICK as addressing small-to-mid size businesses and RDBMS folks sometimes think of their products as scaling the best. So, what's the cut-off for U2? Thanks. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to display a heading with a SELECT statement?
1) Being unfamiliar with this, I checked the manuals regarding the use of FORCE in a LIST and I couldn't find that reference in the manuals. Could it be for UniData rather than UV? 2) Let the "FORCE" be with you. . . Hey, it's just too good a pun to resist. Steve At 02:38 PM 4/14/04 +1000, you wrote: Add "FORCE" to your LIST. It's a very annoying UV feature ;-) Regards, David > LeRoi Keiller wrote: > If there are no records to display, it says so, but no heading is produced. > The report should at least say BLAH BLAH REPORT, at the start, and end with > END OF REPORT. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: PDF Manual [Data typing in MV Basic]
Mark that you've been doing this too long, you can remember the _loose-leaf_ 'Pick Pocket Guide'. Still have one of the thick spiral bound ones with the 'Search for Truth' question in the front. -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The lists are closing
I would argue that the lists should continue. With some employers offering e-mail, but not web-access to their employees, those employees would be able to contribute to an e-mail list, but not a forum. Steve Wagner At 11:02 AM 3/29/04 -0500, you wrote: The archives for the lists (which go back to the mid-90's) would remain for now at http://www.indexinfocus.com. But I don't yet see a way to go forward on our site archiving the IBM web content so they'd be static. We do plan "real soon now" to add other content. Is there a general opinion that the email lists should continue? How can we avoid then having two separate, disconnected places for information -- the list and the U2UG forums? At this point in the lifecycle of the U2 products, the user group is very, very important. We need to make sure there are lots of squeaking wheels in the discussion threads. I ask this because we are looking at the technical issues of rehosting the lists here. But I agree with Clif in his reasons for shutting them down. Lee -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [OT] Access Denied Continued
Dear Ray et al. Could the network login time out? So that the person may still be logged into UV, but have lost their login to the NT domain? Steve At 11:47 AM 3/25/04 -0500, you wrote: Earlier this week I posted a message about getting an access denied message when printing to a shared printer in a Universe application. This is more of a networking issue, but I thought I'd pick y'all's brains. I'm running UV10 on an NT4 server. The printer is a Zebra bar code printer connected via LPT1 on a WindowsXP Pro machine. The printer/machine in question is networked to the corporate domain via 3Com wireless bridge. We are running Domain level authentication. When a user first logs in to the machine with the printer attached and runs the UV application the print job works beautifully. Following a period of inactivity, the app starts returning the access denied message. It's almost as if the machine loses it authentication on the domain or the UV server loses the connection to the user machine. There's no hibernation or sleep settings set on the client or the server. I can also connect to the share machine and printer via the network but still get the access denied message. Anyone have any clues as to why access is being stripped after inactivity? TIA, Ray -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Abject Grovelling (Was Re: Ad - Programmer/Analyst)
To our Moderator and all others on this mailing list I most humbly grovel at everybody's feet due to my just sending out of a reply to the job ad to everybody on the list. I apologize for my failure to remember how to use my e-mail client and showing myself to be a DORK! -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Access denied on print
Ray Make sure that the user trying to use the printer are correctly logged into your network. If they are not correctly logged in, they can still telnet to the UV server, but will not have access to any printers or other network attached devices. That's been my experience with UV9.6.2.8 on WinNT4.0. Steve At 01:24 PM 3/22/04 -0500, you wrote: I am getting intermittent errors when a program selects a printer then tries to print to it. This is in UVNT v.10. There doesn't seem to be any rhyme or reason. It works sometimes, and then does not. The Access Denied error pops up in Universe as follows: Access is denied. Program "WILLS.ZEBRA.LABELS": Line 286, StartDocPrinter failed with error 5 The program is printing to a Zebra bar code printer which has the following VOC entry to assign it. 0001: PQ 0002: HSETPTR 0,132,60,0,0,1,AT \\WILLS\ZebraRec,NOEJECT,BRIEF,NOFMT Does anyone have any ideas on what might be causing this? TIA -Ray -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [OT] Symbol PDT6800 Help
Sorta makes me think of the booting instructions on a MicroData Reality. Steve At 02:53 PM 3/18/04 -0500, you wrote: Not sure exactly, but I've got some cryptic notes here: I think it's ++ This will take you through some questions like "Software Update", etc. You'll have to answer these as you think appropriate for your needs. If that doesn't work, I know that will bring you to a dos prompt (depending on where you are when you do it). I don't know if it works from all areas of the unit's programming. You can also force a reboot by holding down <4>+<5> press wait 3 secs press again, then release <4>+<5>. I don't have a manual in front of me, so I can't double check at this point, but I think that the manuals are available on Symbol's website. Hope this helps. - Dave -Original Message- Does anyone know how to get back to the main configuration menu on a Symbol PDT6800? I'm stuck at: 'Terminal cannot associate with AP. You're out of range or not configured.' -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse on NT vs *nix - Higher User Counts with W2003?
Stephen M. O'Neal, CDP said that "...currently, most W2000 installations max out at about 300 users." I wonder how often sites that plan for higher user counts go with a *nix solution to start with? For what it is worth, I had 200 UV9.6.2.8 users on a WinNT 4.0 box. And this was with a Compaq Proliant 5500 with 512MB of RAM and two 200Mhz CPUs, Xeons I believe. And no complaints about speed. -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniVerse and Backup Exec
Dear Gwen Buck et al I am running UV 9.6.2.8 on a WinNT 4.0 SP 6.0a box using Veritas Backup Exec. I do not know which release of Veritas that I am using. I haven't had any problems. I'd press your VAR for more detail. One possible solution would be to run a uvbackup and allow Veritas to backup the output from uvbackup. Good luck. Steve At 09:18 AM 2/17/04 -0500, you wrote: I am running: UniVerse 10.0.17 Windows 2000 SP 4 Veritas Backup Exec: Media Server & Admin. Console: Ver 9.00 Rev 4454 Thanks in advance for any help you can offer! Gwen Buck Gaska Tape Inc. [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
