Migration Toolkit

[peterlaursen]

Sorry it took a little time to reply where, but nobody remembered full details about this.

There is a limitation in our code here with JOINS (and what you are doing (the construction table1.field2=table2.field1) is actually a “JOIN in the WHERE-clause”).

However if the ODBC-source supports subqueries you can use a subquery in the WHERE-clause. Try replace 

Code:

table1.field2=table2.field1

with 

Code:

table1.field2 IN (SELECT field1 FROM table2)

[mkgreidi]

Thanks for answer

I try to make your suggestion but it shows an error.

I write in WHERE clause cod_tar IN (SELECT cod_tar FROM tl_precios) but shows me the message error “[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Syntax error in SQL statement at or about “'tl_tarifas') and 1=0″ (10713)”

What does it mean?How can I solve it?

[attachment=1376:example_error.jpg]

[Khushboo]

Hi,

You have used single quotes(') for the table name tl_tarifas which caused this error.

Instead, please use Backticks(`) for table and try again.

Thanks & Regards,

Khushboo

[peterlaursen]

Maybe this database does not support subqueries.  Can you try to execute a similar subquery from some other interface?

Also you may need to experiment with paranthesis'es.  

[peterlaursen]

I do not know if OpenEdge uses backticks or whatever for quoting identifiers.  The syntax in the WHERE clause must follow the SQL-dialect of.

[mkgreidi]

If I try to import with the option “use a query to specify the data to transfer” it doesn´t work too.

I write the query SELECT * FROM `tl_tarifas` but it shows me the error

[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Syntax error in SQL statement at or about “tl_tarifas”(10713)

I used the quotes and backsticks, and try to use a subquery but when I specified the table name always have the same error.

Sorry,but it´s the first time I use this software and I don´t fins many information.

[peterlaursen]

Unfortunately we almost do not know the source-database you are using. It will take some time before we can advice further.

[mkgreidi]

I don´t know if this maybe can help you but the source-database is Progress.

It´s my fault not to specify before,sorry.

Thank you

[peterlaursen]

We can see what database it is from the error returned by the ODBC-driver – so we already figured out.

We will need to download a TRIAL (if exists) of this software and install it tomorrow.

[Author]

Posts