Sorting of null values in Powerhouse

[Ken Langendock]

I don’t think you have much choice.

 

You either use a DEFINE before the SORT, which doesn’t impact performance
very much.

Or 

If you have a QTP extract, you could use an ITEM fieldname FINAL “ “ if NULL
EQ fieldname OF subfile

 

Ken

 

From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Dan Lambshead
Sent: February 24, 2009 9:17 AM
To: powerh-l at lists.sowder.com
Subject: Sorting of null values in Powerhouse

 

Hello,

 

  Does anyone know if there is an option to sort null values so that they
appear at the top (in Oracle, as they would if they were spaces, as
previously we had in indexed files) rather than the bottom. This is for
OpenVMS and Powerhouse version 8.40.D1.

  Of course we could do a define, setting nulls to spaces and sort on that,
but still wondering if there is an easier way.

 

Thanks

 

Dan

 

No virus found in this incoming message.
Checked by AVG.
Version: 7.5.552 / Virus Database: 270.11.3/1968 - Release Date: 23/02/2009
6:22 PM


No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.552 / Virus Database: 270.11.3/1968 - Release Date: 23/02/2009
6:22 PM
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20090224/69eb5dc2/attachment.htm