sql not retuning column using DB2 data reader

48900 pts.
Tags:
AS/400
AS/400 and SQL
AS/400 DB2
i series
SQL
SQL Server
Strange one. I have a user that created a database file using WRKQRY. In this file is a user defined result field. Its basically a text label stating the build level  'LVL01'. After all levels are run (11 total) the file is complete. I am trying to access this data using a .NET program and a iDB2 connection. I have a window where the user keys in the SQL to get the data. It's using a data reader to build a grid view and returns all columns from the file but this one containing the build level. Running this SQL "select * from buildfile" in the window fails but log on to the i-Series where the file is located and STRSQL and enter the same command it shows all columns??

Software/Hardware used:
SQL server , i-Series

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: