NeoDBPro SemiColum
Quote from ebear on June 14, 2021, 4:14 pmHello All,
I'm working on a application which should communicate with an IBM DB2 database. I'm already building Database applications with NeoBook / VisualNeo, and have a lot of experience with this.
The connection to an IBM DB2 database server is although the first time.
Creating connection with the server goes fine, but If I send a query to the server it seems that NeoDBPro automatically adds a semicolon ';' at the end of the query. The DB2 server doesn't like this and doesn't return any data and reports an error. NeoDBPro then writes the message "Cannot perform this operation on a closed dataset"
From the log files on the DB2 server I know that the issue is the Semicolon.
Is there anyone who can help me with this issue as I already spent hours and hours on this without any results.
@Luis, do you have access to the code of NeoDBPro to check if I'm correct that the Semicolon is added?
Best regards,
Eric Beerhorst
Hello All,
I'm working on a application which should communicate with an IBM DB2 database. I'm already building Database applications with NeoBook / VisualNeo, and have a lot of experience with this.
The connection to an IBM DB2 database server is although the first time.
Creating connection with the server goes fine, but If I send a query to the server it seems that NeoDBPro automatically adds a semicolon ';' at the end of the query. The DB2 server doesn't like this and doesn't return any data and reports an error. NeoDBPro then writes the message "Cannot perform this operation on a closed dataset"
From the log files on the DB2 server I know that the issue is the Semicolon.
Is there anyone who can help me with this issue as I already spent hours and hours on this without any results.
@Luis, do you have access to the code of NeoDBPro to check if I'm correct that the Semicolon is added?
Best regards,
Eric Beerhorst
Quote from Gaev on June 15, 2021, 3:04 am@ebear
1) is it just the dbpQuery command that fails to execute ? How about dbpFind or dbpOpenTable or dbpGetTableNames or dbpAddRecord etc. ?
2) can you do a Query using the (advanced) dbpExecSQL command ?
1) is it just the dbpQuery command that fails to execute ? How about dbpFind or dbpOpenTable or dbpGetTableNames or dbpAddRecord etc. ?
2) can you do a Query using the (advanced) dbpExecSQL command ?
Quote from ebear on June 15, 2021, 11:26 pmHello Gaev,
Im sorry I had to be a bit more complete. I use the dbpExecSQL command.
Best regards,
Eric
Hello Gaev,
Im sorry I had to be a bit more complete. I use the dbpExecSQL command.
Best regards,
Eric
Quote from ebear on June 16, 2021, 2:51 pm@luishp
Hello Luis,
Do you have any idea from the Plugin why this is happening. As I already wrote I'm already years very successful working with the NeoDBPro plugin and it seems that other database systems have no issue with the semicolon. But IBM DB2 has an issue what doesn't make it possible to work with. As I know no database system needs the semicolon ";" after an query. So if the NeoDBPro adds it automatically it should not be needed and removed. I don't know how much of the NeoDBPro code you have available and can make changes to it, but I think it should be very simple to modify???
Best regards,
Eric Beerhorst
Hello Luis,
Do you have any idea from the Plugin why this is happening. As I already wrote I'm already years very successful working with the NeoDBPro plugin and it seems that other database systems have no issue with the semicolon. But IBM DB2 has an issue what doesn't make it possible to work with. As I know no database system needs the semicolon ";" after an query. So if the NeoDBPro adds it automatically it should not be needed and removed. I don't know how much of the NeoDBPro code you have available and can make changes to it, but I think it should be very simple to modify???
Best regards,
Eric Beerhorst
Quote from luishp on June 16, 2021, 5:29 pmHI @ebear,
Unfortunately I don't have the NeoDBPro plugin source code.
All I can do is asking Dave about it but he has retired completely from programming.
Sorry!
HI @ebear,
Unfortunately I don't have the NeoDBPro plugin source code.
All I can do is asking Dave about it but he has retired completely from programming.
Sorry!
Quote from Gaev on June 16, 2021, 11:33 pm@ebear:
1) This appears to be an old issue (circa 2015) with IBM DB2 on Z/OS
https://www.ibm.com/support/pages/apar/PI526522) Can you post your exact dbpEXECSQL command ? ... if it contains [variables], please show the immediate values of such [variables]. I read something about using a character other than a semicolon as the command terminator if the content of the command contains a semicolon.
@ebear:
1) This appears to be an old issue (circa 2015) with IBM DB2 on Z/OS
https://www.ibm.com/support/pages/apar/PI52652
2) Can you post your exact dbpEXECSQL command ? ... if it contains [variables], please show the immediate values of such [variables]. I read something about using a character other than a semicolon as the command terminator if the content of the command contains a semicolon.
Quote from ebear on June 17, 2021, 8:32 amHello Gaev,
I read the article and this is exactly what happens.
In my code I do the following very simple:
dbpExecSQL "db" "[db_query]" "db_query"Where the value of the variable [db_query] is for example: Select * FROM Employees Where Name = 'Eric Beerhorst'
The semicolon at the end of the query seems to be added by NeoDBPro. As I already wrote before the connection over ODBC with the DB server works correct.
Best regards,
Eric
Hello Gaev,
I read the article and this is exactly what happens.
In my code I do the following very simple:
dbpExecSQL "db" "[db_query]" "db_query"
Where the value of the variable [db_query] is for example: Select * FROM Employees Where Name = 'Eric Beerhorst'
The semicolon at the end of the query seems to be added by NeoDBPro. As I already wrote before the connection over ODBC with the DB server works correct.
Best regards,
Eric