sixpetals https://blog.hatena.ne.jp/sixpetals/ 狂言日誌 https://sixpetals.hatenadiary.org/ DB2 JDBC経由でsetStringして INSERT INTO tableA (col1, col2 ) VALUES ( 'TEST' , CAST(REPLACE(?,'/','-') AS DATE ); を投げると com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null でおっこちる。 これを INSERT INTO tableA (col1, col2 ) VALUES ( 'TEST' , CAST(REPLACE(CAST(? AS VARCHAR(1… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fsixpetals.hatenadiary.org%2Fentry%2F20050628%2Fp1" title="パラメーター・マーカー（変数バインド）の不思議 - 狂言日誌" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2005-06-28 00:00:00 rich https://sixpetals.hatenadiary.org/entry/20050628/p1 1.0 100%