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.

Advertisements

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!

    Mike

    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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: