RE: [UD] Union Query

2004-05-01 Thread Steven M Wagner
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 to display a heading with a SELECT statement?

2004-04-13 Thread Steven M Wagner
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. . . grin 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: The lists are closing

2004-03-29 Thread Steven M Wagner
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
snip prior message

--
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

2004-03-25 Thread Steven M Wagner
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)

2004-03-24 Thread Steven M Wagner
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

2004-03-22 Thread Steven M Wagner
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

2004-03-18 Thread Steven M Wagner
Sorta makes me think of the booting instructions on a MicroData Reality.grin

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 A+B+D PWR PWR
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 CTRL C 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 PWR wait 3 
secs press PWR 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?

2004-03-09 Thread Steven M Wagner
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.

snip prior messages

--
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

2004-02-17 Thread Steven M Wagner
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
snip much of message

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