I have created an Access target in iWay Service Manager 6. I then create a statement which is a select on a table named "My_Table". When I do a Test Run, it gives me an error b/c it's converting the table name to My Table. The iwaf operation is:

select from My Table

I tried using [] and "" around the table name but no luck. How can I fix this?

Hi Mark,

Per our iWay technicals:

If I use the same statement:
SELECT FROM My_Table

Which is not specifying what to select, I get the following error message:

com ibi rdbms exceptions RDBMSException com microsoft sqlserver jdbc SQLServerException Incorrect syntax near the keyword FROM

The correct syntax is “SELECT * FROM My_Table”; don’t forget the star or a specific column name to retrieve...FYI I have created an “Adapter” target to my database server, created a prepared statement to select all rows on the table My_Table and used the “Test Run” option to test the prepared statement. The “SQL Code” of the prepared statement is:

SELECT * FROM My_Table

And it returns all the rows.


Cheers,

Kerry