NOT LIKE SQL statement in business fonction ??

[akkakm]

Hi EveryOne,
Is there any way to use the (NOT LIKE) SQL statement in business function "c", the only statement that can see in OneWolrd Xe is JDEDB_CMP_LK (LIKE).

My select query is : Select * from PRODDTA.F4211 T0, PRODDTA.F42119 T1
Where T0.SDDOCO = T1.SDDOCO
and T0.SDDCTO = T1.SDDCTO
and T0.SDKCOO = T1.SDKCOO
and T0.SDLNID = T1.SDLNID
and T0.SDLNTY NOT LIKE ('S%')
and T0.SDLTTR = '980'
and T0.SDNXTR = '999'

Thanks in advance
Mo - Developper OneWorld Xe
Update 2, SP22, Oracle

 

[Alex_Pastuhov]

Interestigly (or, rather, sadly), no.

There're "NOT IN" and "NOT BETWEEN", which you may be able to use instead, though.

 

[arrozpegao]

Look the definition code
=0D
typedef enum tagJDEDB_CMP {
JDEDB_CMP_LE =3D 0, /* <=3D */
JDEDB_CMP_GE =3D 1, /* >=3D */
JDEDB_CMP_EQ, /* =3D=3D */
JDEDB_CMP_LT, /* < */
JDEDB_CMP_GT, /* > */
JDEDB_CMP_NE, /* !=3D */
JDEDB_CMP_IN, /* IN */
JDEDB_CMP_NI, /* NOT IN */
JDEDB_CMP_BW, /* BETWEEN */
JDEDB_CMP_NB, /* NOT BETWEEN */
JDEDB_CMP_LK, /* LIKE */
JDEDB_CMP_BOGUS =3D 99999 /* force 4 byte ENUM on AS/400 */
} JDEDB_CMP;

 

[akkakm]

Thanks for your reply,
NOT IN it may be the solution, but my problem I don't know how to feed my list. I want to use all S* in the UDC table 00/DT (S0, S1, S2, S3, ...) right now we have aproximately 37 code, do you think that I hard code them as an array [37][3], may be is a solution but I found it a little bit weird, the best is to read all UDC code 00/DT (S*) than put them in the list and use NOT IN.

Any Idea are welcomed

Thanks
Mo - Developper OneWorld Xe
Update 2, SP22, Oracle 9.2

 

[Alex_Pastuhov]

I think, something like "NOT BETWEEN 'S0' and 'S9'", or similar, would be the best choice.

 

[akkakm]

Thanks Alex for your idea, I think is the best...

Mo - Developper OneWorld Xe
Update 2, SP22, Oracle 9.2