Re: DCOUNT in DICT, Which Correlative?

[Charlie Noah]

Why? Charlie Noah On 07-21-2011 8:38 AM, Mark Hogden wrote: If you are planning on migrating to 5.2.X, you would be well served by converting all your correlatives to I-TYPES. -----Original Message----- From: jbase@googlegroups.com [mailto:jbase@googlegroups.com] On Behalf Of inavran Sent: Thursday, July 21, 2011 1:34 AM To: jBASE Subject: Re: DCOUNT in DICT, Which Correlative? Hi Charlie, I haven't done a performance test, but I've been informed by Dan Klein (who has helped me alot in the past, and i trust) that calling a global subroutine within an I-Type dictionary will perform much better than using a A-type; 008: CALL mysub or 008:B;mysub (which ive found very slow in the past, and therefore wont use), i sure Jim will say if im right or wrong? Those PDFs i found on the web has been very informative reading. Its not specific to jBASE, but alot of the commands work, and it filled in alot of gaps to do with A-type DICTs Here's a link to a public goggle docs share : http://tinyurl.com/3vly68j I dont think i will be putting the time in to test it out, as we will be migrating to jb 5.2.x in the coming months (ive been saying that for 6 months already though!). jb3 has served us well, but its time to move on. Do you have any plans to migrate soon? Ian On Jul 20, 7:32 pm, Charlie Noah <cwn...@comcast.net> wrote: Hi Ian, I'd love to get a copy of that PDF. Let us know where you end up putting it so I can grab a copy. Have you done a performance test to determine if the subroutine is faster or slower than the I-descriptor with COUNT? I'd be very interested in your results. I'm glad to know I'm not the only one still running 3.x. Thanks, Charlie On 07-20-2011 11:57 AM, inavran wrote:Thanks everyone for your comments. I did put this to devsup as well and with help from Dan Ell & Dan Klein, a more elegant solutions was found. Thanks for both of them as well. see below. Dan Ell's First offered this solution using an I descriptor 001 I 002 DCOUNT(@RECORD<1>,’,’) 003 004 Commas in 1 005 8R 001 I 002 DCOUNT(@RECORD<3>,@VM) 003 004 VM in 3 005 8R This didn't work for me first time (as DCOUNT subroutine doesn't exist on jBASE 3.x, Dan thought i was running jb4/5) Dan Klein, then kindly suggested all i needed to do was to create the DCOUNT sub, and catalog it so it would be available system-wide 001 SUBROUTINE DCOUNT(result, param1, param2) 002 result = DCOUNT(param1, param2) 003 RETURN This did the trick nicely.... Over to Jim's point. Im sorry, but with respect, i think you've got completely wrong end of the stick. If i was storing information for db purposes it would be a terrible model, the fact is, i was storing it as a quick dirty report i needed (that i was too lazy to write another program for, when i just wanted a quick ref count on how many MVs i had from each key. (ie the majority would be a count of 1 and a small few would be > 1), i would simply then select the keys > 1 and see what sort of data set i was dealing with. I put the commas count eg in as literally an example (be it a very bad example in hindsight) - nothing else. I would never store multiple values separated by commas in a data model. (even if i did, i wouldn't be silly to mention it on this a board)... Thanks for your reply though, a always enjoy reading your posts :) Charlie, i found an excellent 4 page pdf (scrapped off the spectrum website years ago), which describes in detail all the DICTs & ACCESS commands (similar to JQL). It lists all TCL commands and uses of correlatives (for A types not I) If anyone would like a copy of it, let me know and i can put it on a public dropbox link. Ian -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines   IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24   To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en