Debug SQL queries in SQuirrel-sql

Question

How do I go about debugging a SQL statement in SQuirrel-sql?

I keep getting "unhelpful" errors like:

Error: [SQL0104] Token , was not valid. Valid tokens: ) OR.
SQLState:  42601
ErrorCode: -104

I would love to be able to see the line number where I made the error, or some other way of guiding me to where the problem is.

I am working with the JDBC driver on a IBMi DB2 database.

James Allman · Accepted Answer · 2011-11-28 18:45:30Z

3

You can add the "errors=full" property for more detailed error messages although it will still require some interpretation to locate the precise syntax issue.

See the IBM Toolbox for Java JDBC properties for more information.

As Tracy mentioned if you want interactive syntax checking you will have to use one of the native SQL interfaces such as the green screen Start SQL Interactive Session (STRSQL) command or the IBM i Access Run SQL scripts tool.

answered Nov 28, 2011 at 18:45

James Allman

41.3k11 gold badges59 silver badges70 bronze badges

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

1 Comment

Christoff Erasmus Over a year ago

Thanks its giving a little more useful info.

Tracy Probst · Accepted Answer · 2011-11-28 14:22:06Z

2

For such errors where the problem isn't obvious, I like to copy and paste the SQL into the AS/400's green screen interactive SQL tool. (I'm assuming your database server is an AS/400 based on your tag and the mention of IBMi DB2.) The command is STRSQL. When there's an error, it will put your cursor right where the problem is. Or, more specifically, where it thinks the problem is. It does require green screen access to the AS/400.

answered Nov 28, 2011 at 14:22

Tracy Probst

1,87912 silver badges14 bronze badges

1 Comment

Christoff Erasmus Over a year ago

Thanks, I have used STRSQL. The "copy and paste the SQL into the AS/400's green screen" is not as easy as you make it out. For longer statements you need to copy multiple "chunks" of code. And editing with out an "Undo" button is not for me. (Another option would be RUNSQLSTM and looking at the DSPJOBLOG and then maybe SPLF)

Collectives™ on Stack Overflow

Debug SQL queries in SQuirrel-sql

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related