new feature request - user defined functions

Deskin, Bob Bob.Deskin at Cognos.COM
Wed Sep 5 12:18:28 CDT 2007


I do see the value of some form of user defined function as part of an
expression so I'm not debating that. All I'm saying is that you can do
something like that in QUICK already via the DO EXTERNAL. Maybe not as
convenient, but in most cases it can get the job done.
 
As for two versions of QUIZ, it's a question of what sort of access the
user has. Others have pointed out that you can already access stored
procedures so restricting access to a user-written function is a little
late. Point taken.
 
Bob


________________________________

	From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com] On
Behalf Of Joe Boyle
	Sent: September 5, 2007 10:03 am
	To: Robert Mills
	Cc: powerh-l at lists.sowder.com
	Subject: Re: new feature request - user defined functions
	
	
	i think that a define is'nt actually asigned a value until it is
referenced,
	 
	define mydefine = 'item returned from do ext' ;...( defined item
mydefine contains nothing )
	 
	if mydefine = .... ( defined item mydefine now contains value in
'item returned from do ext' )

		----- Original Message ----- 
		From: Robert Mills
<mailto:robert.mills at pinnaclearvato.co.uk>  
		To: Deskin, Bob <mailto:Bob.Deskin at cognos.com>  
		Cc: powerh-l at lists.sowder.com 
		Sent: Wednesday, September 05, 2007 9:00 AM
		Subject: RE: new feature request - user defined
functions

		Bob,
		 
		The problem with Quick's DO EXTERNAL is that you have to
call it within a procedure. What if you need to load a define with the
data returned from an external routine?
		 
		Why would you need two versions of Quiz?
		 
		regards,
		 
		Robert W.Mills
		Business Systems Development Analyst
		Group Information Systems & Technology
		Pinnacle Arvato
		DDI: +44 (0)20 8309 3604 

		 

________________________________

		From: Deskin, Bob [mailto:Bob.Deskin at Cognos.COM] 
		Sent: 04 September 2007 14:48
		To: Robert Mills
		Cc: powerh-l at lists.sowder.com
		Subject: RE: new feature request - user defined
functions
		
		
		QUICK can access any library via DO EXTERNAL. It's a lot
easier to do that than to force a specific format on the developer. As
well, external calls are different on each platform and with DO
EXTERNAL, you can have a generic format or close if you care.
		 
		As for QUIZ, we've always been torn because of QUIZ's
nature as a read-only product plus the fact that it is often used by end
users. We'd have to provide two versions, one with and one without.
		 
		Bob


________________________________

			From: Robert Mills
[mailto:robert.mills at pinnaclearvato.co.uk] 
			Sent: August 31, 2007 9:58 am
			To: Deskin, Bob
			Cc: powerh-l at lists.sowder.com
			Subject: RE: new feature request - user defined
functions
			
			
			Allow Quick, Quiz and Qtp to call a user defined
function that is defined within a library.
			 
			An example of it's use would be for check digit
calculation/validation and encryption/decryption routines. Both here and
at previous sites I implemented the code in USE files. This was fine
with the check digit routines but not the encryption routines as the
encryption method and key(s) were easily seen (we had to roll our own
encryption routines as the auditors were after something stronger).
			 
			This feature would also enable the developer to
include the mathematical functions (sin, cos, tan, etc.) that have not
been implemented in PowerHouse.
			 
			regards,
			 
			Robert W.Mills
			Business Systems Development Analyst
			Group Information Systems & Technology
			Pinnacle Arvato
			DDI: +44 (0)20 8309 3604 

			 

		 
		     This message may contain privileged and/or
confidential information.  If you have received this e-mail in error or
are not the intended recipient, you may not use, copy, disseminate or
distribute it; do not open any attachments, delete it immediately from
your system and notify the sender promptly by e-mail that you have done
so.  Thank you. 

		
________________________________


		

		-- 
		= = = = = = = = = = = = = = = = = = = = = = = = = = = =
		Mailing list: powerh-l at lists.sowder.com
		Subscribe: &quot;subscribe&quot; in message body to
powerh-l-request at lists.sowder.com
		Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in
message body to powerh-l-request at lists.sowder.com
		http://lists.sowder.com/mailman/listinfo/powerh-l
		This list is closed, thus to post to the list you must
be a subscriber.
		Add 'site:lists.sowder.com powerh-l' to your search
terms to search the list archive at Google.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070905/2e4ccc77/attachment.html


More information about the powerh-l mailing list