Why do I get an SyntaxErrorException while executing query on DB2?

Question

I tried to get the countries beginning with L, however I get an error when I try to use the WHERE COUNTRY INTO 'L%' statement.

String sql = "SELECT COUNTRY, LER "  
 + "FROM CENSUS.WORLDIMR "    
 + "WHERE COUNTRY INTO 'L%'";

I recieve the following exception:

com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-199, SQLSTAT
E=42601, SQLERRMC=INTO;??( [ CONCAT || / MICROSECONDS MICROSECOND SECONDS SECOND
, DRIVER=4.18.74

It's definitely something wrong with WHERE COUNTRY INTO 'L%'. I had the same problem with COBOL. Adding 29 times % fixed it but this time it's different.

Keammoort · Accepted Answer · 2015-12-15 23:37:00Z

3

I believe you need to use LIKE operator:

SELECT COUNTRY, LER FROM CENSUS.WORLDIMR WHERE COUNTRY LIKE 'L%';

answered Dec 15, 2015 at 23:37

Keammoort

3,06517 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why do I get an SyntaxErrorException while executing query on DB2?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related