raiserror()
eg
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_5ooi.asp
-Original Message-
From: [EMAIL PROTECTED]
does anyone have an example of raising errors through ODBC (or any other
way) to Universe.
Environment ..
uv10x using odbc
We have Universe 10.0.10 running on a Windows 2000 server with a 50 user
licence. We have about 40 users using telnet sessions and about 20 using
a VB6.0 program to enter data.
We are having problems where the session drops because users are not
logging out of the VB program, I have increased
If the users were running multiple VB sessions then it might worth
looking at device (enterprise) licensing but as Universe doesn't allow
the pool of ten connections per license to be shared amongst processes
(ie telnet programs) it probably won't work for you.
At the end of the day if you're
Nice one Mike, I'll try to remember to drop you a line on 24680 - the way UK
pensions are going I'll still be working !
Piers
Tomorrow Saturday 5th March 2005 is, in the U2 / Pick calendar Day Number
13579
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
I will be out of the office starting 03/04/2005 and will not return until
03/14/2005.
If this is an emergency, You may contact Tom Cordts
[EMAIL PROTECTED]
I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
UniObjects does not have licenses, the licenses are related to the access to
the UniVerse database. With a 50 user license only 50 concurrent users can
access the database at a time. If you have 40 telnet users and 20 VB6 user
then you need 60 concurrent licenses and the last 10 users to login
If the VB6 users are also Telnet users that utilize Dynamic Connect,
wIntegrate or AccuTerm with device licensing, then you should only need 40
UniData device licenses.
Regards, Ian Renfrew
- Original Message -
From: David Jordan [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Hola -
We've got a 9.5 system running on Irix that we're going to be upgrading
to 10.1.4 running on Linux on new hardware, and it strikes me that
replication might be a good way to minimize system downtime while we do
the upgrade.
Any idea whether there would be any additional hitches in doing
Upgrade via replication sounds like a receipe for lots of wailing and
knashing of teeth. Have a look at uvbackup and uvrestore. Or read
up on rsync as a means to get the data from one machine to another.
If it were me, I think I'd do a uvbackup to a network mounted
filesystem (samba or nfs) and
Unfortunately the Universe device licensing doesn't work like that. Not
sure about Unidata but the question related to Universe.
The 10 connection pool cannot be shared between the terminal emulator
and uniobjects.
I asked (via my VAR) if IBM had any plans to allow that and apparently
they
Replication was incredibly slow before version 10 and had a large impact
on file updates.
We have replication running between Windows and Linux versions in test
without problems. Due to limited downtime windows we are planning to
switch systems over two weekends with replication running in
That's the way we're currently testing it, uvbackup uvrestore, but it
adds some additional delays in that the IRIX system is configured
rather, um, funkily, and those bits need to be recreated after the
system is in place on the new box. Also, unfortunately, we've got a good
bit of data
Device Licensing does work and if you have the Enterprise Edition of UV
then it works very well.
We have a VB app as well as wIntegrate including Dynamic Connect and
Viaduct that quite happliy share the 10 connection pool.
This is in UV 10.1.4 and AIX 5
-Original Message-
From: [EMAIL
As I undersand, one connexion of uvObjects consumes one uniVerse licence,
then you couldn't buy licence for uvObjects only, and this is because since
uniVerse version 9 the uvObjects are bounded with the licence for the
same number of users than the UniVerse Licence.
Cheers
Jose Luis
In an account that I made with (IIRC) makeudt, whenver I attempt to type
the @ symbol, the cursor jumps to the beginning of the line.
So it's rather hard to SELECT FILE.NAME with @ID ...
Does anyone know what causes this and how to fix it? I know we've run
across it before, but apparently I
[EMAIL PROTECTED] wrote:
Rsync, that's an interesting idea I hadn't thought of, thanks very much
for your input, I'll definitely be trying that out shortly.
Just be careful! What hardware are your linux and irix systems running on? You
may need to use fnuxi.
Using fnuxi has nothing to do
Of course the way pensions/Social (In)Security are going in the US,
I might be working until 247365...
-Original Message-
From: Piers Angliss [mailto:[EMAIL PROTECTED]
Sent: Friday, March 04, 2005 7:49 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Happy Odd Day (Unclassified)
Ok. I definitely have the wrong job here. Not only do I not get paid for typing
spaces.. But I also do not get paid to watch/analyze/notice the internal date!
(j/k - don't flame me)
Thanks,
Marilyn A. Hilb
Value Part, Inc
Direct: 847-918-6099
Fax: 847-367-1892
[EMAIL PROTECTED]
In an account that I made with (IIRC) makeudt, whenver I attempt to
type the
@ symbol, the cursor jumps to the beginning of the line.
Did you check your PTERM (UV) or stty (UD) settings?
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
---
u2-users mailing list
Replication was incredibly slow before version 10 and had a large impact
on file updates.
That wouldn't be too bad for our case here when it's a one off, it'd
*have* to be faster than plugging the backups over the small pipe we've
got, but good to know.
We have replication running between
Maybe it's just the Windows version that doesn't work like that then.
IBM support themselves confirmed to me that the scenario you state
doesn't work and we can see it on out servers.
We have several running enterprise licenses that can handle 10
connections from wIntegrate but without access
Yes, going from Irix (MIPS?) to Linux on X86 will most likely require
fnuxi to be run on everything after the transfer. Since the fnuxi
process would run on the newer machine, it would probably still be
much faster to run an rsync, then find - fnuxi script.
Just be very carefull with rsync!
It sounds like your PTERM KILL is set to the @ char.
Do a PTERM KILL {ctrl X}, then see if you can do your select.
Something in the LOGIN or ./profile could be setting stty/PTERM settings on
you. If it's only one account then I'd suspect the LOGIN paragraph for that
account.
Hope this helps.
Hennessey, Mark F.
It sounds like your PTERM KILL is set to the @ char.
Do a PTERM KILL {ctrl X}, then see if you can do your select.
CTRL-X made a 'Host Information' dialog box appear saying 'Sending data
to printer...'. And locked the session, I had to close the [wIntegrate]
window.
execute PTERM KILL {some character you'll never use}. That should help you use
the @ sign.
Maybe first verify this is the issue with a PTERM DISPLAY and look to see what
KILL is set to...
-Original Message-
From: Wendy Smoak [mailto:[EMAIL PROTECTED]
Sent: Friday, March 04, 2005 12:40
Hennessey, Mark F.
execute PTERM KILL {some character you'll never use}. That
should help you use the @ sign.
Maybe first verify this is the issue with a PTERM DISPLAY and
look to see what KILL is set to...
Is this supposed to be done at the colon prompt? I just get syntax
errors. I'm
Try this and post the results please:
PTERM -DISPLAY
You might also try (to fix):
PTERM -KILL ^X
...or some other character other than X.
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wendy
That is a bug, IBM sold it on the basic that you can run 10 sessions on any
combination of ODBC, OLE-DB, Telnet, UniObjects.
I have it working on Windows.
What version of Wintegrate are you running, if it is to early it may not
handle device licensing.
Regards
David Jordan
-Original
We run Wintegrate 5.2 which fully supports device licensing.
What I wanted to do was to run 5 sessions with wintegrate and 5 sessions
with uniobjects and only take 1 license.
IBM said that this will not work and they have no intention of making it
work. The problem is that you need to know the
Hello All,
Question on COMMON. Is there a way to use COMMON so that any subroutine
can use the COMMON variables for that account. I'm thinking I could
write a program that will set some COMMON variables and run as a phantom
job. I would then have other processes call subroutines that would
Your terminal type in the telnet session is probably not the same as the
terminal type set up for the account. Type in term and see if it is the same
as your session terminal type.
- Original Message -
From: Wendy Smoak [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Friday,
A labeled/named common might work. As long as your phantom doesn't
stop, you might be able to.
BobW
-Original Message-
From: [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] On Behalf Of Nick Cipollina
Sent: Friday, March 04, 2005 1:51 PM
To: u2-users@listserver.u2ug.org
I do not believe this is possible. Named common is about as close as
you'll come, and that's session dependent. Can you write the
information to a file somewhere, load it up into named common, and
then be good for the rest of the phantom session?
-Original Message-
From: [EMAIL
But named common only persists for the life of that session. If you want
some variables set to be used by several sessions then your only recourse
is to have your phantom write the variables to some kind of constant file.
Your other subroutines/programs would then read the constant item from
That would mean passing common across sessions. Something that I wish
was possible but unfortunately is not as far as I know.
Any routines that your phantom calls can see the common. But if you
telnet in or start another phantom that can't see it.
-Original Message-
From: [EMAIL
Kevin King wrote:
You might also try (to fix):
PTERM -KILL ^X
Thank you! That's what Mark was trying to get me to do, but I wasn't
using a dash before KILL, (or DISPLAY) and I was trying to actually hold
down CTRL and press X.
I put that in the LOGIN paragraph, and now I can type @. But...
On Fri, 4 Mar 2005 16:51:02 -0500, you wrote:
Question on COMMON. Is there a way to use COMMON so that any subroutine
can use the COMMON variables for that account. I'm thinking I could
write a program that will set some COMMON variables and run as a phantom
job. I would then have other
You might try pressing Ctrl-X instead of typing ^X.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak
Sent: Friday, March 04, 2005 4:00 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Getting CR instead of @ at colon prompt
Kevin King
Allen wrote: Nope. Blank Common and Named Common are specific to each user
process. So, if I run a program which initializes common, any other program
run by me during that session has that data available, but that data is NOT
available to any other process.
Allen it is my understanding that
Or leaving off the quotes?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: Friday, March 04, 2005 5:17 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Getting CR instead of @ at colon prompt
You might try pressing Ctrl-X instead
Kevin King wrote:
You might try pressing Ctrl-X instead of typing ^X.
That causes the session to lock up and a window to appear saying it's
sending something to the printer. (And how would I 'press Ctrl-X' in
the LOGIN paragraph?)
But I can live with never being able to type ^ in that
You might try setting it in Unix via stty...? I know, I know...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak
Sent: Friday, March 04, 2005 4:53 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Getting CR instead of @ at colon prompt
LeRoy can you comment on this. Why pay more for Enterprise licensing if it
doesn't work properly?
Regards
David Jordan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews
Sent: Saturday, 5 March 2005 8:30 AM
To: u2-users@listserver.u2ug.org
On Fri, 04 Mar 2005 18:40:55 -0500, you wrote:
Allen wrote: Nope. Blank Common and Named Common are specific to each user
process. So, if I run a program which initializes common, any other program
run by me during that session has that data available, but that data is NOT
available to any
I have fixed-width records in a text file that I want to import to a UD
hashed file, but have to create this file first.
If the text file is 46,061 KB, and the UD file would not be added to,
what CREATE.FILE specs should I use to create this file?
TIA
Shawn
---
u2-users mailing list
My department, Residential and Student Services, at the Univeristy of
California, Berkeley, is seeking a contract programmer/analyst to work on
existing Universe business-type applications on an 11-month full-time
closed-term contract at the Berkeley campus. The key qualification is
Universe
46 matches
Mail list logo
