Using A Query In Migration Toolkit

[mkgreidi]

I´m trying to use a query in the migration toolkit loke this

SELECT codtl_art,desc_Art FROM tl_articulo WHERE PUB.tl_articulo.num_fab=1029 LIMIT 5

to import to another database only the first rows of the table (5 is an example, can be 5 ,10 o 25 but only this first rows)

And shows me this error

Syntax error in SQL statement at or about “LIMIT 5” (10713)

What´s the problem with this query?Because en Mysql runs.

How can I solve this error?

[peterlaursen]

It is the ODBC-source that returns this error – not the MySQL-target.

Please tell: what is the ODBC-source?  I think you have earlier reported an issue with OpenEdge?

(we have tried with MySQL as source and a query like yours with LIMIT works fine)

[mkgreidi]

Yes,I reported an issue with OpenEdge. Finally, I solved this problem. I have to aggregate “pub” before the table name to select.

For example:

Error : SELECT * FROM table1

Correct: SELECT * FROM pub.table1

Now, I have a problem with the openEdge database, and if I want to import the table show me this error.

ERROR: [DataDirect][ODBC OPENEDGE driver][OPENEDGE]Column desc_Art in table PUB.tl_articulo has value exceeding its max length or precision. : Import unsuccessful

I wanted to use the previus query to make an import by groups,very little groups, to try to identificate witch register is wrong in openedge database.

Try and import loke this

SELECT * FROM table1 LIMIT 0,10

SELECT * FROM table1 LIMIT 10,10

SELECT * FROM table1 LIMIT 20,10

In Mysql runs perfectly,but in migration toolkit process shows me the previous error.

[Khushboo]

Hi,

The query which we specify to Import, is executed on the source not on the target. So, the SQL written should be compatible with the ODBC source.

Please execute a simple query like “SELECT * from table1 LIMIT 0,5” in your source client interface i.e OpenEdge and check if it executes successfully.

It may be possible that “LIMIT” keyword is not supported by OpenEdge.

Please check which keyword(equivalent to LIMIT clause in MySQL) is supported by OpenEdge and use that in Import Wizard.

Thanks & Regards,

Khushboo

[Author]

Posts