Question in QTP

eric_therrien@cgtx.ca eric_therrien@cgtx.ca
Tue, 27 Oct 98 09:34:34 -0500


Well, me again...

The probleme I was facing when I quitted yesterday is still there... I seem to
be having a problem with SORT in QTP, which by the way is version 5 on MPE/iX.
Consider the following code :

> REQUEST EXTRACT1                                    
>                                                     
> SET INPUT LIM 1000000                               
>                                                     
> ACC WRO-MASTER                                      
>  TEMP NB-CAR NUM*8                                  
>  TEMP TYPE   CHAR*1                                 
>                                                     
> SORT ON WRO-CAR-NUMBER                              
>                                                     
> SUBFILE TEMP IF 1 = 2 &                             
>  INCLUDE NB-CAR, TYPE, WRO-CAR-NUMBER, WRO-NUMBER   
>                                                     
> OUTPUT *TEMP ALIAS T1 ADD                           
>  ITEM NB-CAR         COUNT ;RESET AT WRO-CAR-NUMBER 
>  ITEM TYPE           = "A"                          
>  ITEM WRO-CAR-NUMBER FINAL WRO-CAR-NUMBER           
>  ITEM WRO-NUMBER     FINAL WRO-NUMBER               

When I put the sort in comment, it work, I get the records, but when it's not in
comment, it doesn't return anything in the subfile. The reason I'm doing it like
that is that I wish to add other OUTPUT statement at the end of the SORT level
to fill in the blank of my invoive.

I don't get it, can we or can't we use SORT?

As I was typing this, I was running the QTP (with the SORT) and got a strange
error :

Executing request EXTRACT1 ...                                         
-----------------------------------------------------------------------
There was a SORT error in COGSORT.                                     
-----------------------------------------------------------------------
INVALID FILE NUMBER  (FSERR 72)                                        
   File:  TEMP                                                         
                                                                       
Action Taken: Run terminated.                                          
-----------------------------------------------------------------------
                                                                       
Records read:                                                          
  WRO-MASTER                   124,799                                 
                                                                       
Transactions processed:              0                                 
                                                                       
Records processed:               Added    Updated  Unchanged    Deleted
  TEMP                               0          0          0          0
  T1                                 0          0          0          0

Now what!?!

Thank you, I'm really confuse now!

Eric Therrien, analyst-programmer, IT



= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.