Re: [U2] Searching for 'Bad' Dates
How about: SELECT fname WITH MPAR.STATUS.DATE CONV "" = "[/]" Since you seem to know exactly the kind of erroneous data you want to find. On Tue, Jan 29, 2013 at 3:38 PM, Greg Coelho wrote: > All, > > Can anyone help me with a query to find instances where an external date > has been written to a date field? I would like to use ...WITH > MPAR.STATUS.DATE LIKE ".. > ./..." (the dates would be in the fomat: '12/16/12', but this field is set > with external formatting so I end up bringing back everything. Is there a > way I can 'turn off' formatting for this field within the query? > > Thanks, > > Greg > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Searching for 'Bad' Dates
Just use the NUM function in an I-Descript. Any external format, has to have at least one non-numeric in it. -Original Message- From: Bill Haskett To: U2 Users List Sent: Tue, Jan 29, 2013 3:01 pm Subject: Re: [U2] Searching for 'Bad' Dates Greg: Can you do something like: :select {FileName} WITH EVAL "OCONV(MPAR.STATUS.DATE, 'D')" = "" This works fine on UniData in PICK mode, where an invalid conversion returns a null (an empty string). HTH, Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, 30 January 2013 8:38 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Searching for 'Bad' Dates All, Can anyone help me with a query to find instances where an external date has been written to a date field? I would like to use ...WITH MPAR.STATUS.DATE LIKE ".. ./..." (the dates would be in the fomat: '12/16/12', but this field is set with external formatting so I end up bringing back everything. Is there a way I can 'turn off' formatting for this field within the query? Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Searching for 'Bad' Dates
> From: Peter Cheney > How about a DICT item that performs a match like "2n'/'2n'/'2n" on > that field? Better to simply look for anything non-numeric. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Searching for 'Bad' Dates
Aah, I see. I'll need to check our UDT.OPTIONS. I think that I've managed to get this one worked out by creating a DICT entry without formating. This gave me the list that I need. In that we are migrating more and more data to SQL Server which really chokes on a bad date I'll need to get better at flushing these out. Thanks, Greg From: Bill Haskett To: U2 Users List Date: 01/29/2013 06:17 PM Subject:Re: [U2] Searching for 'Bad' Dates Sent by:u2-users-boun...@listserver.u2ug.org Greg: That was the point. What happens is an externally formatted date isn't OCONV'd, if the dbms is configured to return an empty string for a bad conversion. I've got this set up on our systems like this. So, when I run the following code: 2 Dev (0)-> BPTEST CRT 'OConverted Date--: ' : OCONV('01/29/13', 'D') ; END Compiling Unibasic: SAVEDLISTS\BpTest_547690521 in mode 'p'. compilation finished OConverted Date--: ...I get what you're looking for, an empty string for dates filed in external format. In UniData I need UDT.OPTIONS 56 ON. Bill - Original Message - *From:* coe...@american.edu *To:* U2 Users List *Date:* 1/29/2013 3:09 PM *Subject:* Re: [U2] Searching for 'Bad' Dates > Bill, > > This is only returning those records that do not have a value in > MPAR.STATUS.DATE. Unfortunately I looking for records where an external > date has been written instead of the internal date. > > Greg > > > > From: Bill Haskett > To: U2 Users List > Date: 01/29/2013 06:01 PM > Subject:Re: [U2] Searching for 'Bad' Dates > Sent by:u2-users-boun...@listserver.u2ug.org > > > > Greg: > > Can you do something like: > > :select {FileName} WITH EVAL "OCONV(MPAR.STATUS.DATE, 'D')" = "" > > This works fine on UniData in PICK mode, where an invalid conversion > returns a null (an empty string). > > HTH, > > Bill > > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [ > mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho > Sent: Wednesday, 30 January 2013 8:38 > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Searching for 'Bad' Dates > > All, > > Can anyone help me with a query to find instances where an external date > has been written to a date field? I would like to use ...WITH > MPAR.STATUS.DATE LIKE ".. > ./..." (the dates would be in the fomat: '12/16/12', but this field is set > with external formatting so I end up bringing back everything. Is there a > way I can 'turn off' formatting for this field within the query? > > Thanks, > > Greg > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Searching for 'Bad' Dates
Greg: That was the point. What happens is an externally formatted date isn't OCONV'd, if the dbms is configured to return an empty string for a bad conversion. I've got this set up on our systems like this. So, when I run the following code: 2 Dev (0)-> BPTEST CRT 'OConverted Date--: ' : OCONV('01/29/13', 'D') ; END Compiling Unibasic: SAVEDLISTS\BpTest_547690521 in mode 'p'. compilation finished OConverted Date--: ...I get what you're looking for, an empty string for dates filed in external format. In UniData I need UDT.OPTIONS 56 ON. Bill - Original Message - *From:* coe...@american.edu *To:* U2 Users List *Date:* 1/29/2013 3:09 PM *Subject:* Re: [U2] Searching for 'Bad' Dates Bill, This is only returning those records that do not have a value in MPAR.STATUS.DATE. Unfortunately I looking for records where an external date has been written instead of the internal date. Greg From: Bill Haskett To: U2 Users List Date: 01/29/2013 06:01 PM Subject:Re: [U2] Searching for 'Bad' Dates Sent by:u2-users-boun...@listserver.u2ug.org Greg: Can you do something like: :select {FileName} WITH EVAL "OCONV(MPAR.STATUS.DATE, 'D')" = "" This works fine on UniData in PICK mode, where an invalid conversion returns a null (an empty string). HTH, Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, 30 January 2013 8:38 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Searching for 'Bad' Dates All, Can anyone help me with a query to find instances where an external date has been written to a date field? I would like to use ...WITH MPAR.STATUS.DATE LIKE ".. ./..." (the dates would be in the fomat: '12/16/12', but this field is set with external formatting so I end up bringing back everything. Is there a way I can 'turn off' formatting for this field within the query? Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Searching for 'Bad' Dates
Bill, This is only returning those records that do not have a value in MPAR.STATUS.DATE. Unfortunately I looking for records where an external date has been written instead of the internal date. Greg From: Bill Haskett To: U2 Users List Date: 01/29/2013 06:01 PM Subject:Re: [U2] Searching for 'Bad' Dates Sent by:u2-users-boun...@listserver.u2ug.org Greg: Can you do something like: :select {FileName} WITH EVAL "OCONV(MPAR.STATUS.DATE, 'D')" = "" This works fine on UniData in PICK mode, where an invalid conversion returns a null (an empty string). HTH, Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, 30 January 2013 8:38 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Searching for 'Bad' Dates All, Can anyone help me with a query to find instances where an external date has been written to a date field? I would like to use ...WITH MPAR.STATUS.DATE LIKE ".. ./..." (the dates would be in the fomat: '12/16/12', but this field is set with external formatting so I end up bringing back everything. Is there a way I can 'turn off' formatting for this field within the query? Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Searching for 'Bad' Dates
Greg: Can you do something like: :select {FileName} WITH EVAL "OCONV(MPAR.STATUS.DATE, 'D')" = "" This works fine on UniData in PICK mode, where an invalid conversion returns a null (an empty string). HTH, Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, 30 January 2013 8:38 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Searching for 'Bad' Dates All, Can anyone help me with a query to find instances where an external date has been written to a date field? I would like to use ...WITH MPAR.STATUS.DATE LIKE ".. ./..." (the dates would be in the fomat: '12/16/12', but this field is set with external formatting so I end up bringing back everything. Is there a way I can 'turn off' formatting for this field within the query? Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Searching for 'Bad' Dates
How about a DICT item that performs a match like "2n'/'2n'/'2n" on that field? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, 30 January 2013 8:38 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Searching for 'Bad' Dates All, Can anyone help me with a query to find instances where an external date has been written to a date field? I would like to use ...WITH MPAR.STATUS.DATE LIKE ".. ./..." (the dates would be in the fomat: '12/16/12', but this field is set with external formatting so I end up bringing back everything. Is there a way I can 'turn off' formatting for this field within the query? Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Searching for 'Bad' Dates
Write a new dict w/o the conversion code and select on it. John Israel Sent from my iPhone On Jan 29, 2013, at 5:38 PM, "Greg Coelho" wrote: > All, > > Can anyone help me with a query to find instances where an external date > has been written to a date field? I would like to use ...WITH > MPAR.STATUS.DATE LIKE ".. > ./..." (the dates would be in the fomat: '12/16/12', but this field is set > with external formatting so I end up bringing back everything. Is there a > way I can 'turn off' formatting for this field within the query? > > Thanks, > > Greg > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Searching for 'Bad' Dates
Use a dict item for the field that does not have the date conversion. Usually F1 or F2 or whatever are just raw formatted and will work. Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Tuesday, January 29, 2013 2:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Searching for 'Bad' Dates All, Can anyone help me with a query to find instances where an external date has been written to a date field? I would like to use ...WITH MPAR.STATUS.DATE LIKE ".. ./..." (the dates would be in the fomat: '12/16/12', but this field is set with external formatting so I end up bringing back everything. Is there a way I can 'turn off' formatting for this field within the query? Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Searching for 'Bad' Dates
All, Can anyone help me with a query to find instances where an external date has been written to a date field? I would like to use ...WITH MPAR.STATUS.DATE LIKE ".. ./..." (the dates would be in the fomat: '12/16/12', but this field is set with external formatting so I end up bringing back everything. Is there a way I can 'turn off' formatting for this field within the query? Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
"/...but I've created systems with master triggers that read a list of subordinate triggers from a control file and call them in order./" This appears to be the "best practices" of managing triggers in UD. Once explained, it seems the most logical method of managing triggers and allowing individual dbms accounts to use local versions of trigger subroutines. Bill - Original Message - *From:* br...@brianleach.co.uk *To:* 'U2 Users List' *Date:* 1/29/2013 1:08 AM *Subject:* Re: [U2] Triggers in Universe Peter Yes, they are still cached but you can derive the name - it's an overhead but I've created systems with master triggers that read a list of subordinate triggers from a control file and call them in order. Then these can have a version stamp appended when catalogued. IN practice I found the overhead of reading the list was minimal compared with the overheads on calling the trigger in the first place, and because it's happening all the time on a busy system that control file is constantly cached in memory anyway. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: 28 January 2013 23:26 To: U2 Users List Subject: Re: [U2] Triggers in Universe Could use the trigger program to call one or more external subroutines based on the trigger action required? I understand that the external subroutines are not cached and can be updated without needing to stop/start the master trigger. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Saturday, 26 January 2013 20:19 To: U2 Users List Subject: Re: [U2] Triggers in Universe Remember also that triggers, as subroutines, are cached in memory so if you recompile a trigger the changes won't be picked up by any processes that have not logged off or returned to TCL. Brian Sent from my iPad On 25 Jan 2013, at 22:18, Bobby Worley wrote: [snipped] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
On 28/01/13 23:26, Peter Cheney wrote: > Could use the trigger program to call one or more external subroutines based > on the trigger action required? > I understand that the external subroutines are not cached and can be updated > without needing to stop/start the master trigger. > Never tried this, but you should be able to break the cache if you so wish ... MYSUB = "subroutine name" CALL @MYSUB See my other post about the catalog and caching :-) but this will cache the object code in the variable MYSUB. If you reload the variable with the subroutine name EVERY CALL, it should load the object code afresh every time. Never tried it, can't guarantee it, but if you use this sort of code in your trigger program it should work fine without caching. When it's all tested and working, you can change it to "CALL *MYSUB" or whatever. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Data not seen using LIST.ITEM
On 28/01/13 21:32, Tyler L wrote: > Don, > Thank you for your reply. That is a nice thing to know. I using that I have > since found out that it is my own fault for not reading the code properly > and I have resolved the issue. Thank you very much. > I know you've solved it :-) but something else that is very useful ... Look in VOC for entries called "1" or "F1" etc. I'm not sure how far it goes by default, but I always add extras as I need them. They're default dictionary items so you can at least look at a field. In your case LIST filename F30 would probably fail with "F30 not found", but for smaller numbers it would list the field, and if you edited F1, replaced line 2 with the number 30, and saved it as F30 that command would then display the contents of field 30 for you. A useful trick ... Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
Peter Yes, they are still cached but you can derive the name - it's an overhead but I've created systems with master triggers that read a list of subordinate triggers from a control file and call them in order. Then these can have a version stamp appended when catalogued. IN practice I found the overhead of reading the list was minimal compared with the overheads on calling the trigger in the first place, and because it's happening all the time on a busy system that control file is constantly cached in memory anyway. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: 28 January 2013 23:26 To: U2 Users List Subject: Re: [U2] Triggers in Universe Could use the trigger program to call one or more external subroutines based on the trigger action required? I understand that the external subroutines are not cached and can be updated without needing to stop/start the master trigger. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Saturday, 26 January 2013 20:19 To: U2 Users List Subject: Re: [U2] Triggers in Universe Remember also that triggers, as subroutines, are cached in memory so if you recompile a trigger the changes won't be picked up by any processes that have not logged off or returned to TCL. Brian Sent from my iPad On 25 Jan 2013, at 22:18, Bobby Worley wrote: > That's what I did, Perry! GMTA ;) > > > > On Fri, Jan 25, 2013 at 4:07 PM, Perry Taylor wrote: > >> 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: u2-users-boun...@listserver.u2ug.org [mailto: >> u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley >> Sent: Friday, January 25, 2013 3:03 PM >> To: U2 Users List >> Subject: Re: [U2] Triggers in Universe >> >> 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 >> >> wrote: >> >>> 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: Friday, January 25, 2013 1:33 PM >>> To: U2 Users List >>> Subject: [U2] Triggers in Universe >>> >>> 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' >>> * >>> >>> Compilation Complete. >>> CATALOG BDW TRIGTEST >>> "TRIGTEST" cataloged. >>> .L TRIGTEST >>> >>> TRIGTEST >>> 001 V >>> 002 BDW.O/TRIGTEST >>> 003 B >>> 004 BNP >>> 005 >>> 006 PICK.FORMAT >>> 007 S N P I A E H >>> 008 NO.WARN NOPAGE LPTR KEEP.COMMON TRAP HDR-SUPP >>> 009 BDW.O >>> >>> CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL FOR >>> EACH ROW CALLING 'TRIGTEST'; >>> Unable to locate trigger program "BDW.O/TRIGTEST". >>> >>> >>> -- >>> >>> >>> >>> *Bobby D. Worley* >>> >>> IT Applications Developer >>> >>> Coburn Supply Company >>> >>> o: 903.753.8613 | m: 214.676.9825 >>> >>> bwor...@coburns.com >>> >>> ** ** >>> ___ >>> U2-Users mailing list >>> U2-Users@listserver.u2ug.org >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >>> ___ >>> U2-Users mailing list >>> U2-Users@listserver.u2ug.org >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >> >> >> >> -- >> >> >> >> *Bobby D. Worley* >> >> IT Applications Developer >> >> Coburn Supply Company >> >> o: 903.753.8613 | m: 214.676.9825 >> >> bwor...@coburns.com >> >> ** ** >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> >> CONFIDENTIALITY NOTICE: This e-mail message, including any >> attachments, is for the sole use of the intended recipient(s) and may >> contain confidential and privileged information. Any unauthorized >> review, use, disclosure or distribution is prohibited. ZirMed, Inc. >> has
Re: [U2] [UD] Disabling/blocking ODBC
Sadly these appear to be UniData only. Or at least, in the past I've tried with local catalog, global catalog as *UOLOGIN and global catalog as the (illegal) UOLOGIN. None of these got fired. Would be really useful as a central consolidation point for things like setting DATE.FORMAT. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: 28 January 2013 21:23 To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Is this only Unidata or Universe? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, 29 January 2013 9:15 a.m. To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Glad to hear that! Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Monday, January 28, 2013 12:25 PM To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC > 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. Dan, I got the info from our VAR and it works great. Thanks! Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users