Himu\’s Attempt at Blogging

Tidbits from my thoughts

iSeries, Oracle Reports 10g and ODBC-JDBC

with one comment

I’ve been pulling my hair on this issue:

A complex sql with subqueries and a union written and executed OK in iSeriese Navigator for V5R4. Then I copied and pasted the same SQL in the query definition window of Oracle Reports Builder JDBC query dialog. The connection to iSeries is through the JDBC-ODBC bridge driver. I put :P_xxx parameters in the query.

Guess what? I got an error ‘Variable P_xxx not defined or not usable’.

Earlier, I tested using a simple query with a parameter and it worked fine. After a lot of head-scratching and trial-and-error, finally I got the solution:

Place a blank/space (‘ ‘) around the parameter(s) even if it is at the end of a line (not query)!

The parser seems to stumble upon detecting tokens without spaces.


Written by mhimu

February 3, 2009 at 12:02 pm

Posted in Uncategorized

One Response

Subscribe to comments with RSS.

  1. Just passing by.Btw, you website have great content!

    Don’t pay for your electricity any longer…
    Instead, the power company will pay YOU!


    March 3, 2009 at 1:33 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: