• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization S3 Customization/Development

Index filter using "LIKE"

 2 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Anur
Basic Member Send Private Message
Posts: 6
Basic Member
4/9/2009 9:51 AM

Index filter was working fine untill I added the LIKE condition after which it started giving runtime error.

Can someone tell me what is missing

Code snippet

         STRING
           " (M10-PROC-FL NOT = 'SP' )"    DELIMITED BY SIZE
           " AND (M10-PT-CODE  LIKE '275700%'  ) "
                                                  DELIMITED BY SIZE
           " AND (M10-ALL = 1) "                DELIMITED BY SIZE
                                            INTO FILTER-STRING.
            PERFORM 890-CREATE-FILTER.

Error message from job log

                Execution error : file 'mfini'
                error code: 119, pc=0, call=1, seg=0
                119     Name is not unique (binding symbol 'mfini')

                890-CREATE-FILTER: error at FILTER-STRING(74)
                    illegal character '%'.
                    FILTER-STRING context:

PKS
Advanced Member Send Private Message
Posts: 23
Advanced Member
4/10/2009 9:44 AM

Try assigning '275700%' to a Variable and use it

Replace the second line with

AND (M10-PT-CODE LIKE ? )

Add these lines after CREATE-FILTER

MOVE TO ALPHANUM-FILTER-VALUE.
PERFORM 890-SET-ALPHANUM-FILTER-VALUE.

Anur
Basic Member Send Private Message
Posts: 6
Basic Member
4/10/2009 3:22 PM
Thanks,
Will try that