Re: [U2] Using uvreplicate
A quick question. Are you looking at UniVerse replication (the old style). Or U2 replication in 11.1 on? They are quite different animals. Regards JayJay ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Selection Suggestions for using UV instead of SQL
On 17/10/12 16:40, George Gallen wrote: How would I get the contents of the Index? George Don't have the UV BASIC manual in front of me, but it's something like READINDEX variable FROM filedescriptor, indexname[, indexvalue] If you only pass filedescriptor and indexname, it will return a list of all the index values. If you also pass indexvalue, it will return a list of all keys for that value. I'll have a look later and see if I can find that routine - it's probably on my system somewhere, but my archives aren't that organised... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, October 17, 2012 11:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 14:59, George Gallen wrote: Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could join the two, then do the select or use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this could be done with UV Native, and without involving a program. I first tried SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID - NSELECT PEOPLE But that returned 0 - since the NSELECT only works off the current select list, not the whole file Yes, I could create a temporary file, then select off that Yes, I could read each people record, then loop through registration to see if it doesn't exist. Both of the above require programming I guess I could create a subroutine that does the looping through registration, and put that into an I descriptor - looking for another option. Hmmm... What I guess I'd do - create an index on file2 based on PID. Create an idescriptor on file1 that gets the contents of that index. I had a routine somewhere that got fed an index value and file, and returned the contents of the index. It was quite useful, iirc. Manipulate it from there. Probably selecting where there is no value matching ...+1+... Cheers, Wol ___ 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] Selection Suggestions for using UV instead of SQL
I think you mean SELECTINDEX index.name[,key.val] FROM file.var [TO list.num] Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 08:55 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 16:40, George Gallen wrote: How would I get the contents of the Index? George Don't have the UV BASIC manual in front of me, but it's something like READINDEX variable FROM filedescriptor, indexname[, indexvalue] If you only pass filedescriptor and indexname, it will return a list of all the index values. If you also pass indexvalue, it will return a list of all keys for that value. I'll have a look later and see if I can find that routine - it's probably on my system somewhere, but my archives aren't that organised... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, October 17, 2012 11:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 14:59, George Gallen wrote: Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could join the two, then do the select or use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this could be done with UV Native, and without involving a program. I first tried SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID - NSELECT PEOPLE But that returned 0 - since the NSELECT only works off the current select list, not the whole file Yes, I could create a temporary file, then select off that Yes, I could read each people record, then loop through registration to see if it doesn't exist. Both of the above require programming I guess I could create a subroutine that does the looping through registration, and put that into an I descriptor - looking for another option. Hmmm... What I guess I'd do - create an index on file2 based on PID. Create an idescriptor on file1 that gets the contents of that index. I had a routine somewhere that got fed an index value and file, and returned the contents of the index. It was quite useful, iirc. Manipulate it from there. Probably selecting where there is no value matching ...+1+... Cheers, Wol ___ 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 Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== eUdxXwzJfD+jSPSM4kcQUHfMaOyCAuUs69aXEW7R1X!lw== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Selection Suggestions for using UV instead of SQL
On 18/10/12 09:29, Martin Braid wrote: I think you mean SELECTINDEX index.name[,key.val] FROM file.var [TO list.num] Martin Followed by a READLIST ... Quite possibly - I can't remember. One *important* point to note - if you are planning to call this from an i-descriptor, as I did, don't forget you MUST save that to a non-default list, or any attempt to LIST the idescriptor will go horribly wrong... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 08:55 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 16:40, George Gallen wrote: How would I get the contents of the Index? George Don't have the UV BASIC manual in front of me, but it's something like READINDEX variable FROM filedescriptor, indexname[, indexvalue] If you only pass filedescriptor and indexname, it will return a list of all the index values. If you also pass indexvalue, it will return a list of all keys for that value. I'll have a look later and see if I can find that routine - it's probably on my system somewhere, but my archives aren't that organised... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, October 17, 2012 11:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 14:59, George Gallen wrote: Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could join the two, then do the select or use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this could be done with UV Native, and without involving a program. I first tried SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID - NSELECT PEOPLE But that returned 0 - since the NSELECT only works off the current select list, not the whole file Yes, I could create a temporary file, then select off that Yes, I could read each people record, then loop through registration to see if it doesn't exist. Both of the above require programming I guess I could create a subroutine that does the looping through registration, and put that into an I descriptor - looking for another option. Hmmm... What I guess I'd do - create an index on file2 based on PID. Create an idescriptor on file1 that gets the contents of that index. I had a routine somewhere that got fed an index value and file, and returned the contents of the index. It was quite useful, iirc. Manipulate it from there. Probably selecting where there is no value matching ...+1+... Cheers, Wol ___ 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 Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== eUdxXwzJfD+jSPSM4kcQUHfMaOyCAuUs69aXEW7R1X!lw== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.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
Re: [U2] Selection Suggestions for using UV instead of SQL
Since the index files are actually type 25 files, you can always (though of course I would NEVER recommend this ... ) create a file pointer direct to the INDEX.nnn and read the entries as records ... saves grabbing a select list .. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 09:53 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 18/10/12 09:29, Martin Braid wrote: I think you mean SELECTINDEX index.name[,key.val] FROM file.var [TO list.num] Martin Followed by a READLIST ... Quite possibly - I can't remember. One *important* point to note - if you are planning to call this from an i-descriptor, as I did, don't forget you MUST save that to a non-default list, or any attempt to LIST the idescriptor will go horribly wrong... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 08:55 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 16:40, George Gallen wrote: How would I get the contents of the Index? George Don't have the UV BASIC manual in front of me, but it's something like READINDEX variable FROM filedescriptor, indexname[, indexvalue] If you only pass filedescriptor and indexname, it will return a list of all the index values. If you also pass indexvalue, it will return a list of all keys for that value. I'll have a look later and see if I can find that routine - it's probably on my system somewhere, but my archives aren't that organised... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, October 17, 2012 11:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 14:59, George Gallen wrote: Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could join the two, then do the select or use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this could be done with UV Native, and without involving a program. I first tried SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID - NSELECT PEOPLE But that returned 0 - since the NSELECT only works off the current select list, not the whole file Yes, I could create a temporary file, then select off that Yes, I could read each people record, then loop through registration to see if it doesn't exist. Both of the above require programming I guess I could create a subroutine that does the looping through registration, and put that into an I descriptor - looking for another option. Hmmm... What I guess I'd do - create an index on file2 based on PID. Create an idescriptor on file1 that gets the contents of that index. I had a routine somewhere that got fed an index value and file, and returned the contents of the index. It was quite useful, iirc. Manipulate it from there. Probably selecting where there is no value matching ...+1+... Cheers, Wol ___ 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 Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== eUdxXwzJfD+jSPSM4kcQUHfMaOyCAuUs69aXEW7R1X!lw== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of
Re: [U2] Consuming web services [not-secure]
Sorry this is late to the conversation, but you may want to look at http://www.pilotfishtechnology.com/ It's the swiss army knife of data integration. I'm using it in several different ways. You could have it go consume a service and bring the response back however you prefer. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, October 03, 2012 5:10 PM To: U2 Users List Subject: Re: [U2] Consuming web services Starting at UniData 7.3.0 and in UniVerse 11.1.9, we now have U2 Dynamic Objects which does help with the parsing 'till I'm blue in the face when consuming JSON requests. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Wednesday, October 03, 2012 2:56 PM To: U2-Users@listserver.u2ug.org Subject: [U2] Consuming web services I know we have both the SOAP and RESTful web services development for publishing web services from Universe but how are folks consuming other peoples web services into the database? Are there tools for this or am I going to just open a socket, read, and parse 'till I'm blue in the face? -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot 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 CONFIDENTIAL INFORMATION: The information contained in this e-mail may be confidential and protected from general disclosure. If the recipient or reader of this e-mail is not the intended recipient or a person responsible to receive this e-mail for the intended recipient, please do not disseminate, distribute or copy it. If you received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. We will take immediate and appropriate action to see to it that this mistake is corrected.[*LD*] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Speeding sort
Stupid question of the day on unidata 7.2.x I build indexes all over to speed queries - I have plenty of disk to burn. However does having an index help when sorting on a field that's not part of the selection criteria? For example we often do this dance between two files: SELECT FILE WITH FIELD='VALUE' SAVING UNIQUE SOME_KEY NO.NULLS SELECT ANOTHER_FILE BY SORT_FIELD I know indexing FIELD helps the first question, but does having an index on SORT_FIELD help the second? -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Selection Suggestions for using UV instead of SQL
I'll have to play with this later - thanks for the info... George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, October 18, 2012 6:50 AM To: 'U2 Users List' Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Since the index files are actually type 25 files, you can always (though of course I would NEVER recommend this ... ) create a file pointer direct to the INDEX.nnn and read the entries as records ... saves grabbing a select list .. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 09:53 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 18/10/12 09:29, Martin Braid wrote: I think you mean SELECTINDEX index.name[,key.val] FROM file.var [TO list.num] Martin Followed by a READLIST ... Quite possibly - I can't remember. One *important* point to note - if you are planning to call this from an i-descriptor, as I did, don't forget you MUST save that to a non-default list, or any attempt to LIST the idescriptor will go horribly wrong... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 08:55 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 16:40, George Gallen wrote: How would I get the contents of the Index? George Don't have the UV BASIC manual in front of me, but it's something like READINDEX variable FROM filedescriptor, indexname[, indexvalue] If you only pass filedescriptor and indexname, it will return a list of all the index values. If you also pass indexvalue, it will return a list of all keys for that value. I'll have a look later and see if I can find that routine - it's probably on my system somewhere, but my archives aren't that organised... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, October 17, 2012 11:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 14:59, George Gallen wrote: Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could join the two, then do the select or use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this could be done with UV Native, and without involving a program. I first tried SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID - NSELECT PEOPLE But that returned 0 - since the NSELECT only works off the current select list, not the whole file Yes, I could create a temporary file, then select off that Yes, I could read each people record, then loop through registration to see if it doesn't exist. Both of the above require programming I guess I could create a subroutine that does the looping through registration, and put that into an I descriptor - looking for another option. Hmmm... What I guess I'd do - create an index on file2 based on PID. Create an idescriptor on file1 that gets the contents of that index. I had a routine somewhere that got fed an index value and file, and returned the contents of the index. It was quite useful, iirc. Manipulate it from there. Probably selecting where there is no value matching ...+1+... Cheers, Wol ___ 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 Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== eUdxXwzJfD+jSPSM4kcQUHfMaOyCAuUs69aXEW7R1X!lw== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail
Re: [U2] Speeding sort
I can't say definitively, but I would expect the answer to be 'no'. On Thu, Oct 18, 2012 at 6:39 AM, Jeffrey Butera jbut...@hampshire.eduwrote: Stupid question of the day on unidata 7.2.x I build indexes all over to speed queries - I have plenty of disk to burn. However does having an index help when sorting on a field that's not part of the selection criteria? For example we often do this dance between two files: SELECT FILE WITH FIELD='VALUE' SAVING UNIQUE SOME_KEY NO.NULLS SELECT ANOTHER_FILE BY SORT_FIELD I know indexing FIELD helps the first question, but does having an index on SORT_FIELD help the second? -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/**hampshirecollegeithttp://www.facebook.com/hampshirecollegeit __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://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] Speeding sort
No -Original Message- From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Oct 18, 2012 5:39 am Subject: [U2] Speeding sort Stupid question of the day on unidata 7.2.x I build indexes all over to speed queries - I have plenty of disk to burn. However does having an index help when sorting on a field that's not part of the selection criteria? For example we often do this dance between two files: SELECT FILE WITH FIELD='VALUE' SAVING UNIQUE SOME_KEY NO.NULLS SELECT ANOTHER_FILE BY SORT_FIELD I know indexing FIELD helps the first question, but does having an index on SORT_FIELD help the second? -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ 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] Selection Suggestions for using UV instead of SQL
George: I wrote a TREE.CHECK program that does the following: 2 Dev (0)- TREE.CHECK MASTER -IINDEX_2 Index Check: MASTER, INDEX_1 ?Key... Indexed Value. ?350 1432 1434 G ST CONDO ASSOC ?50 ABBOTT WOOD TOWNHOMES ASSOC ?70 ASPEN HEIGHT CONDO OWNERS ASSC ?80 AUTUMN RIDGE HOMEOWNERS' ASSOC ?90 BONNIE CUSACK ESTATES ASSOC ?110 BOSTON SQUARE CONDOMINIUMS ?115 BRIARCLIFF TOWNHOMES ASSOC ?130 BROOKSHIRE CONDOMINIUM ASSOC ?120 BROOKVIEW CONDOMINIUM ASSOC ?135 CAMPBELL CREEK DUPLEX OWNERS ?140 CAPE HATTERAS AT COMMODORE PRK ?170 CEDARCREST CONDO ASSOC ?175 CHANDELLE ACRES P/O ASSOC ?215 CHUGACH MEADOWS II CONDO ASSOC ?160 CHUGACH MEADOWS TOWNHOME ASSOC ?150 CHUGIAK HANGARS ASSOCIATION ?185 CLEAR CREEK CONDOMINIUM ASSOC ?190 CONCORD HILL HOMEOWNER ASSOC ?180 CREEKSIDE TWNHOMES CONDO ASSOC ?200 CREEKVIEW CONDO ASSOC ??? [N]ext Pg, [P]rev Pg, [F]irst Pg, [L]ast Pg, [A]ccept, [S]top ? I wonder if this would help? Bill By the way, I did post the LSELECT code to pickwiki, under UniQuerySource. - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 10/18/2012 6:15 AM *Subject:* Re: [U2] Selection Suggestions for using UV instead of SQL I'll have to play with this later - thanks for the info... George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, October 18, 2012 6:50 AM To: 'U2 Users List' Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Since the index files are actually type 25 files, you can always (though of course I would NEVER recommend this ... ) create a file pointer direct to the INDEX.nnn and read the entries as records ... saves grabbing a select list .. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 09:53 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 18/10/12 09:29, Martin Braid wrote: I think you mean SELECTINDEX index.name[,key.val] FROM file.var [TO list.num] Martin Followed by a READLIST ... Quite possibly - I can't remember. One *important* point to note - if you are planning to call this from an i-descriptor, as I did, don't forget you MUST save that to a non-default list, or any attempt to LIST the idescriptor will go horribly wrong... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 08:55 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 16:40, George Gallen wrote: How would I get the contents of the Index? George Don't have the UV BASIC manual in front of me, but it's something like READINDEX variable FROM filedescriptor, indexname[, indexvalue] If you only pass filedescriptor and indexname, it will return a list of all the index values. If you also pass indexvalue, it will return a list of all keys for that value. I'll have a look later and see if I can find that routine - it's probably on my system somewhere, but my archives aren't that organised... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, October 17, 2012 11:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 14:59, George Gallen wrote: Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could join the two, then do the select or use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this could be done with UV Native, and without involving a program. I first tried SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID - NSELECT PEOPLE But that returned 0 - since the NSELECT only works off the current select list, not the whole file Yes, I could create a temporary file, then select off that Yes, I could read each people record, then loop through registration to see if it doesn't exist. Both of the above require programming I guess I could create a subroutine that does the looping through registration, and put that into an I descriptor - looking for another option. Hmmm... What I guess I'd
Re: [U2] Selection Suggestions for using UV instead of SQL
There used to be a version of a SELECT verb on the Rocket website. I
think it was in the white papers or technical articles section. It
provided source code to a verb called SELECTK I think it was called.
If anyone can find it, let me know. I haven't been able to find it after
the first time I read it.
Robert Norman
On 10/17/2012 10:20 AM, George Gallen wrote:
Looks like either UV doesn't have LSELECT, or UV 10.0.2 does not.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Wednesday, October 17, 2012 1:16 PM
To: U2 Users List
Subject: Re: [U2] Selection Suggestions for using UV instead of SQL
George:
How about something like:
3 Dev (0)- LSELECT ?
This will create a list of {FileName} keys for records whose
field definition value appears in a defined list.
Syntax:
LSELECT File_Name WITH Dict_Name IN LIST1 TO LIST2 [VERBOSE| -V]
Example: SELECT CUSTOMERS SAMPLE 500
SAVE.LIST MY.LIST
LSELECT SALES.ORDERS WITH CUST.NBR IN MY.LIST TO MY.LIST.2
Notes:
If a destination list is not supplied then keys will be left as the active
select list. If a source list is not supplied then the current active
select
list will be used. Lists may be specified as select buffers (0-8) or as
named
lists from SAVEDLISTS.
An example of this is as follows:
3 Dev (0)- SELECT MASTER 260605
2 records selected to list 0.
3 Dev (0)- SAVE-LIST MY.LIST
2 key(s) saved to 1 record(s).
3 Dev (0)- LSELECT ARTMASTER WITH CLIENTNO IN MY.LIST VERBOSE
(Parsed Command)
LSELECT ARTMASTER WITH CLIENTNO IN MY.LIST TO 0
(Selected List)
List Source MY.LIST found 2 items.
(Create Temp File)
LSELECT0031 file created with MOD = 5
(Loaded List to Temp File) - 2 items.
977 key(s) saved to 1 record(s).
(Selected Result List)
UDT.COMMAND = select ARTMASTER WITH EVAL
TRANS('LSELECT0031',CLIENTNO,'@ID','X') GT TO 0
UDT.RESPONSE = ?977 records selected to list 0.??
Destination 0
Named List 0
(Delete Temp File)
LSELECT0031 file deleted...
3 Dev (0)
This now has a list of (/*ARTMASTER*/) records that contain a client# in
the original select list, MY.LIST.
HTH,
Bill
Untitled Page
___
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] Selection Suggestions for using UV instead of SQL
You can find it here:
https://u2devzone.rocketsoftware.com/accelerate/articles/u2-select/u2-select
Cheers,
Dan McGrath
Product Manager
Rocket Software
4600 S. Ulster Street **Suite 1100 **Denver, CO 80237 * USA
t: +1.720.475.8098 * m: +1.617.630.7392 * e:dmcgr...@rocketsoftware.com w:
rocketsoftware.com/u2
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert
Sent: Thursday, October 18, 2012 10:26 AM
To: U2 Users List
Subject: Re: [U2] Selection Suggestions for using UV instead of SQL
There used to be a version of a SELECT verb on the Rocket website. I think it
was in the white papers or technical articles section. It provided source code
to a verb called SELECTK I think it was called.
If anyone can find it, let me know. I haven't been able to find it after the
first time I read it.
Robert Norman
On 10/17/2012 10:20 AM, George Gallen wrote:
Looks like either UV doesn't have LSELECT, or UV 10.0.2 does not.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill
Haskett
Sent: Wednesday, October 17, 2012 1:16 PM
To: U2 Users List
Subject: Re: [U2] Selection Suggestions for using UV instead of SQL
George:
How about something like:
3 Dev (0)- LSELECT ?
This will create a list of {FileName} keys for records whose field
definition value appears in a defined list.
Syntax:
LSELECT File_Name WITH Dict_Name IN LIST1 TO LIST2 [VERBOSE| -V]
Example: SELECT CUSTOMERS SAMPLE 500
SAVE.LIST MY.LIST
LSELECT SALES.ORDERS WITH CUST.NBR IN MY.LIST TO MY.LIST.2
Notes:
If a destination list is not supplied then keys will be left as the
active select list. If a source list is not supplied then the current
active select list will be used. Lists may be specified as select
buffers (0-8) or as named lists from SAVEDLISTS.
An example of this is as follows:
3 Dev (0)- SELECT MASTER 260605
2 records selected to list 0.
3 Dev (0)- SAVE-LIST MY.LIST
2 key(s) saved to 1 record(s).
3 Dev (0)- LSELECT ARTMASTER WITH CLIENTNO IN MY.LIST VERBOSE (Parsed
Command) LSELECT ARTMASTER WITH CLIENTNO IN MY.LIST TO 0
(Selected List)
List Source MY.LIST found 2 items.
(Create Temp File)
LSELECT0031 file created with MOD = 5
(Loaded List to Temp File) - 2 items.
977 key(s) saved to 1 record(s).
(Selected Result List)
UDT.COMMAND = select ARTMASTER WITH EVAL
TRANS('LSELECT0031',CLIENTNO,'@ID','X') GT TO 0 UDT.RESPONSE =
?977 records selected to list 0.??
Destination 0
Named List 0
(Delete Temp File)
LSELECT0031 file deleted...
3 Dev (0)
This now has a list of (/*ARTMASTER*/) records that contain a client#
in the original select list, MY.LIST.
HTH,
Bill
Untitled Page
___
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] Selection Suggestions for using UV instead of SQL
What is the purpose of using a $ in one of your variable names? -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Oct 18, 2012 9:24 am Subject: Re: [U2] Selection Suggestions for using UV instead of SQL George: I wrote a TREE.CHECK program that does the following: 2 Dev (0)- TREE.CHECK MASTER -IINDEX_2 Index Check: MASTER, INDEX_1 ?Key... Indexed Value. ?350 1432 1434 G ST CONDO ASSOC ?50 ABBOTT WOOD TOWNHOMES ASSOC ?70 ASPEN HEIGHT CONDO OWNERS ASSC ?80 AUTUMN RIDGE HOMEOWNERS' ASSOC ?90 BONNIE CUSACK ESTATES ASSOC ?110 BOSTON SQUARE CONDOMINIUMS ?115 BRIARCLIFF TOWNHOMES ASSOC ?130 BROOKSHIRE CONDOMINIUM ASSOC ?120 BROOKVIEW CONDOMINIUM ASSOC ?135 CAMPBELL CREEK DUPLEX OWNERS ?140 CAPE HATTERAS AT COMMODORE PRK ?170 CEDARCREST CONDO ASSOC ?175 CHANDELLE ACRES P/O ASSOC ?215 CHUGACH MEADOWS II CONDO ASSOC ?160 CHUGACH MEADOWS TOWNHOME ASSOC ?150 CHUGIAK HANGARS ASSOCIATION ?185 CLEAR CREEK CONDOMINIUM ASSOC ?190 CONCORD HILL HOMEOWNER ASSOC ?180 CREEKSIDE TWNHOMES CONDO ASSOC ?200 CREEKVIEW CONDO ASSOC ??? [N]ext Pg, [P]rev Pg, [F]irst Pg, [L]ast Pg, [A]ccept, [S]top ? I wonder if this would help? Bill By the way, I did post the LSELECT code to pickwiki, under UniQuerySource. - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 10/18/2012 6:15 AM *Subject:* Re: [U2] Selection Suggestions for using UV instead of SQL I'll have to play with this later - thanks for the info... George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, October 18, 2012 6:50 AM To: 'U2 Users List' Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Since the index files are actually type 25 files, you can always (though of course I would NEVER recommend this ... ) create a file pointer direct to the INDEX.nnn and read the entries as records ... saves grabbing a select list .. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 09:53 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 18/10/12 09:29, Martin Braid wrote: I think you mean SELECTINDEX index.name[,key.val] FROM file.var [TO list.num] Martin Followed by a READLIST ... Quite possibly - I can't remember. One *important* point to note - if you are planning to call this from an i-descriptor, as I did, don't forget you MUST save that to a non-default list, or any attempt to LIST the idescriptor will go horribly wrong... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 08:55 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 16:40, George Gallen wrote: How would I get the contents of the Index? George Don't have the UV BASIC manual in front of me, but it's something like READINDEX variable FROM filedescriptor, indexname[, indexvalue] If you only pass filedescriptor and indexname, it will return a list of all the index values. If you also pass indexvalue, it will return a list of all keys for that value. I'll have a look later and see if I can find that routine - it's probably on my system somewhere, but my archives aren't that organised... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, October 17, 2012 11:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 14:59, George Gallen wrote: Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could join the two, then do the select or use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this could be done with UV Native, and without involving a program. I first tried SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID - NSELECT PEOPLE But that returned 0 - since the NSELECT only works off the current select list, not the whole file Yes, I could
Re: [U2] Selection Suggestions for using UV instead of SQL
I use it for EQUATE names to remind me that I can't change it when I'm waist deep in a program. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, October 18, 2012 9:40 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL What is the purpose of using a $ in one of your variable names? -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Oct 18, 2012 9:24 am Subject: Re: [U2] Selection Suggestions for using UV instead of SQL George: I wrote a TREE.CHECK program that does the following: 2 Dev (0)- TREE.CHECK MASTER -IINDEX_2 Index Check: MASTER, INDEX_1 ?Key... Indexed Value. ?350 1432 1434 G ST CONDO ASSOC ?50 ABBOTT WOOD TOWNHOMES ASSOC ?70 ASPEN HEIGHT CONDO OWNERS ASSC ?80 AUTUMN RIDGE HOMEOWNERS' ASSOC ?90 BONNIE CUSACK ESTATES ASSOC ?110 BOSTON SQUARE CONDOMINIUMS ?115 BRIARCLIFF TOWNHOMES ASSOC ?130 BROOKSHIRE CONDOMINIUM ASSOC ?120 BROOKVIEW CONDOMINIUM ASSOC ?135 CAMPBELL CREEK DUPLEX OWNERS ?140 CAPE HATTERAS AT COMMODORE PRK ?170 CEDARCREST CONDO ASSOC ?175 CHANDELLE ACRES P/O ASSOC ?215 CHUGACH MEADOWS II CONDO ASSOC ?160 CHUGACH MEADOWS TOWNHOME ASSOC ?150 CHUGIAK HANGARS ASSOCIATION ?185 CLEAR CREEK CONDOMINIUM ASSOC ?190 CONCORD HILL HOMEOWNER ASSOC ?180 CREEKSIDE TWNHOMES CONDO ASSOC ?200 CREEKVIEW CONDO ASSOC ??? [N]ext Pg, [P]rev Pg, [F]irst Pg, [L]ast Pg, [A]ccept, [S]top ? I wonder if this would help? Bill By the way, I did post the LSELECT code to pickwiki, under UniQuerySource. - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 10/18/2012 6:15 AM *Subject:* Re: [U2] Selection Suggestions for using UV instead of SQL I'll have to play with this later - thanks for the info... George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, October 18, 2012 6:50 AM To: 'U2 Users List' Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Since the index files are actually type 25 files, you can always (though of course I would NEVER recommend this ... ) create a file pointer direct to the INDEX.nnn and read the entries as records ... saves grabbing a select list .. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 09:53 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 18/10/12 09:29, Martin Braid wrote: I think you mean SELECTINDEX index.name[,key.val] FROM file.var [TO list.num] Martin Followed by a READLIST ... Quite possibly - I can't remember. One *important* point to note - if you are planning to call this from an i-descriptor, as I did, don't forget you MUST save that to a non-default list, or any attempt to LIST the idescriptor will go horribly wrong... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 08:55 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 16:40, George Gallen wrote: How would I get the contents of the Index? George Don't have the UV BASIC manual in front of me, but it's something like READINDEX variable FROM filedescriptor, indexname[, indexvalue] If you only pass filedescriptor and indexname, it will return a list of all the index values. If you also pass indexvalue, it will return a list of all keys for that value. I'll have a look later and see if I can find that routine - it's probably on my system somewhere, but my archives aren't that organised... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, October 17, 2012 11:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 14:59, George Gallen wrote: Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could
Re: [U2] Selection Suggestions for using UV instead of SQL
Sort of a carry-over from VB when a string was given a variable name with a '$' in it, usually at the end, or the beginning. Habits die hard. :-) Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 10/18/2012 9:39 AM *Subject:* Re: [U2] Selection Suggestions for using UV instead of SQL What is the purpose of using a $ in one of your variable names? -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Oct 18, 2012 9:24 am Subject: Re: [U2] Selection Suggestions for using UV instead of SQL George: I wrote a TREE.CHECK program that does the following: 2 Dev (0)- TREE.CHECK MASTER -IINDEX_2 Index Check: MASTER, INDEX_1 ?Key... Indexed Value. ?350 1432 1434 G ST CONDO ASSOC ?50 ABBOTT WOOD TOWNHOMES ASSOC ?70 ASPEN HEIGHT CONDO OWNERS ASSC ?80 AUTUMN RIDGE HOMEOWNERS' ASSOC ?90 BONNIE CUSACK ESTATES ASSOC ?110 BOSTON SQUARE CONDOMINIUMS ?115 BRIARCLIFF TOWNHOMES ASSOC ?130 BROOKSHIRE CONDOMINIUM ASSOC ?120 BROOKVIEW CONDOMINIUM ASSOC ?135 CAMPBELL CREEK DUPLEX OWNERS ?140 CAPE HATTERAS AT COMMODORE PRK ?170 CEDARCREST CONDO ASSOC ?175 CHANDELLE ACRES P/O ASSOC ?215 CHUGACH MEADOWS II CONDO ASSOC ?160 CHUGACH MEADOWS TOWNHOME ASSOC ?150 CHUGIAK HANGARS ASSOCIATION ?185 CLEAR CREEK CONDOMINIUM ASSOC ?190 CONCORD HILL HOMEOWNER ASSOC ?180 CREEKSIDE TWNHOMES CONDO ASSOC ?200 CREEKVIEW CONDO ASSOC ??? [N]ext Pg, [P]rev Pg, [F]irst Pg, [L]ast Pg, [A]ccept, [S]top ? I wonder if this would help? Bill By the way, I did post the LSELECT code to pickwiki, under UniQuerySource. - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 10/18/2012 6:15 AM *Subject:* Re: [U2] Selection Suggestions for using UV instead of SQL I'll have to play with this later - thanks for the info... George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, October 18, 2012 6:50 AM To: 'U2 Users List' Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Since the index files are actually type 25 files, you can always (though of course I would NEVER recommend this ... ) create a file pointer direct to the INDEX.nnn and read the entries as records ... saves grabbing a select list .. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 09:53 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 18/10/12 09:29, Martin Braid wrote: I think you mean SELECTINDEX index.name[,key.val] FROM file.var [TO list.num] Martin Followed by a READLIST ... Quite possibly - I can't remember. One *important* point to note - if you are planning to call this from an i-descriptor, as I did, don't forget you MUST save that to a non-default list, or any attempt to LIST the idescriptor will go horribly wrong... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 08:55 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 16:40, George Gallen wrote: How would I get the contents of the Index? George Don't have the UV BASIC manual in front of me, but it's something like READINDEX variable FROM filedescriptor, indexname[, indexvalue] If you only pass filedescriptor and indexname, it will return a list of all the index values. If you also pass indexvalue, it will return a list of all keys for that value. I'll have a look later and see if I can find that routine - it's probably on my system somewhere, but my archives aren't that organised... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, October 17, 2012 11:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 14:59, George Gallen wrote: Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could join the two, then do
Re: [U2] Selection Suggestions for using UV instead of SQL
In my first programming class in high school (on apple IIe's) we liked to use G$ (with the $ pronounced as string) Colin -Original Message- From: Bill Haskett Sent: October 18, 2012 12:24 PM To: U2 Users List Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Sort of a carry-over from VB when a string was given a variable name with a '$' in it, usually at the end, or the beginning. Habits die hard. :-) Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Selection Suggestions for using UV instead of SQL
Speaking of the Apple II AppleWorks was an excellent example of the days when changing the length of a field required the entire database to be picked up and layed back down again. And if you didn't have enough room to do that, you had to write it all to 35 floppy disks and then reload them. -Original Message- From: Colin Alfke alfke...@hotmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Oct 18, 2012 11:53 am Subject: Re: [U2] Selection Suggestions for using UV instead of SQL In my first programming class in high school (on apple IIe's) we liked to use G$ (with the $ pronounced as string) Colin -Original Message- From: Bill Haskett Sent: October 18, 2012 12:24 PM To: U2 Users List Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Sort of a carry-over from VB when a string was given a variable name with a '$' in it, usually at the end, or the beginning. Habits die hard. :-) Bill ___ 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] Selection Suggestions for using UV instead of SQL
And we wonder where GIRLS came from??!? George Gallen Senior Programmer/Analyst Accounting/Data Division ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke [alfke...@hotmail.com] Sent: Thursday, October 18, 2012 2:53 PM To: 'U2 Users List' Subject: Re: [U2] Selection Suggestions for using UV instead of SQL In my first programming class in high school (on apple IIe's) we liked to use G$ (with the $ pronounced as string) Colin -Original Message- From: Bill Haskett Sent: October 18, 2012 12:24 PM To: U2 Users List Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Sort of a carry-over from VB when a string was given a variable name with a '$' in it, usually at the end, or the beginning. Habits die hard. :-) Bill ___ 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] Thomas Boadu is out of the office.
I will be out of the office starting 19/10/2012 and will not return until 22/10/2012. I will respond to your message when I return. If urgent please phone the helpdesk on 0038696 or from your handset and choose options 3 and1 First Capital Connect Limited. Registered in England Wales No. 05281077. Registered office: 50 Eastbourne Terrace, Paddington, London, W2 6LG. This message is confidential. It may not be disclosed to, or used by, anyone other than the addressee. If you receive this message in error, please advise us immediately. Internet email is not necessarily secure. First does not accept responsibility for changes to any email which occur after the email has been sent. Attachments to this email could contain software viruses which could damage your system. First have checked the attachments for viruses before sending, but you should virus-check them before opening. For more information on our range of services or to book your tickets online, please visit:- http://www.firstgroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Speeding sort
however the absolute fastest would be to add an itype to FILE-1 that
accesses FILE-2 SORT_VALUE [you're already prepared to do multiple read on
2 files ]
OTH_FILE_SORT_KEY
001 I
002 TRANS('OTHER_FILE', SOME_KEY, '', 'X') where SOME_KEY is the
value you were saving from your example below and using as key to the
second file
FANCY_ITYPE
001 I
002 OTH_FILE_SORT_KEY : '*' : SOME_KEY
etc
{you could combine these two - separated for clarity}
The index on FILE-1 remains THIS_FILE_FIELD
then
Step 1
-
SELECT FILE WITH *THIS_FILE_FIELD*='VALUE' SAVING
UNIQUE FANCY_ITYPE NO.NULLS
-- gives you a list that is complete (ie doesn't need to access the other
file again)
-- the combo key doesn't detract from the unique because the other-file
accesses are done using SOME_KEY
-- the SAVING is doing the ITYPE work, using a reduced list, thereby saving
more processing
Step 2
-
Your final step is to sort a list -- altho this represents another step, it
does not involve reprocessing a file, and therefore should be very quick.
A sort on the saved list will provide the result you were looking for...
and the field you ultimately want saved { SOME_KEY } is extractable from
FANCY_ITYPE.
Bring on the flames...
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
