Re: Anyone have trouble issuing a DELIMITER command via JDBC driver?

[Bill Karwin]

Oh another comment about supporting DELIMITER.

If you're processing a SQL script, your code does need to pay attention to DELIMITER, so it knows how to parse the following statements. Statements can be multiple lines long. So instead of reading line by line, you need to read input from the script file up to the next occurrence of the characters defined by DELIMITER. The delimiter can be a single character or multiple characters:

DELIMITER !!

SELECT foo 
FROM bar!!

DELIMITER ;

SELECT baz 
FROM bling;

Regards,
Bill K.