Not begins with

[Namasiva]

Hi All,

For a program i need to know how i can find all ld_det records where ld_status does not begins "Rej"

I have createdthe script like below

For each ld_det where ld_domain = global_domain
and ld_part = wod_part
and ld_site = wo_site
and ld_status <> "reject"no-lock:

With this statement also the records with status "Rejcted" and "RejectDown" are taken into output but this is not needed.
i need to exclude all ld_status which not begins with "Rej"

Thanks in advance

 

[Kishor Chari]

Not Possible.
You need to specify each one of them using <> or index function = 0.

 

[jongpau]

Try this:

[FONT=Courier New]For each ld_det where ld_domain = global_domain [/FONT]
[FONT=Courier New][SIZE=2]and ld_part = wod_part[/SIZE] [/FONT]
[FONT=Courier New][SIZE=2]and ld_site = wo_site[/SIZE] [/FONT]
[FONT=Courier New][SIZE=2]and not ld_status begins "reject" no-lock:[/SIZE][/FONT]

HTH

Paul

 

[Namasiva]

It works Thanks for your kind help.