Re: DCOUNT in DICT, Which Correlative?

Wed, 20 Jul 2011 11:33:12 -0700

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 [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

Reply via email to