[U2] Uv_ioctl write failure on eval
Universe 10.3.12; windows 2003 and 2008 platform. Executing an eval statement with sql syntax from within a program that's using uniobjects to connect is consistently generating an error 'uv_ioctl: WriteFile failed with error=232'. It appears to be account based. The same code works in other accounts; and continues to fsil in this account even when i move it to another server. We've examined permissions and don't see issues. Any thoughts? (Allen - Sent from my paperweight) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] 64-Bit ODBC
It appears that the UCI problem was with Windows7. I installed the OEM Win8 Pro... on top of the Dell Win7 Pro installation... and then UCI and Windows ODBC-32 was ok... although I did not play with the ODBC-64 bit yet. I presume that the problem was related to security and rights in Win7... although the user was setup as an admin for that PC. Viva Windows 8. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] I Type Fields in Universe
It's been a while since I messed with these things so I need to ask. The I type in question is a SUBR and calls code that returns the value I want the field to have. You compile the I type and it works fine. I then need to change the code, compile the code and even re-compile the I type again, it did not work. The field acts as before the last time I compiled it. I've found the new chances will only work after I delete attributes 16 - 20 in the I type and recompile it. Is there a better/other way? - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/I-Type-Fields-in-Universe-tp41330.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Type Fields in Universe
If you are using an editor like AE. AE does not delete lines necessary like ED on Universe. Otherwise, it should work if you are just changing the UniBasic code. Regards, Doug www.u2logic.com On Tue, Jul 23, 2013 at 9:25 AM, randyleesmith randyleesm...@roadrunner.com wrote: It's been a while since I messed with these things so I need to ask. The I type in question is a SUBR and calls code that returns the value I want the field to have. You compile the I type and it works fine. I then need to change the code, compile the code and even re-compile the I type again, it did not work. The field acts as before the last time I compiled it. I've found the new chances will only work after I delete attributes 16 - 20 in the I type and recompile it. Is there a better/other way? - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/I-Type-Fields-in-Universe-tp41330.html Sent from the U2 - Users mailing list archive at Nabble.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
Re: [U2] UniData Dynamic File Splitting Question
Sorry for the delayed response. Posting was bad timing on my part because I did not have access to the college files last week. I have a copy of UI.LOG.INFO file that I last posted about. Below are 1) the unix level 2) partial GROUP.STAT and 3) guide -d3 I have also been looking at hash type 1. This file hashes about the same but I'm checking with the vendor to see if I can convert a couple of the college's files to hash type 1 to see if it prevents the splits. Thanks for any insight. C. Unix Level of UI.LOG.INFO. $ ls -al total 10370 drwxrwx--- 2 datatel users 1024 Jul 11 07:52 . drwxrwx--- 637 datatel users 34304 Jul 23 10:52 .. -rwxrwx--- 1 datatel users1073152 Jul 22 15:41 dat001 -rwxrwx--- 1 datatel users 204800 Jul 22 15:15 dat002 -rwxrwx--- 1 datatel users 94208 Jul 22 14:23 dat003 -rwxrwx--- 1 datatel users 454656 Jul 22 15:51 dat004 -rwxrwx--- 1 datatel users 82944 Jul 22 14:51 dat005 -rwxrwx--- 1 datatel users 84992 Jul 18 17:36 dat006 -rwxrwx--- 1 datatel users 109568 Jul 22 09:27 dat007 -rwxrwx--- 1 datatel users 20480 Jul 22 09:59 dat008 -rwxrwx--- 1 datatel users 23552 Jul 16 16:24 dat009 -rwxrwx--- 1 datatel users 78848 Jul 22 11:55 dat010 -rwxrwx--- 1 datatel users 150528 Jul 22 14:50 dat011 -rwxrwx--- 1 datatel users 3072 Jun 17 17:28 dat012 -rwxrwx--- 1 datatel users 24576 Jul 18 16:28 dat013 -rwxrwx--- 1 datatel users 273408 Jul 22 15:01 dat014 -rwxrwx--- 1 datatel users 10240 Jul 22 14:04 dat015 -rwxrwx--- 1 datatel users 43008 Jul 22 14:32 dat016 -rwxrwx--- 1 datatel users 205824 Jul 22 13:34 dat017 -rwxrwx--- 1 datatel users 45056 Jul 22 13:06 dat018 -rwxrwx--- 1 datatel users 139264 Jul 22 15:23 dat019 -rwxrwx--- 1 datatel users 174080 Jul 22 15:35 dat020 -rwxrwx--- 1 datatel users 77824 Jul 22 09:05 dat021 -rwxrwx--- 1 datatel users 15360 Jul 22 15:23 dat022 -rwxrwx--- 1 datatel users1735680 Jul 22 15:35 over001 -rwxrwx--- 1 datatel users 2048 Mar 7 21:17 over002 -rwxrwx--- 1 datatel users 2048 Nov 28 2012 over003 -rwxrwx--- 1 datatel users 2048 Jul 9 12:11 over004 -rwxrwx--- 1 datatel users 2048 Jun 26 07:42 over005 -rwxrwx--- 1 datatel users 2048 May 9 14:35 over006 -rwxrwx--- 1 datatel users 2048 May 14 16:57 over007 -rwxrwx--- 1 datatel users 2048 Jul 1 18:19 over008 -rwxrwx--- 1 datatel users 2048 Apr 30 10:21 over009 -rwxrwx--- 1 datatel users 2048 Apr 16 16:28 over010 -rwxrwx--- 1 datatel users 2048 Jul 22 13:19 over011 -rwxrwx--- 1 datatel users 2048 May 29 09:32 over012 -rwxrwx--- 1 datatel users 2048 Jun 6 12:06 over013 -rwxrwx--- 1 datatel users 2048 May 15 14:32 over014 -rwxrwx--- 1 datatel users 2048 Jul 11 21:17 over015 -rwxrwx--- 1 datatel users 2048 Jul 9 15:20 over016 -rwxrwx--- 1 datatel users 2048 Jul 17 09:14 over017 - GROUP.STAT - I have the entire output but thought I would start with a partial listing. I did verify that the file looks pretty much the same throughout and no empty groups. :GROUP.STAT UI.LOG.INFO File = UI.LOG.INFO modulo=3288 hash type=0 blocksize=1024 Split/Merge type = KEYONLY Grp# Bytes Records 0 314 5 1 433 7 2 244 4 3 506 8 4 381 6 5 585 9 6 430 7 7 585 9 8 80813 9 259 4 10 506 8 11 509 8 12 256 4 13 375 6 14 198 3 15 63110 16 256 4 17 250 4 18 198 3 19 494 8 20 71011 21 247 4 22 378 6 23 308 5 24 238 4 25 247 4 26 442 7 27 512 8 28 488 8 29 317 5 30 183 3 31 64310 ... 1790 73512 1791 88714 1792 109117 1793 138122 1794 127120 1795 88714 1796 88114 1797 120419 1798 564 9 1799 105217 1800 366 6 1801 133221 1802 81713 1803 88114 1804 119819 1805 75612 1806 75312 1807 93015 1808 61910 1809 118619 1810 108217 1811 94815 1812 497 8 1813 126220 1814 94515 1815 112218 1816 105817 1817 150624 1818 61010 1819 99716 1820 62510 1821 76212 1822 77112 1823 70711 1824 121319 1825 555 9 ... 3275 552 9 3276 570 9 3277 445 7 3278 329 5 3279 69511 3280 552 9 3281 564 9 3282 256 4 3283 384 6 3284 256 4 3285 436 7 3286 439 7 3287 515 8 === = 2813712 44736 Totals 128 2 Minimum in a group 173727 Maximum in a group 855.8 13.6 Averages
Re: [U2] I Type Fields in Universe
As long as you are only changing the code in the basic program, you should never need to touch the DICT. Granted, if you change the arguments in any way, that would require a recompile of the I-Desc. If you truly had to re-compile the DICT for a program change, that would strangely suggest that when you compile the I-Desc that it was somehow loading the object code of the program into the I-Desc itself. I am not doubting what you are seeing, but it sounds like there is one more piece of the puzzle that has not been identified. Are they globally or locally cataloged? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Tuesday, July 23, 2013 11:26 AM To: u2-users@listserver.u2ug.org Subject: [U2] I Type Fields in Universe It's been a while since I messed with these things so I need to ask. The I type in question is a SUBR and calls code that returns the value I want the field to have. You compile the I type and it works fine. I then need to change the code, compile the code and even re-compile the I type again, it did not work. The field acts as before the last time I compiled it. I've found the new chances will only work after I delete attributes 16 - 20 in the I type and recompile it. Is there a better/other way? - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://cp.mcafee.com/d/5fHCNAi6hESyOeovd7baby9KVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79Kl8XUz458qmDm56RLzaIundEqmDm56RLzaIundLfnT_hvW_cfcLnsWZOWtXCzDD7DSrLsJt6OaaJTAul3PWApmU6CQjqpKVKVI06SCnrx8PYqunrx93pXOdNP8UQsLZ1_Eqg87_O-1Fs4BBLbyYLfgEnB0K4Uic_6DBVHc8IITU76SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04SOCOqejpFr2qpFtd40qq80immYQg2YLfgEq89gd40jx8PYqurKrSkVt-DKA Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNASyOeovd7baby9KVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79Kl8XUz458qmDm56RLzaIundEqmDm56RLzaIundLfnT_hvW_cfcLnsWZOWtXCzDD7DSrLsJt6OaaJTAul3PWApmU6CQPqpKVKVI06vaAWv4PYurjr8Y01MjlS67OFek7qUSCnrFYq6SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04SOCOqejpFr2qpFtd40qq80immYQg2YLfgEq89gd40jx8PYqurKrYke9 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Type Fields in Universe
I used ED. If I change the code/compile code and the I type then use the field its still runs the way it did before I changed it. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/I-Type-Fields-in-Universe-tp41330p41333.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2 List Changes?
I posted two things... but did not see my own posts. Do I only see my own posts now if someone responds? Please let me know. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Type Fields in Universe
I believe we are local, we have several accounts on the system. Maybe that's the issue? I'm running in one account and pointing to the code in another to test it. (Using Catalog) - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/I-Type-Fields-in-Universe-tp41330p41336.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Type Fields in Universe
When I run in the same account and make changes to the code it works fine. So what step am I missing for doing it the other way. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/I-Type-Fields-in-Universe-tp41330p41337.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 List Changes?
Bill, Your subscription is set to receive copies of your own posts, but it's also set to avoid duplicates. This means if you copy yourself on the original post, you'll only see your direct copy, and won't see a copy from the list. If you're not copying yourself, and you're still not seeing your own posts, I'd suggest checking your mail server to make sure your posts aren't getting filtered. Sometimes spam filters will reject incoming mail with a from address of an inside email address (i.e. your address) that did not originate on your mail server. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Tuesday, July 23, 2013 9:23 AM To: U2 Users List Subject: [U2] U2 List Changes? I posted two things... but did not see my own posts. Do I only see my own posts now if someone responds? Please let me know. --Bill Brutzman ___ 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] UniData Dynamic File Splitting Question
Cinda, wow! When that 'file' is opened, at the Unix level, I believe it has to open 39 files, which is a lot of I/O - rather than a single static file - it looks like the data would be about 3,578,880 bytes plus the empty space at the end of the groups - nowhere near big enough to have to be dynamic. Your minimum number of records per group is zero, so you do have some empty groups, and your maximum number of records per group is 27, which, at an average record size of 44 bytes and a 1 K block size, would definitely put you into level 1 overflow on the groups with large numbers of records. Since the file hashes unevenly, if you are keeping the current key structure, I would increase the blocksize so that you can fit more records per group, and my personal preference would be to make the file static, with sizing something like 3733,2. You could try creating a file that size and copying the data into it - that should not take long, and then you can see how it fits. It should have ample room for growth, and you would not have the overhead of splitting groups all the time, which it seems to be doing. I did not see whether your file was KEYDATA or KEYONLY - the way it has split, I am guessing KEYDATA, but I might be wrong about that. You might try changing your split type, if you are determined to keep the file dynamic. Susan Lynch F. W. Davison Company, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cinda Goff Sent: Tuesday, July 23, 2013 12:05 PM To: U2 Users List Subject: Re: [U2] UniData Dynamic File Splitting Question Sorry for the delayed response. Posting was bad timing on my part because I did not have access to the college files last week. I have a copy of UI.LOG.INFO file that I last posted about. Below are 1) the unix level 2) partial GROUP.STAT and 3) guide -d3 I have also been looking at hash type 1. This file hashes about the same but I'm checking with the vendor to see if I can convert a couple of the college's files to hash type 1 to see if it prevents the splits. Thanks for any insight. C. Unix Level of UI.LOG.INFO. $ ls -al total 10370 drwxrwx--- 2 datatel users 1024 Jul 11 07:52 . drwxrwx--- 637 datatel users 34304 Jul 23 10:52 .. -rwxrwx--- 1 datatel users1073152 Jul 22 15:41 dat001 -rwxrwx--- 1 datatel users 204800 Jul 22 15:15 dat002 -rwxrwx--- 1 datatel users 94208 Jul 22 14:23 dat003 -rwxrwx--- 1 datatel users 454656 Jul 22 15:51 dat004 -rwxrwx--- 1 datatel users 82944 Jul 22 14:51 dat005 -rwxrwx--- 1 datatel users 84992 Jul 18 17:36 dat006 -rwxrwx--- 1 datatel users 109568 Jul 22 09:27 dat007 -rwxrwx--- 1 datatel users 20480 Jul 22 09:59 dat008 -rwxrwx--- 1 datatel users 23552 Jul 16 16:24 dat009 -rwxrwx--- 1 datatel users 78848 Jul 22 11:55 dat010 -rwxrwx--- 1 datatel users 150528 Jul 22 14:50 dat011 -rwxrwx--- 1 datatel users 3072 Jun 17 17:28 dat012 -rwxrwx--- 1 datatel users 24576 Jul 18 16:28 dat013 -rwxrwx--- 1 datatel users 273408 Jul 22 15:01 dat014 -rwxrwx--- 1 datatel users 10240 Jul 22 14:04 dat015 -rwxrwx--- 1 datatel users 43008 Jul 22 14:32 dat016 -rwxrwx--- 1 datatel users 205824 Jul 22 13:34 dat017 -rwxrwx--- 1 datatel users 45056 Jul 22 13:06 dat018 -rwxrwx--- 1 datatel users 139264 Jul 22 15:23 dat019 -rwxrwx--- 1 datatel users 174080 Jul 22 15:35 dat020 -rwxrwx--- 1 datatel users 77824 Jul 22 09:05 dat021 -rwxrwx--- 1 datatel users 15360 Jul 22 15:23 dat022 -rwxrwx--- 1 datatel users1735680 Jul 22 15:35 over001 -rwxrwx--- 1 datatel users 2048 Mar 7 21:17 over002 -rwxrwx--- 1 datatel users 2048 Nov 28 2012 over003 -rwxrwx--- 1 datatel users 2048 Jul 9 12:11 over004 -rwxrwx--- 1 datatel users 2048 Jun 26 07:42 over005 -rwxrwx--- 1 datatel users 2048 May 9 14:35 over006 -rwxrwx--- 1 datatel users 2048 May 14 16:57 over007 -rwxrwx--- 1 datatel users 2048 Jul 1 18:19 over008 -rwxrwx--- 1 datatel users 2048 Apr 30 10:21 over009 -rwxrwx--- 1 datatel users 2048 Apr 16 16:28 over010 -rwxrwx--- 1 datatel users 2048 Jul 22 13:19 over011 -rwxrwx--- 1 datatel users 2048 May 29 09:32 over012 -rwxrwx--- 1 datatel users 2048 Jun 6 12:06 over013 -rwxrwx--- 1 datatel users 2048 May 15 14:32 over014 -rwxrwx--- 1 datatel users 2048 Jul 11 21:17 over015 -rwxrwx--- 1 datatel users 2048 Jul 9 15:20 over016 -rwxrwx--- 1 datatel users 2048 Jul 17 09:14 over017 -- --- GROUP.STAT - I have the entire output but thought I would start with a partial listing. I did verify that the file looks pretty much the same throughout and no empty
Re: [U2] U2 List Changes?
Aside from this email, the only email I saw from the list from Bill as titled : 64 bit ODBC So if this was one of his two, there seems to be a missing email, If this was not one of his two, seems there is two missing emails. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Tuesday, July 23, 2013 12:57 PM To: 'U2 Users List' Subject: Re: [U2] U2 List Changes? Bill, Your subscription is set to receive copies of your own posts, but it's also set to avoid duplicates. This means if you copy yourself on the original post, you'll only see your direct copy, and won't see a copy from the list. If you're not copying yourself, and you're still not seeing your own posts, I'd suggest checking your mail server to make sure your posts aren't getting filtered. Sometimes spam filters will reject incoming mail with a from address of an inside email address (i.e. your address) that did not originate on your mail server. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Tuesday, July 23, 2013 9:23 AM To: U2 Users List Subject: [U2] U2 List Changes? I posted two things... but did not see my own posts. Do I only see my own posts now if someone responds? Please let me know. --Bill Brutzman ___ 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] I Type Fields in Universe
Do you need to recatalog? Rich Sammartino - Original Message - From: randyleesmith randyleesm...@roadrunner.com To: u2-users@listserver.u2ug.org Sent: Tuesday, July 23, 2013 11:25:33 AM Subject: [U2] I Type Fields in Universe It's been a while since I messed with these things so I need to ask. The I type in question is a SUBR and calls code that returns the value I want the field to have. You compile the I type and it works fine. I then need to change the code, compile the code and even re-compile the I type again, it did not work. The field acts as before the last time I compiled it. I've found the new chances will only work after I delete attributes 16 - 20 in the I type and recompile it. Is there a better/other way? - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/I-Type-Fields-in-Universe-tp41330.html Sent from the U2 - Users mailing list archive at Nabble.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
Re: [U2] UniData Dynamic File Splitting Question
Susan, Exactly what we are hitting. This is just a small file behaving badly but we have a couple of colleges having over 100 files acting this way. The splitting is sometimes dat, sometimes over, sometimes idx and some are a combination of 2 or all 3. We have some files that have one dat and over part and the index has split to over 100 parts. We had one file have 254 dat parts and one overflow. Once we get to the point that the application can't open that many parts, reads/writes begin to fail within the application. I went back through the GROUP.STAT output and it reports a minimum of 2 records in each group. I saw that guide reported there were zero items in a group so I don't know which is correct. I'll look into this further. The tool supplied by the vendor for helping with file maintenance doesn't do a good job with separation. We have resized many files with better modulo/separation but at the colleges affected, they soon start creeping back to their old ways of out of control splits. Several people mentioned issues with splitting issues with hash type 0. I've opened another call with the vendor to see what the impact would be to change some of these files to hash type 1 to see if it slows down the splitting. Thanks. C. -- Cinda Goff N.C. Community College System Database Administrator 919 807-7060 vRoom Link: https://sas.elluminate.com/m.jnlp?password=M.BDCC127B096D131E11EAC16A0F9473sid=2008362 E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and shall be disclosed to third parties when required by the statutes. (NCGS.Ch.132) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Lynch Sent: Tuesday, July 23, 2013 12:54 PM To: U2 Users List Subject: Re: [U2] UniData Dynamic File Splitting Question Cinda, wow! When that 'file' is opened, at the Unix level, I believe it has to open 39 files, which is a lot of I/O - rather than a single static file - it looks like the data would be about 3,578,880 bytes plus the empty space at the end of the groups - nowhere near big enough to have to be dynamic. Your minimum number of records per group is zero, so you do have some empty groups, and your maximum number of records per group is 27, which, at an average record size of 44 bytes and a 1 K block size, would definitely put you into level 1 overflow on the groups with large numbers of records. Since the file hashes unevenly, if you are keeping the current key structure, I would increase the blocksize so that you can fit more records per group, and my personal preference would be to make the file static, with sizing something like 3733,2. You could try creating a file that size and copying the data into it - that should not take long, and then you can see how it fits. It should have ample room for growth, and you would not have the overhead of splitting groups all the time, which it seems to be doing. I did not see whether your file was KEYDATA or KEYONLY - the way it has split, I am guessing KEYDATA, but I might be wrong about that. You might try changing your split type, if you are determined to keep the file dynamic. Susan Lynch F. W. Davison Company, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cinda Goff Sent: Tuesday, July 23, 2013 12:05 PM To: U2 Users List Subject: Re: [U2] UniData Dynamic File Splitting Question Sorry for the delayed response. Posting was bad timing on my part because I did not have access to the college files last week. I have a copy of UI.LOG.INFO file that I last posted about. Below are 1) the unix level 2) partial GROUP.STAT and 3) guide -d3 I have also been looking at hash type 1. This file hashes about the same but I'm checking with the vendor to see if I can convert a couple of the college's files to hash type 1 to see if it prevents the splits. Thanks for any insight. C. Unix Level of UI.LOG.INFO. $ ls -al total 10370 drwxrwx--- 2 datatel users 1024 Jul 11 07:52 . drwxrwx--- 637 datatel users 34304 Jul 23 10:52 .. -rwxrwx--- 1 datatel users1073152 Jul 22 15:41 dat001 -rwxrwx--- 1 datatel users 204800 Jul 22 15:15 dat002 -rwxrwx--- 1 datatel users 94208 Jul 22 14:23 dat003 -rwxrwx--- 1 datatel users 454656 Jul 22 15:51 dat004 -rwxrwx--- 1 datatel users 82944 Jul 22 14:51 dat005 -rwxrwx--- 1 datatel users 84992 Jul 18 17:36 dat006 -rwxrwx--- 1 datatel users 109568 Jul 22 09:27 dat007 -rwxrwx--- 1 datatel users 20480 Jul 22 09:59 dat008 -rwxrwx--- 1 datatel users 23552 Jul 16 16:24 dat009 -rwxrwx--- 1 datatel users 78848 Jul 22 11:55 dat010 -rwxrwx--- 1 datatel users 150528 Jul 22 14:50 dat011 -rwxrwx--- 1 datatel users 3072 Jun
Re: [U2] I Type Fields in Universe
It sounds to me like in the account that works, it is looking at the local copy of the program. In the account(s) that fail, it is looking at another, older piece of object code. I suggest that you go to the account(s) that are failing and type DELETE.CATALOG program. Do this several times until it says it can't find it. Then, re-catalog the program from the failed account. Be sure to catalog DIRECTly. Test this in all your accounts. The one risk to this is that if you had the program globally cataloged, then any account that was actively using THAT object code will now fail. Simply go to all your accounts and make sure you have a VOC pointer going to the desired source code. Note that you may have this condition with other programs too. This might be a good exercise to look for these when you have nothing else to do (yeah, right!) Also note that this is NOT unique to I-Desc but to any program that calls this subroutine. We use UniData so things are slightly different. However, for us, we catalog everything DIRECTly (i.e. it just builds a VOC pointer and does not put a copy of the object code in the cataloged space). This means that I technically never need to CATALOG anything so long as I manually build a VOC pointer to the desired object code. That's not really the way they want you to do it, but you get the same results. This also means that once it has been cataloged once (i.e. I have a VOC pointer pointing to the object code), I NEVER need to re-catalog. I actually find this safer. Since I never re-catalog anything (except triggers), I never make the mistake of cataloging something globally that I am expecting to be local. HTH JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Tuesday, July 23, 2013 12:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] I Type Fields in Universe When I run in the same account and make changes to the code it works fine. So what step am I missing for doing it the other way. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://cp.mcafee.com/d/k-Kr6zqb8VxYQszxMVYTsSzt5d-WdQPhOrhKyC_t5d4QsCQrEFLThKPsSzt5cQsLIIc6zATaAtYhy2AdbjH2zqTNBmfbCQdbjH2zqTNBmfbC_uj8vWb_nVBdOXbz_nKnjKejVxAQsLIzDemKzp5dl6WvaxVZicHs3jq9JcTsTsS03rjbJMAp-dfbJMAxIZV6UVAsqen-w_Qd843_Vv0QK2iOTBNunDEkbOwn2s96vzjOYRC4mmrHc8IIzK1NJJcKTjUQbAaJMJZ0kvaAWv4PYurjr8Y01dIT79CMnWhEwdbojjdbFEw3jh02iOTCy0nBVW53h1a1Ew2s96vzjPtPvAB6 Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPosrhp7cfCzAse7fCXCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCVkzLycgkxFqtokrm-cGNVsSxFqtokrm-cGNVsTXOp3_hvW_cFKnpsvWZOWtNOvccCzBZAsVORQr8FGETjVkffGhBrwqrjdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jrdNOpI5-Aq83iS4QPiWq80QQg0AIJVEw5VuuxgQgiwq80D2hDUQYTsTDUSF6LO ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Type Fields in Universe
Tried that. Only deleting attributes from the I type and recompiling works. It works fine when I do everything in the same account. (Code recompile is all I need.) It's just an issue because I'm testing in one account and have cataloged to my code in another using a Q pointer when I CATALOG. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/I-Type-Fields-in-Universe-tp41330p41344.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Type Fields in Universe
John, Thanks for the info and help. From: Israel, John R. [via U2 (UniVerse UniData)] [mailto:ml-node+s1073795n41343...@n5.nabble.com] Sent: Tuesday, July 23, 2013 1:56 PM To: randyleesmith Subject: Re: I Type Fields in Universe It sounds to me like in the account that works, it is looking at the local copy of the program. In the account(s) that fail, it is looking at another, older piece of object code. I suggest that you go to the account(s) that are failing and type DELETE.CATALOG program. Do this several times until it says it can't find it. Then, re-catalog the program from the failed account. Be sure to catalog DIRECTly. Test this in all your accounts. The one risk to this is that if you had the program globally cataloged, then any account that was actively using THAT object code will now fail. Simply go to all your accounts and make sure you have a VOC pointer going to the desired source code. Note that you may have this condition with other programs too. This might be a good exercise to look for these when you have nothing else to do (yeah, right!) Also note that this is NOT unique to I-Desc but to any program that calls this subroutine. We use UniData so things are slightly different. However, for us, we catalog everything DIRECTly (i.e. it just builds a VOC pointer and does not put a copy of the object code in the cataloged space). This means that I technically never need to CATALOG anything so long as I manually build a VOC pointer to the desired object code. That's not really the way they want you to do it, but you get the same results. This also means that once it has been cataloged once (i.e. I have a VOC pointer pointing to the object code), I NEVER need to re-catalog. I actually find this safer. Since I never re-catalog anything (except triggers), I never make the mistake of cataloging something globally that I am expecting to be local. HTH JRI -Original Message- From: [hidden email] [mailto:[hidden email]] On Behalf Of randyleesmith Sent: Tuesday, July 23, 2013 12:42 PM To: [hidden email] Subject: Re: [U2] I Type Fields in Universe When I run in the same account and make changes to the code it works fine. So what step am I missing for doing it the other way. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://cp.mcafee.com/d/k-Kr6zqb8VxYQszxMVYTsSzt5d-WdQPhOrhKyC_t5d4QsCQrEFLTh KPsSzt5cQsLIIc6zATaAtYhy2AdbjH2zqTNBmfbCQdbjH2zqTNBmfbC_uj8vWb_nVBdOXbz_nKnj KejVxAQsLIzDemKzp5dl6WvaxVZicHs3jq9JcTsTsS03rjbJMAp-dfbJMAxIZV6UVAsqen-w_Qd8 43_Vv0QK2iOTBNunDEkbOwn2s96vzjOYRC4mmrHc8IIzK1NJJcKTjUQbAaJMJZ0kvaAWv4PYurjr 8Y01dIT79CMnWhEwdbojjdbFEw3jh02iOTCy0nBVW53h1a1Ew2s96vzjPtPvAB6 Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list [hidden email] http://cp.mcafee.com/d/2DRPosrhp7cfCzAse7fCXCQrEFLThKCqejqdQkTXEFECzASzt5d-W dSrCQrEFCzBZBxwQsCVkzLycgkxFqtokrm-cGNVsSxFqtokrm-cGNVsTXOp3_hvW_cFKnpsvWZOW tNOvccCzBZAsVORQr8FGETjVkffGhBrwqrjdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqp tKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jrdNOpI5-Aq83iS4QPiWq80QQg0AIJVEw5Vuux gQgiwq80D2hDUQYTsTDUSF6LO ___ U2-Users mailing list [hidden email] http://listserver.u2ug.org/mailman/listinfo/u2-users _ If you reply to this email, your message will be added to the discussion below: http://u2-universe-unidata.1073795.n5.nabble.com/I-Type-Fields-in-Universe-t p41330p41343.html To unsubscribe from I Type Fields in Universe, click here http://u2-universe-unidata.1073795.n5.nabble.com/template/NamlServlet.jtp?m acro=unsubscribe_by_codenode=41330code=cmFuZHlsZWVzbWl0aEByb2FkcnVubmVyLmN vbXw0MTMzMHwyNTk2MDkzMg== . http://u2-universe-unidata.1073795.n5.nabble.com/template/NamlServlet.jtp?m acro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.nam espaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view. web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.n aml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail .naml NAML - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/I-Type-Fields-in-Universe-tp41330p41345.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Type Fields in Universe
If your subroutine is catalogued, just compiling it is not enough. -Original Message- From: randyleesmith randyleesm...@roadrunner.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, Jul 23, 2013 9:15 am Subject: Re: [U2] I Type Fields in Universe I used ED. If I change the code/compile code and the I type then use the field its still runs the way it did before I changed it. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/I-Type-Fields-in-Universe-tp41330p41333.html Sent from the U2 - Users mailing list archive at Nabble.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
Re: [U2] I Type Fields in Universe
You can determine if the code has been Globally Catalogued by listing the file GLOBAL.CATDIR If your subr is called MYSUBR then it will appear as *MYSUBR if globally catalogued It will appear with the account name (say PAYROLL) as PAYROLL*MYSUBR if locally catalogued And if locally catalogued from multiple accounts (say BUDGET) it will also appear as BUDGET*MYSUBR for each account in which it was locally catalogued. If you wish to globally catalog it, you can deleted all of these entries, and then recatalog it once globally from any account in which the system can detect the code. Will handing matches to children since 1985 Johnson -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Jul 23, 2013 10:55 am Subject: Re: [U2] I Type Fields in Universe It sounds to me like in the account that works, it is looking at the local copy of the program. In the account(s) that fail, it is looking at another, older piece of object code. I suggest that you go to the account(s) that are failing and type DELETE.CATALOG program. Do this several times until it says it can't find it. Then, re-catalog the program from the failed account. Be sure to catalog DIRECTly. Test this in all your accounts. The one risk to this is that if you had the program globally cataloged, then any account that was actively using THAT object code will now fail. Simply go to all your accounts and make sure you have a VOC pointer going to the desired source code. Note that you may have this condition with other programs too. This might be a good exercise to look for these when you have nothing else to do (yeah, right!) Also note that this is NOT unique to I-Desc but to any program that calls this subroutine. We use UniData so things are slightly different. However, for us, we catalog everything DIRECTly (i.e. it just builds a VOC pointer and does not put a copy of the object code in the cataloged space). This means that I technically never need to CATALOG anything so long as I manually build a VOC pointer to the desired object code. That's not really the way they want you to do it, but you get the same results. This also means that once it has been cataloged once (i.e. I have a VOC pointer pointing to the object code), I NEVER need to re-catalog. I actually find this safer. Since I never re-catalog anything (except triggers), I never make the mistake of cataloging something globally that I am expecting to be local. HTH JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Tuesday, July 23, 2013 12:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] I Type Fields in Universe When I run in the same account and make changes to the code it works fine. So what step am I missing for doing it the other way. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://cp.mcafee.com/d/k-Kr6zqb8VxYQszxMVYTsSzt5d-WdQPhOrhKyC_t5d4QsCQrEFLThKPsSzt5cQsLIIc6zATaAtYhy2AdbjH2zqTNBmfbCQdbjH2zqTNBmfbC_uj8vWb_nVBdOXbz_nKnjKejVxAQsLIzDemKzp5dl6WvaxVZicHs3jq9JcTsTsS03rjbJMAp-dfbJMAxIZV6UVAsqen-w_Qd843_Vv0QK2iOTBNunDEkbOwn2s96vzjOYRC4mmrHc8IIzK1NJJcKTjUQbAaJMJZ0kvaAWv4PYurjr8Y01dIT79CMnWhEwdbojjdbFEw3jh02iOTCy0nBVW53h1a1Ew2s96vzjPtPvAB6 Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPosrhp7cfCzAse7fCXCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCVkzLycgkxFqtokrm-cGNVsSxFqtokrm-cGNVsTXOp3_hvW_cFKnpsvWZOWtNOvccCzBZAsVORQr8FGETjVkffGhBrwqrjdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jrdNOpI5-Aq83iS4QPiWq80QQg0AIJVEw5VuuxgQgiwq80D2hDUQYTsTDUSF6LO ___ 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] UniData Dynamic File Splitting Question
Good call! -Original Message- From: Susan Lynch sly...@fwdco.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Jul 23, 2013 9:54 am Subject: Re: [U2] UniData Dynamic File Splitting Question Cinda, wow! When that 'file' is opened, at the Unix level, I believe it has to open 39 files, which is a lot of I/O - rather than a single static file - it looks like the data would be about 3,578,880 bytes plus the empty space at the end of the groups - nowhere near big enough to have to be dynamic. Your minimum number of records per group is zero, so you do have some empty groups, and your maximum number of records per group is 27, which, at an average record size of 44 bytes and a 1 K block size, would definitely put you into level 1 overflow on the groups with large numbers of records. Since the file hashes unevenly, if you are keeping the current key structure, I would increase the blocksize so that you can fit more records per group, and my personal preference would be to make the file static, with sizing something like 3733,2. You could try creating a file that size and copying the data into it - that should not take long, and then you can see how it fits. It should have ample room for growth, and you would not have the overhead of splitting groups all the time, which it seems to be doing. I did not see whether your file was KEYDATA or KEYONLY - the way it has split, I am guessing KEYDATA, but I might be wrong about that. You might try changing your split type, if you are determined to keep the file dynamic. Susan Lynch F. W. Davison Company, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cinda Goff Sent: Tuesday, July 23, 2013 12:05 PM To: U2 Users List Subject: Re: [U2] UniData Dynamic File Splitting Question Sorry for the delayed response. Posting was bad timing on my part because I did not have access to the college files last week. I have a copy of UI.LOG.INFO file that I last posted about. Below are 1) the unix level 2) partial GROUP.STAT and 3) guide -d3 I have also been looking at hash type 1. This file hashes about the same but I'm checking with the vendor to see if I can convert a couple of the college's files to hash type 1 to see if it prevents the splits. Thanks for any insight. C. Unix Level of UI.LOG.INFO. $ ls -al total 10370 drwxrwx--- 2 datatel users 1024 Jul 11 07:52 . drwxrwx--- 637 datatel users 34304 Jul 23 10:52 .. -rwxrwx--- 1 datatel users1073152 Jul 22 15:41 dat001 -rwxrwx--- 1 datatel users 204800 Jul 22 15:15 dat002 -rwxrwx--- 1 datatel users 94208 Jul 22 14:23 dat003 -rwxrwx--- 1 datatel users 454656 Jul 22 15:51 dat004 -rwxrwx--- 1 datatel users 82944 Jul 22 14:51 dat005 -rwxrwx--- 1 datatel users 84992 Jul 18 17:36 dat006 -rwxrwx--- 1 datatel users 109568 Jul 22 09:27 dat007 -rwxrwx--- 1 datatel users 20480 Jul 22 09:59 dat008 -rwxrwx--- 1 datatel users 23552 Jul 16 16:24 dat009 -rwxrwx--- 1 datatel users 78848 Jul 22 11:55 dat010 -rwxrwx--- 1 datatel users 150528 Jul 22 14:50 dat011 -rwxrwx--- 1 datatel users 3072 Jun 17 17:28 dat012 -rwxrwx--- 1 datatel users 24576 Jul 18 16:28 dat013 -rwxrwx--- 1 datatel users 273408 Jul 22 15:01 dat014 -rwxrwx--- 1 datatel users 10240 Jul 22 14:04 dat015 -rwxrwx--- 1 datatel users 43008 Jul 22 14:32 dat016 -rwxrwx--- 1 datatel users 205824 Jul 22 13:34 dat017 -rwxrwx--- 1 datatel users 45056 Jul 22 13:06 dat018 -rwxrwx--- 1 datatel users 139264 Jul 22 15:23 dat019 -rwxrwx--- 1 datatel users 174080 Jul 22 15:35 dat020 -rwxrwx--- 1 datatel users 77824 Jul 22 09:05 dat021 -rwxrwx--- 1 datatel users 15360 Jul 22 15:23 dat022 -rwxrwx--- 1 datatel users1735680 Jul 22 15:35 over001 -rwxrwx--- 1 datatel users 2048 Mar 7 21:17 over002 -rwxrwx--- 1 datatel users 2048 Nov 28 2012 over003 -rwxrwx--- 1 datatel users 2048 Jul 9 12:11 over004 -rwxrwx--- 1 datatel users 2048 Jun 26 07:42 over005 -rwxrwx--- 1 datatel users 2048 May 9 14:35 over006 -rwxrwx--- 1 datatel users 2048 May 14 16:57 over007 -rwxrwx--- 1 datatel users 2048 Jul 1 18:19 over008 -rwxrwx--- 1 datatel users 2048 Apr 30 10:21 over009 -rwxrwx--- 1 datatel users 2048 Apr 16 16:28 over010 -rwxrwx--- 1 datatel users 2048 Jul 22 13:19 over011 -rwxrwx--- 1 datatel users 2048 May 29 09:32 over012 -rwxrwx--- 1 datatel users 2048 Jun 6 12:06 over013 -rwxrwx--- 1 datatel users 2048 May 15 14:32 over014 -rwxrwx--- 1 datatel users 2048 Jul 11 21:17 over015 -rwxrwx--- 1 datatel users 2048 Jul 9 15:20 over016 -rwxrwx--- 1 datatel users 2048 Jul 17 09:14 over017
[U2] LIST reports and Fields that Do reads
Lets say you have a field that calls a subroutine. In this routine you do a read to lookup a description which it what is passed back. When you do a LIST to create a report with this field will the read be done each time? I was just wondering how the Universe system handle's this. Dose the system store the first read in it's in memory and just uses that instead of doing a read each time? -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/LIST-reports-and-Fields-that-Do-reads-tp41304.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] LIST reports and Fields that Do reads
To poke a point, let me address the issue of the field that does a read If what you mean is, that you have a dictionary entry which is an I descriptor of the SUBR type then the subroutine code is only read once and stored. If the subroutine does a BASIC READ in its own code, that read will be repeated each time its accessed because the system really has no way of knowing that it's a repeat read. If your I description only does something like a TRANS command to a file, the file pointer will be read and stored once, and then ref'ed on each subsequent touch in that query. However any underlying record in that query will be read again. So you get half and half. -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Jul 19, 2013 1:15 pm Subject: Re: [U2] LIST reports and Fields that Do reads Yes, the read will be done each time the record is LISTed (SORTed, SELECTed, etc). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Friday, July 19, 2013 4:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] LIST reports and Fields that Do reads Lets say you have a field that calls a subroutine. In this routine you do a read to lookup a description which it what is passed back. When you do a LIST to create a report with this field will the read be done each time? I was just wondering how the Universe system handle's this. Dose the system store the first read in it's in memory and just uses that instead of doing a read each time? -- View this message in context: http://cp.mcafee.com/d/5fHCNApdEIzC4T666kPtPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejsGhTN68agQJeIadHv6loYKrgQJeIadHv6loYKrtsIqejhPWb_nVBUQsII9FZuVtdCVEVVZxZVVZXBHEShjlhKVOEuvkzaT0QSyrjdTdTdw0SQOXs96vzjOXs98rfuhKep76zB_EfZ3i10_-nMaxEM2iYvmH6t2-MgbyYLfgEnCjSpseGnz-EkbPmohpKNMedJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JCUVUSqmMCCqnjh05gQo19EwzWRoPEq8dwwq81unDEkd44OuPd40tkQgh_ka6XCNmg4PG4Da_d Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/avndygQ86QmhP2rz33apKVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79Kl8XUz458qmDm56RLzaIundEqmDm56RLzaIundKKmd79EVZ5_HYOYqemm4Q-LsKCPsQsY-M-YY-ZORQr8FGETsVkffGhBrwqrjdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jrdNPNIQJxdcQKCy0axEM2jh17RGNDgQgr10Qg2YLfgEq89AZCq80WFEwz-EkdTdQm8A9a7I ___ 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] LIST reports and Fields that Do reads
The READ is executed each time, but if the record being read is in virtual memory, this second read doesn't occur at the disk level. If the file being read is relatively small (ex.: descriptions) it will probably end up in memory quick enough and not provoke performance issues. On Fri, 19 Jul 2013 20:14:38 +, Israel, John R. wrote: Yes, the read will be done each time the record is LISTed (SORTed, SELECTed, etc). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Friday, July 19, 2013 4:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] LIST reports and Fields that Do reads Lets say you have a field that calls a subroutine. In this routine you do a read to lookup a description which it what is passed back. When you do a LIST to create a report with this field will the read be done each time? I was just wondering how the Universe system handle's this. Dose the system store the first read in it's in memory and just uses that instead of doing a read each time? -- View this message in context: http://cp.mcafee.com/d/5fHCNApdEIzC4T666kPtPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejsGhTN68agQJeIadHv6loYKrgQJeIadHv6loYKrtsIqejhPWb_nVBUQsII9FZuVtdCVEVVZxZVVZXBHEShjlhKVOEuvkzaT0QSyrjdTdTdw0SQOXs96vzjOXs98rfuhKep76zB_EfZ3i10_-nMaxEM2iYvmH6t2-MgbyYLfgEnCjSpseGnz-EkbPmohpKNMedJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JCUVUSqmMCCqnjh05gQo19EwzWRoPEq8dwwq81unDEkd44OuPd40tkQgh_ka6XCNmg4PG4Da_d Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/avndygQ86QmhP2rz33apKVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79Kl8XUz458qmDm56RLzaIundEqmDm56RLzaIundKKmd79EVZ5_HYOYqemm4Q-LsKCPsQsY-M-YY-ZORQr8FGETsVkffGhBrwqrjdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jrdNPNIQJxdcQKCy0axEM2jh17RGNDgQgr10Qg2YLfgEq89AZCq80WFEwz-EkdTdQm8A9a7I ___ 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] LIST reports and Fields that Do reads
Yes, the read will be done each time the record is LISTed (SORTed, SELECTed, etc). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Friday, July 19, 2013 4:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] LIST reports and Fields that Do reads Lets say you have a field that calls a subroutine. In this routine you do a read to lookup a description which it what is passed back. When you do a LIST to create a report with this field will the read be done each time? I was just wondering how the Universe system handle's this. Dose the system store the first read in it's in memory and just uses that instead of doing a read each time? -- View this message in context: http://cp.mcafee.com/d/5fHCNApdEIzC4T666kPtPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejsGhTN68agQJeIadHv6loYKrgQJeIadHv6loYKrtsIqejhPWb_nVBUQsII9FZuVtdCVEVVZxZVVZXBHEShjlhKVOEuvkzaT0QSyrjdTdTdw0SQOXs96vzjOXs98rfuhKep76zB_EfZ3i10_-nMaxEM2iYvmH6t2-MgbyYLfgEnCjSpseGnz-EkbPmohpKNMedJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JCUVUSqmMCCqnjh05gQo19EwzWRoPEq8dwwq81unDEkd44OuPd40tkQgh_ka6XCNmg4PG4Da_d Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/avndygQ86QmhP2rz33apKVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79Kl8XUz458qmDm56RLzaIundEqmDm56RLzaIundKKmd79EVZ5_HYOYqemm4Q-LsKCPsQsY-M-YY-ZORQr8FGETsVkffGhBrwqrjdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jrdNPNIQJxdcQKCy0axEM2jh17RGNDgQgr10Qg2YLfgEq89AZCq80WFEwz-EkdTdQm8A9a7I ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users