Hi Chris, I believe there is the IF S or the IF #S construct that you can use in a proc to test the existence or otherwise of a select list. So if you modify your proc: HSSELECT AR WITH PAYMENT.DATE GE "2-9-04" STON P HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H< PH IF #S G 10 HLIST AR PAYMENT.DATE LPTR P 10 O No items Selected that should save a few trees..... cheers, asvin "Chris Bugosh" <[EMAIL PROTECTED] on 03 Feb 2004 13:51 Please respond to U2 Users Discussion List <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] To: <[EMAIL PROTECTED]> cc: bcc: Subject: [UD]Determining if list exists Is there a Unidata or Uniquery command that tells you if a select list exists? In UniBasic I can use a SelectInfo function to determine if a list exists, but I can't find a way to do it at the TCL prompt. I have the following PQN PROC. The PROC itself works fine if there is something to return from the selection criteria. However, if nothing is selected in the SELECT statement (like the one below would if we ran it today), the PROC does what it is told and lists the whole file, since it is never given a list, resulting in a huge printout of every AR transaction. HSSELECT AR WITH PAYMENT.DATE GE "2-9-04" STON P HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H< PH HLIST AR PAYMENT.DATE LPTR P Thanks for any suggestions you can give. Chris ****************************************************************** This message originated from the Internet. Its originator may or may not be who they claim to be and the information contained in the message and any attachments may or may not be accurate. ****************************************************************** (See attached file: C.htm) _______________________________________________ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ************************************************************ HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and Regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. ************************************************************ _____________________________________________________ This transmission has been issued by a member of the HSBC Group "HSBC" for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy.Title: [UD] Determining if list exists
Is there a Unidata or Uniquery command that tells you if a select list exists? In UniBasic I can use a SelectInfo function to determine if a list exists, but I can't find a way to do it at the TCL prompt.
I have the following PQN PROC. The PROC itself works fine if there is something to return from the selection criteria. However, if nothing is selected in the SELECT statement (like the one below would if we ran it today), the PROC does what it is told and lists the whole file, since it is never given a list, resulting in a huge printout of every AR transaction.
HSSELECT AR WITH PAYMENT.DATE GE "2-9-04"
STON
P
HSAVE-LIST ARLIST
P
HGET-LIST ARLIST
STON
H<
PH
HLIST AR PAYMENT.DATE LPTR
P
Thanks for any suggestions you can give.
Chris
******************************************************************
This message originated from the Internet. Its originator may or
may not be who they claim to be and the information contained in
the message and any attachments may or may not be accurate.
******************************************************************
_______________________________________________ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
