FW: [Bulk] RE: [Bulk] Powerhouse fatal error

[o.kappert at qc.aibn.com]

depending upon the logic of the process, the lookup need only be done 
once per key; instead of every time.

This goes for every 'optional' statement.

olav.

Ken Langendock wrote:

> Then move whatever files are not required in the MASSIVE record 
> complex into an OUTPUT PHASE READ.
>
>
> Assuming PROD-GROUP is simply a reference file to obtain some 
> description you can move it after the SORT statement and before your 
> SUBFILE like this:
>
>  
>
>  
>
> OUTPUT PROD-GROUP &
>
>        ADD &
>
>        UPDATE &
>
>        NOITEMS &
>
>        IF 1 EQ 2 &
>
>        VIA   PROD-GR-CODE &
>
>        USING D-PROD-GR-CODE OF JD0221Z1
>
>  
>
> This will read the record at the output phase of each record, getting 
> a nice new record for each one...and will NOT make the record complex 
> incredibly large for the SORT statement to have to deal with
>
>  
>
> Ken
>
>  
>
>  
>
> From: Grace, Ron (Chipping Sodbury) UK [mailto:Ron.Grace at hanson.biz]
> Sent: September 14, 2011 9:32 AM
> To: Ken Langendock
> Subject: [Bulk] RE: [Bulk] Powerhouse fatal error
>
>  
>
> The program is run uncompiled
>
>  
>
> The piece of code runs ok in Quiz, but bombs in QTP
>
>  
>
> ------------------------------------------------------------------------
>
> From: Ken Langendock [mailto:ken.langendock at rogers.com]
> Sent: 14 September 2011 14:31
> To: Grace, Ron (Chipping Sodbury) UK; powerh-l at lists.sowder.com
> Subject: RE: [Bulk] Powerhouse fatal error
>
> I get this all the time on windows.
>
> Delete the executable already out there and recompile.
>
> The other option you can consider is moving the OPTIONAL linkages to 
> OUTPUT PHASE READS.
>
>  
>
> 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 Grace, Ron (Chipping Sodbury) UK
> Sent: September 14, 2011 9:23 AM
> To: powerh-l at lists.sowder.com
> Subject: [Bulk] Powerhouse fatal error
>
>  
>
> Afternoon listers,
>
>  
>
> I'm running the following code on a HP3000 using MPEIX and after 
> adding the new file linkage at the bottom of the access statement it's 
> started  bombing out. I checked the fields I'm linking and both are 2 
> characters in length. PROD-GR-CODE is a key/index field of the 
> SAPSCEZ9 subfile. I have also checked the file equations for the 
> subfiles and they all exist and in the correct locations. Am I missing 
> something obvious?
>
>  
>
> Ron
>
>  
>
>> REQUEST EXTRACT_DATA
>
>>
>
>> ACCESS *JD0221Z1 &
>
>>   LINK ("UN" + UNIT-CODE-X OF JD0221Z1) TO MQ-KEY OF MQ-TEXT OPTIONAL &
>
>>   LINK D-PROD-CODE OF JD0221Z1 TO PROD-CODE OF PRODUCTS OPTIONAL &
>
>>   LINK D-DOC-NO TO AJ-NUMBER OF AJ-TOTAL OPTIONAL &
>
>>   LINK AJ-KEY TO AJ-KEY OF AJ-DETAIL OPTIONAL &
>
>>   LINK D-PROD-GR-CODE OF JD0221Z1 &
>
>>     TO PROD-GR-CODE OF PROD-GROUP OPTIONAL &
>
>>   LINK D-DELPNT-X TO DELPNT-CODE-X OF DELPNTS OPTIONAL &
>
>>   LINK D-PROD-CODE OF JD0221Z1 TO PROD-CODE OF PRODUCTS-EXTRA OPTIONAL &
>
>>   LINK D-PROD-CODE OF JD0221Z1 TO PROD-CODE OF *SAPSCEZ8 OPTIONAL &
>
>> ;A.01.005 Start
>
>>   LINK D-PROD-GR-CODE OF JD0221Z1 TO PROD-GR-CODE OF &
>
>>   *SAPSCEZ9 OPTIONAL
>
> Code Trap :
>
>   01634010227
>
>   00003044033
>
>   00000001442
>
>   00000000017
>
> *E* Memory fault (invalid address).
>
> *Fatal Error* *1370* Notify Cognos Customer Support
>
>  
>
>  
>
>   ________________________________  
>
> Each of Hanson Aggregates, Hanson Aggregates UK, Hanson Bath & 
> Portland Stone, Hanson Construction Projects, Hanson Contracting, 
> Hanson Premix, Hanson Recycling, Ashbridge Concrete and Supamix is a 
> trading name of Hanson Quarry Products Europe Limited. Hanson Quarry 
> Products Europe Limited is a private limited company incorporated in 
> England and Wales with registered number 00300002 and with registered 
> address Hanson House, 14, Castle Hill, Maidenhead, Berkshire
>
> Hanson Quarry Products Europe Limited is a member of the 
> HeidelbergCement Group.
>
>  
>
>   ________________________________  
>
> This e-mail and any attachment transmitted with it are confidential 
> and are intended for the named person's use only. The contents of the 
> e-mail may contain sensitive and private or legally privileged 
> information. If you have received this e-mail in error, please delete 
> it (and any attachment) from your system and notify the sender 
> immediately. You should not retain, copy or print the contents of this 
> e-mail (or any attachment) nor should you, directly or indirectly, 
> disclose or distribute the contents to anyone.
>
>------------------------------------------------------------------------
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: 'unsubscribe <password>' 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/20110914/559eab1b/attachment.htm>