RMCobol ODBC .

[dislar]

Hello.

I'm working with an ODBC controler for SQL and RMCOBOL called "Retatvity for RM (*.rct)", version 3.03.60.03 from "Liant Software".
That's tries to simulate RM tables as a relactional SQL Data Base.

I'm making a progam in Visual Basic using this ODBC driver to open and read some RMCOBOL tables located in a directory.

When I send the folow query : " select * from rmTable1 " all is allright, but if I send this other query :

" select * from rmTable1 as x left join rmTable2 as y on y.field_y1 = x.field_x1 "

The program sais that there is a "syntax error" in the sentence, but te sentence is correct, I tested it in the SQL Analycer.

I'd like to know if it is owing an old ODBC version and if there is another way of due this query.

Thanks.

 

[Craigii]

I use Retatvity as well and I have found that if you don't use the COBOL indexes in your queries, you will get weird errors. Version 4 does correct some of those problems by allowing you to set more indexes and by fixing some numerical conversion problems.

Hope it helps