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

2013-01-29 Thread Brian Leach
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


Re: [U2] Triggers in Universe

2013-01-29 Thread Brian Leach
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 bwor...@coburns.com wrote:

 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 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 
 bob_woodw...@k2sports.com
 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 strict policies regarding the content of e-mail communications, 
 specifically Protected Health Information, any communications 
 containing such material will be returned to the originating party 
 with such advisement noted. If you are not the intended recipient, 
 please contact 

Re: [U2] Data not seen using LIST.ITEM

2013-01-29 Thread Wols Lists
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

2013-01-29 Thread Wols Lists
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] Triggers in Universe

2013-01-29 Thread Bill Haskett
/...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' u2-users@listserver.u2ug.org
*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 bwor...@coburns.com wrote:


[snipped]


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Searching for 'Bad' Dates

2013-01-29 Thread Greg Coelho
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

2013-01-29 Thread Lunt, Bruce
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

2013-01-29 Thread Israel, John R.
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 coe...@american.edu 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

2013-01-29 Thread Peter Cheney
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

2013-01-29 Thread Bill Haskett

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

2013-01-29 Thread Greg Coelho
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 wphask...@advantos.net
To: U2 Users List u2-users@listserver.u2ug.org
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

2013-01-29 Thread Bill Haskett

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 u2-users@listserver.u2ug.org
*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 wphask...@advantos.net
To: U2 Users List u2-users@listserver.u2ug.org
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

2013-01-29 Thread Greg Coelho
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 wphask...@advantos.net
To: U2 Users List u2-users@listserver.u2ug.org
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 u2-users@listserver.u2ug.org
*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 wphask...@advantos.net
 To: U2 Users List u2-users@listserver.u2ug.org
 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

2013-01-29 Thread Tony Gravagno
 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

2013-01-29 Thread Wjhonson
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 wphask...@advantos.net
To: U2 Users List u2-users@listserver.u2ug.org
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

2013-01-29 Thread Richard Lewis
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 coe...@american.edu 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