Select & NOT LIKE doesn't work properly

[#1]

Dear all,

I did the following code but during upload the NOT LIKE sentences don't work ?

Is it a mistake on sintax or something else.

Thanks, Giovanni

SQL SELECT

P2PRENO0.P2AIP, P2PRENO0.P2NNP, P2PRENO0.P2PAR, P2PRENO0.P2STR, P2PRENO0.P2DAP, P2PRENO0.P2OAP,

P2PRENO0.RNLIB, P2PRENO0.P2NTR, P2PRENO0.P2NRP, P2PRENO0.P2DAI, P2PRENO0.P2ORI, P2PRENO0.P2AGD,

P2PRENO0.P2ORA, P2PRENO0.P2NTA, P2PRENO0.P2NPA, P2PRENO0.P2NOT, P2PRENO0.P2FFO, P2PRENO0.P2FTP,

P2PRENO0.P2TPA

AS P2TPC, P2PRENO0.P2PGA, P2PRENO0.P2SPO, P2PRENO0.P2CPR, P2PRENO0.P2PAN AS P2PAN_PREN,

P2PRENO0.P2URZ, P2PRENO0.P2RPS, P2PRENO0.P2P09

FROM

UGSD00.P2PRENO0

WHERE

P2PAN <> 'A' AND P2AIP >= 2009 AND P2AIP <= 2010 AND P2FTP <> 'I' AND

P2STR

NOT LIKE 'LB%' AND

P2STR

NOT LIKE 'DM%' AND

P2STR

NOT LIKE 'AC%'

AND P2NTR NOT LIKE 'ALESSANDRA'

AND P2NTR NOT LIKE 'AULA%'

AND P2NTR NOT LIKE 'QPADEV%'

AND P2NTR NOT LIKE 'CED%'

;

[#2]

What kind of database are you extracting from?

[#3 · Accepted solution]

Hi,

Try the following sql statement.

SQL SELECT

P2PRENO0.P2AIP, P2PRENO0.P2NNP, P2PRENO0.P2PAR, P2PRENO0.P2STR, P2PRENO0.P2DAP, P2PRENO0.P2OAP,

P2PRENO0.RNLIB, P2PRENO0.P2NTR, P2PRENO0.P2NRP, P2PRENO0.P2DAI, P2PRENO0.P2ORI, P2PRENO0.P2AGD,

P2PRENO0.P2ORA, P2PRENO0.P2NTA, P2PRENO0.P2NPA, P2PRENO0.P2NOT, P2PRENO0.P2FFO, P2PRENO0.P2FTP,

P2PRENO0.P2TPA

AS P2TPC, P2PRENO0.P2PGA, P2PRENO0.P2SPO, P2PRENO0.P2CPR, P2PRENO0.P2PAN AS P2PAN_PREN,

P2PRENO0.P2URZ, P2PRENO0.P2RPS, P2PRENO0.P2P09

FROM

UGSD00.P2PRENO0

WHERE

P2PAN <> 'A' AND P2AIP >= 2009 AND P2AIP <= 2010 AND P2FTP <> 'I' AND

P2STR

NOT LIKE 'LB%' AND

P2STR

NOT LIKE 'DM%' AND

P2STR

NOT LIKE 'AC%'

AND P2NTR NOT LIKE 'ALESSANDRA%'

AND P2NTR NOT LIKE 'AULA%'

AND P2NTR NOT LIKE 'QPADEV%'

AND P2NTR NOT LIKE 'CED%'

[#4]

Are you maybe using MySQL 5, because I know there was a bug with NOT LIKE in the past.

-Did you try this format: NOT(P2NTR LIKE 'CED%')
-Or including table names will sometimes help:
UGSD00.P2PRENO0.P2NTR NOT LIKE 'CED%

Good luck!

[#5]

AS400 DB2

Thanks

[#6]

What do you mean by "doesn't work". No results? Wrong results?

Try executing the statement with a tool other than QlikView.

[#7]

At least 'NOT LIKE' works for AS400 DB2.

Probably something else wrong with your query.

What error do you get?

[#8]

The result is that I found "also" the rows that has the "NOT LIKE" statement .

It seems that this part (where I put not like...) would be not influencing the upload.

Thanks

[#9]

It seems really the same .

Where did you modify it ?

Thanks