September 07, 2010, 06:38 PMMacLonghorn
iSM Microsoft Access target problem
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?
September 15, 2010, 02:49 PMKerry
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.