Re: [U2] Select with Multiple Indices Not Working
I will need to check in the morning. But I am almost certain that it does work this way. Richard Brown <[EMAIL PROTECTED]> wrote: If you do multiple selects does it work? SELECT ORDERS WITH CUST.NO = '12345' xx items selected SELECT ORDERS WITH INV.DATE = '12/14/05' Richard > We have a file that has the customer number and invoice date indexed. > > When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH INV.DATE = '12/14/05'" no items are selected. > > We are running Unidata 6.0.6. > > Is anyone aware of any issues ? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - Get your email and more, right on the new Yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Select with Multiple Indices Not Working
Yes. I do recall having a problem with a Unidata release years ago. After struggling with the release for several months. IBM finally admitted that they had a major bug in that release. [EMAIL PROTECTED] wrote: We had a problem with the udtsort.exe in 5.2. IBM actually had us use the udtsort.exe from an earlier version. Now that I think about it, the problem may not have been resolved until 6.0.12. Please don't start using different versions of udtsort.exe without verification from IBM of which versions will work with which versions. Hth Colin Alfke Calgary Canada >-Original Message- >From: Baakkonen, Rodney A (Rod) > >Try using NO.INDEX and see if you get the results you are >looking for. If that is the case, you need to rebuild the >index. Have you had any system crashes lately? > >select ORDERS NO.INDEX WITH CUST.NO = '12345' AND WITH >INV.DATE = '12/14/05'" >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] Behalf Of Dave S >Sent: Tuesday, August 29, 2006 8:54 AM >To: u2-users@listserver.u2ug.org >Subject: [U2] Select with Multiple Indices Not Working > > >We have a file that has the customer number and invoice date indexed. > > When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' >AND WITH INV.DATE = '12/14/05'" no items are selected. > > We are running Unidata 6.0.6. > > Is anyone aware of any issues ? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Select with Multiple Indices Not Working
If you do multiple selects does it work? SELECT ORDERS WITH CUST.NO = '12345' xx items selected SELECT ORDERS WITH INV.DATE = '12/14/05' Richard > We have a file that has the customer number and invoice date indexed. > > When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH INV.DATE = '12/14/05'" no items are selected. > > We are running Unidata 6.0.6. > > Is anyone aware of any issues ? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Select with Multiple Indices Not Working
OK. I am using double-quotes at TCL. Timothy Snyder <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote on 08/29/2006 09:53:33 AM: > When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND > WITH INV.DATE = '12/14/05'" no items are selected. Try it with double quotes instead of single quotes. It may be taking those values as primary keys. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - Do you Yahoo!? Get on board. You're invited to try the new Yahoo! Mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Select with Multiple Indices Not Working
If the indexes are deleted, the select statement works fine. Kevin King <[EMAIL PROTECTED]> wrote: >When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH INV.DATE = '12/14/05'" no items are selected. And if you disable the index (via DISABLE.INDEX) the select works fine? And is the customer number and invoice date both in the ORDERS file? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Select with Multiple Indices Not Working
I have done so. Angelo Collazo <[EMAIL PROTECTED]> wrote: If you have the luxury and can do a build.index on primetime then do it. This would rule out corrupted indexes. Hope It helps. Cheers, Angelo -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave S Sent: Tuesday, August 29, 2006 9:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Select with Multiple Indices Not Working We have a file that has the customer number and invoice date indexed. When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH INV.DATE = '12/14/05'" no items are selected. We are running Unidata 6.0.6. Is anyone aware of any issues ? - Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - Stay in the know. Pulse on the new Yahoo.com. Check it out. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Select with Multiple Indices Not Working
Yes. I am sure. If for some reason, I can't get this index to work --- I may convert the date to output format and store it that way. Jeff Schasny <[EMAIL PROTECTED]> wrote: OK, I'll ask the obvious question. Are you sure that there is data matching this criteria in the file? Dave S wrote: > We have a file that has the customer number and invoice date indexed. > > When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH > INV.DATE = '12/14/05'" no items are selected. > > We are running Unidata 6.0.6. > > Is anyone aware of any issues ? > > > - > Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small > Business. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > > > -- == Jeff Schasny jschasnyATricochetDOTcom == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Select with Multiple Indices Not Working
We had a problem with the udtsort.exe in 5.2. IBM actually had us use the udtsort.exe from an earlier version. Now that I think about it, the problem may not have been resolved until 6.0.12. Please don't start using different versions of udtsort.exe without verification from IBM of which versions will work with which versions. Hth Colin Alfke Calgary Canada >-Original Message- >From: Baakkonen, Rodney A (Rod) > >Try using NO.INDEX and see if you get the results you are >looking for. If that is the case, you need to rebuild the >index. Have you had any system crashes lately? > >select ORDERS NO.INDEX WITH CUST.NO = '12345' AND WITH >INV.DATE = '12/14/05'" >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] Behalf Of Dave S >Sent: Tuesday, August 29, 2006 8:54 AM >To: u2-users@listserver.u2ug.org >Subject: [U2] Select with Multiple Indices Not Working > > >We have a file that has the customer number and invoice date indexed. > > When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' >AND WITH INV.DATE = '12/14/05'" no items are selected. > > We are running Unidata 6.0.6. > > Is anyone aware of any issues ? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Select with Multiple Indices Not Working
We have tried both ways. I am now tweaking the invoice date dictionary to see if that helps. Gordon J Glorfield <[EMAIL PROTECTED]> wrote: It's always been my understanding that the single quotes don't work at ECL/TCL. I'd try the same thing but use double quotes instead. Gordon J. Glorfield Sr. Applications Developer UnitedHealthcare's Mid-Atlantic Health Plans 301-360-8839 [EMAIL PROTECTED] wrote on 08/29/2006 09:53:33 AM: > We have a file that has the customer number and invoice date indexed. > When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND > WITH INV.DATE = '12/14/05'" no items are selected. > We are running Unidata 6.0.6. > Is anyone aware of any issues ? > [snip] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - Stay in the know. Pulse on the new Yahoo.com. Check it out. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Select with Multiple Indices Not Working
Dave, I'm not aware of any issues. UniData will only use one index per Select statement. What results do you get when you use the NO.INDEX keyword? Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave S Sent: Tuesday, August 29, 2006 6:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Select with Multiple Indices Not Working We have a file that has the customer number and invoice date indexed. When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH INV.DATE = '12/14/05'" no items are selected. We are running Unidata 6.0.6. Is anyone aware of any issues ? - Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Select with Multiple Indices Not Working
[EMAIL PROTECTED] wrote on 08/29/2006 09:53:33 AM: > When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND > WITH INV.DATE = '12/14/05'" no items are selected. Try it with double quotes instead of single quotes. It may be taking those values as primary keys. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Select with Multiple Indices Not Working
If you have the luxury and can do a build.index on primetime then do it. This would rule out corrupted indexes. Hope It helps. Cheers, Angelo -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave S Sent: Tuesday, August 29, 2006 9:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Select with Multiple Indices Not Working We have a file that has the customer number and invoice date indexed. When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH INV.DATE = '12/14/05'" no items are selected. We are running Unidata 6.0.6. Is anyone aware of any issues ? - Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Select with Multiple Indices Not Working
OK, I'll ask the obvious question. Are you sure that there is data matching this criteria in the file? Dave S wrote: We have a file that has the customer number and invoice date indexed. When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH INV.DATE = '12/14/05'" no items are selected. We are running Unidata 6.0.6. Is anyone aware of any issues ? - Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- == Jeff Schasny jschasnyATricochetDOTcom == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Select with Multiple Indices Not Working
>When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH INV.DATE = '12/14/05'" no items are selected. And if you disable the index (via DISABLE.INDEX) the select works fine? And is the customer number and invoice date both in the ORDERS file? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Select with Multiple Indices Not Working
No system crashes. It's a brand new file that I created.
001: D
002: 1
003: D4-
004: Inv Date
005: 8L
006: S
001: V
002: SUBR("-OCONVS",@ID,"G0.1")
003:
004: ClientID
005: 8L
006: S
007:
008: CLIENT.ID}}SUBR("-OCONVS",@ID,"G0.1")
009: QUICK.EBV
"Baakkonen, Rodney A (Rod) 46K" <[EMAIL PROTECTED]> wrote:
Try using NO.INDEX and see if you get the results you are looking for. If
that is the case, you need to rebuild the index. Have you had any system
crashes lately?
select ORDERS NO.INDEX WITH CUST.NO = '12345' AND WITH INV.DATE =
'12/14/05'"
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave S
Sent: Tuesday, August 29, 2006 8:54 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Select with Multiple Indices Not Working
We have a file that has the customer number and invoice date indexed.
When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH
INV.DATE = '12/14/05'" no items are selected.
We are running Unidata 6.0.6.
Is anyone aware of any issues ?
-
Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small
Business.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-
Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Select with Multiple Indices Not Working
It's always been my understanding that the single quotes don't work at ECL/TCL. I'd try the same thing but use double quotes instead. Gordon J. Glorfield Sr. Applications Developer UnitedHealthcare's Mid-Atlantic Health Plans 301-360-8839 [EMAIL PROTECTED] wrote on 08/29/2006 09:53:33 AM: > We have a file that has the customer number and invoice date indexed. > When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND > WITH INV.DATE = '12/14/05'" no items are selected. > We are running Unidata 6.0.6. > Is anyone aware of any issues ? > [snip] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Select with Multiple Indices Not Working
Try using NO.INDEX and see if you get the results you are looking for. If that is the case, you need to rebuild the index. Have you had any system crashes lately? select ORDERS NO.INDEX WITH CUST.NO = '12345' AND WITH INV.DATE = '12/14/05'" -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave S Sent: Tuesday, August 29, 2006 8:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Select with Multiple Indices Not Working We have a file that has the customer number and invoice date indexed. When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH INV.DATE = '12/14/05'" no items are selected. We are running Unidata 6.0.6. Is anyone aware of any issues ? - Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
