User bio
404 bio not found
Member since Sep 23, 2019
Posts:
Kevin has not published any posts yet.
Replies:

To resolve the issues with airlines.dat, do the following

Add to the JVM arguments of %Java Sever, "-Dfile.encoding=UTF-8" without the quotes

Edit airlines.dat and make the following changes

  • Replace "\N" which is a MySQL specific token with "" (i.e. the empty string). Due to specific interactions with InterSystem's JDBC clients with IRIS, "" is interpreted as NULL when inserted as a string. 
  • Replace "\\'" (the escaped apostrophe) with "'" (just the single apostrophe) as InterSystem's JDBC clients do not require the escape character (which would otherwise be required in SQL).

This will allow all 6162 rows be inserted.

Certifications & Credly badges:
Kevin has no Certifications & Credly badges yet.
Global Masters badges:
Followers:
Following:
Kevin has not followed anybody yet.