[U2] Unidata SELECT
Hi All, We have a program that used to work but is now not functioning. The problems is if you have an active select list and you try to run the following statements GET.LIST CL.BCS.MAYBE this has 139 records SELECT STUDENTS WITH X.STU.BCS.REG.FLAG LIKE 'N...' This statement will return either No results or only 1 result But if you change the SELECT to a LIST then 3 lines will be returned. Also if you change the SELECT to an SSELECT then 3 lines will be returned. What it looks like is happening is another select statement is clearing out the orginal select statement and only returning the results of the last record in the orginal 139 records. X.STU.BCS.REG.FLAG is a I desriptor in STUDENTS that calls the following subroutine XS.CALC.ACTIVE.BCS.TO.REG and this subroutine calls another SUBROUTINE XS.CALC.REG.TERM. Anybody have any ideas? Any UDT.OPTIONS I should work with? Thank you in advance. Cheers Fawaz __ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata SELECT
Fawaz Ashraff wrote: Hi All, We have a program that used to work but is now not functioning. The problems is if you have an active select list and you try to run the following statements GET.LIST CL.BCS.MAYBE this has 139 records SELECT STUDENTS WITH X.STU.BCS.REG.FLAG LIKE 'N...' This statement will return either No results or only 1 result But if you change the SELECT to a LIST then 3 lines will be returned. Also if you change the SELECT to an SSELECT then 3 lines will be returned. What it looks like is happening is another select statement is clearing out the orginal select statement and only returning the results of the last record in the orginal 139 records. X.STU.BCS.REG.FLAG is a I desriptor in STUDENTS that calls the following subroutine XS.CALC.ACTIVE.BCS.TO.REG and this subroutine calls another SUBROUTINE XS.CALC.REG.TERM. Anybody have any ideas? Any UDT.OPTIONS I should work with? Have you checked that those 3 listed records are in the save.list? 1) get.list the list 2) select the file. With no With or By options. just confirm that the items on the list are in the file. And you've confirmed that the file isn't corrupted, right? And are any of the dictionaries indexed? Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata SELECT
Hi Roger, Non of the dictionaries are indexed and I can select the data. File is not corrupted. Fawaz --- Roger Glenfield [EMAIL PROTECTED] wrote: Fawaz Ashraff wrote: Hi All, We have a program that used to work but is now not functioning. The problems is if you have an active select list and you try to run the following statements GET.LIST CL.BCS.MAYBE this has 139 records SELECT STUDENTS WITH X.STU.BCS.REG.FLAG LIKE 'N...' This statement will return either No results or only 1 result But if you change the SELECT to a LIST then 3 lines will be returned. Also if you change the SELECT to an SSELECT then 3 lines will be returned. What it looks like is happening is another select statement is clearing out the orginal select statement and only returning the results of the last record in the orginal 139 records. X.STU.BCS.REG.FLAG is a I desriptor in STUDENTS that calls the following subroutine XS.CALC.ACTIVE.BCS.TO.REG and this subroutine calls another SUBROUTINE XS.CALC.REG.TERM. Anybody have any ideas? Any UDT.OPTIONS I should work with? Have you checked that those 3 listed records are in the save.list? 1) get.list the list 2) select the file. With no With or By options. just confirm that the items on the list are in the file. And you've confirmed that the file isn't corrupted, right? And are any of the dictionaries indexed? Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata SELECT
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/