Select statement on an Item in the Dictionary

Deskin, Bob Bob.Deskin at Cognos.COM
Tue Oct 16 10:08:32 CDT 2007


The syntax and processing requires a specific single value that is a
positive match. PDL does not provide any expression processing. So the
answer is no, not at this time. 

Bob

-----Original Message-----
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 Lowe, Chuck J
Sent: October 16, 2007 10:42 am
To: powerh-l at lists.sowder.com
Subject: Select statement on an Item in the Dictionary

I know you can use a SELECT statement in the dictionary on an ITEM.  I
can use an actual value and even a blank (in quotes). 
But there has to be a value in it.  Is there anyway to say SELECT if the
field is Not Blank?  We have a file that has blanks and not blank in
them.  The not blanks are many and can be any value, hence my question.
I.E., I would constantly be changing the dictionary to have
redefinitions for all the values.

Please don't reply with you can say SELECT if ITEM <> " " in Quiz, QTP
etc. I already know that. 

Chuck Lowe
Senior Programmer/Analyst
Office: (610)650-6679
Fax:    (610)650-2114

------------------------------------------
The contents of this message, together with any attachments, are
intended only for the use of the person(s) to which they are
addressed and may contain confidential and/or privileged
information. Further, any medical information herein is
confidential and protected by law. It is unlawful for unauthorized
persons to use, review, copy, disclose, or disseminate confidential
medical information. If you are not the intended recipient,
immediately advise the sender and delete this message and any
attachments. Any distribution, or copying of this message, or any
attachment, is prohibited.

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
 
     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.



More information about the powerh-l mailing list