[U2] [UD] Disabling/blocking ODBC

2013-01-25 Thread bradley . schrag
We may need to figure out a way to disable ODBC access to UniData due to data access concerns. I've set up connections before, but have never approached ODBC from this perspective. I'm hoping there's a service we can turn off or a port we can block. One possible constraint is that we still

Re: [U2] [UD] Disabling/blocking ODBC

2013-01-25 Thread Jeff Schasny
I believe both Universe and Unidata run ODBC via the standard UniRPC port 31438 unless you are running UniRPC on a different port. bradley.sch...@usbank.com wrote: We may need to figure out a way to disable ODBC access to UniData due to data access concerns. I've set up connections before, but

Re: [U2] [UD] Disabling/blocking ODBC

2013-01-25 Thread Wjhonson
You can can kill the unirpc process ? -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Jan 25, 2013 10:41 am Subject: Re: [U2] [UD] Disabling/blocking ODBC I believe both Universe and Unidata run ODBC via the

Re: [U2] [UD] Disabling/blocking ODBC

2013-01-25 Thread Daniel McGrath
There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine that is called for every ODBC call. You can use this to either blank prevent ODBC, or setting up restricted login access login. If you are under a support contract, contact your support provider and they should be able to

Re: [U2] [UD] Disabling/blocking ODBC

2013-01-25 Thread bradley . schrag
You can can kill the unirpc process ? That would do it. Unfortunately, it would also take down UO and UOJ, which we use. Hmmm. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any

Re: [U2] [UD] Disabling/blocking ODBC

2013-01-25 Thread bradley . schrag
This sounds very promising. I will pursue this route. Thanks, Dan. From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 01/25/2013 12:49 PM Subject: Re: [U2] [UD] Disabling/blocking ODBC Sent by: u2-users-boun...@listserver.u2ug.org There

Re: [U2] [UD] Disabling/blocking ODBC

2013-01-25 Thread Dan Fitzgerald
You could take out the path(s) to the Unidata accounts in the UCI file; I don't know if that would affect datastage, but it might be worth checking. Date: Fri, 25 Jan 2013 11:40:42 -0700 From: jscha...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] Disabling/blocking

Re: [U2] [UD] Disabling/blocking ODBC

2013-01-25 Thread Allen Egerton
(Allen - Sent from my paperweight) On Jan 25, 2013, at 1:49 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote: There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine that is called for every ODBC call. You can use this to either blank prevent ODBC, or setting up

Re: [U2] [UD] Disabling/blocking ODBC

2013-01-25 Thread Allen Egerton
Dan, Is this also available in Universe? (Release 10.3.7 for windows) (Allen - Sent from my paperweight) On Jan 25, 2013, at 1:49 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote: There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine that is called for every ODBC call.

Re: [U2] [UD] Disabling/blocking ODBC

2013-01-25 Thread Bill Haskett
Just as an aside, there's also a UOLOGIN global cataloged routine that is always called before a UO login (I created it with that name). It's a very handy routine to use to manage connections. Bill - Original

[U2] Triggers in Universe

2013-01-25 Thread Bobby Worley
I'm up against a wall here - trying to use triggers for the first time, on Universe. Can't seem to get my test to work - Universe on AIX: RELLEVEL 001 X 002 11.1.9 003 PICK 004 PICK.FORMAT 005 11.1.9 BASIC BDW TRIGTEST Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' *

Re: [U2] Triggers in Universe

2013-01-25 Thread Allen Egerton
Has to be globally cataloged. And there's a prescribed list of args. There are some 'best practices' i can pass on to you when im at a fullsize keyboard if you'd like. (Allen - Sent from my paperweight) On Jan 25, 2013, at 4:33 PM, Bobby Worley bwor...@coburns.com wrote: I'm up against a

Re: [U2] Triggers in Universe

2013-01-25 Thread Woodward, Bob
In Unidata the problem would be that the trigger has to be cataloged globally, not locally. I'm not sure how to do that in Universe, though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent:

Re: [U2] Triggers in Universe

2013-01-25 Thread Bobby Worley
The problem was the locally cataloged program.I was in an account that is PICK flavor and wouldn't allow global cataloging. When I catalog the program globally from the UV account the CREATE TRIGGER now works. Thanks! On Fri, Jan 25, 2013 at 3:56 PM, Woodward, Bob

Re: [U2] Triggers in Universe

2013-01-25 Thread Perry Taylor
You can globally catalog in a Pick-flavored account. Copy the CATALOG VOC record from the UV account to your Pick-flavored account VOC renaming it something like ICATALOG. We do it all the time for our file-based triggers. Perry -Original Message- From:

Re: [U2] Triggers in Universe

2013-01-25 Thread Bobby Worley
That's what I did, Perry! GMTA ;) On Fri, Jan 25, 2013 at 4:07 PM, Perry Taylor perry.tay...@zirmed.comwrote: You can globally catalog in a Pick-flavored account. Copy the CATALOG VOC record from the UV account to your Pick-flavored account VOC renaming it something like ICATALOG. We do