Sorting of null values in Powerhouse

[Lloyd, Gavin]

Dan,

 

1 option, which you may consider a little outlandish, would be to not
create null values in the field in the first place.  You can set an
initial value of space at the database level.  You would of course loose
the ability to query on nulls using SQL, etc but it would resolve your
sort issue.  Your decision as to whether the change is worth the effort!

 

Regards,
Gavin.

 

From: Ken Langendock [mailto:ken.langendock at rogers.com] 
Sent: 24 February 2009 15:29
To: 'Dan Lambshead'; powerh-l at lists.sowder.com
Subject: RE: Sorting of null values in Powerhouse

 

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


 
Registered No. 755780 England
Registered Office: FM Insurance Company Limited
1 Windsor Dials, Windsor,
Berkshire, UK, SL4 1RS
Regulated by the Financial Services Authority.
VAT No. G.B.: 792 4276 02
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20090225/62466830/attachment.htm