ODBC SQL Stmt End of Statement Delimiter
Need to connect to the AS400 database V7R4M0 using ODBC. ODBC connection allows me to enter an SQL statement in the Advanced Option. Need to run a drop table statement and then the create table statement. Assumed the end of statement delimiter would be ";" (semi-colon) but its not.
Does anyone know the character to separate different SQL statements?