The %qparsets issue that you're seeing has been resolved internally and should be shipped as part of IRIS 2022.1.0
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:
![Open Sesame!](https://community.intersystems.com/sites/default/files/badges/303371180-6de11138-f4e7-4113-b5cc-836269f07693.png)
![1,000 Points](https://community.intersystems.com/sites/default/files/badges/290121674-53216c4b-fe0c-44e7-9d75-2f24390135ed.png)
![Challenge Starter](https://community.intersystems.com/sites/default/files/badges/295959213-b83dd91a-663f-4f07-8e0e-e3287b7c2309.png)
![DC Commenter](https://community.intersystems.com/sites/default/files/badges/dc_commenter_1.png)
![DC Problem Solver](https://community.intersystems.com/sites/default/files/badges/dc_problem_solver_1.png)
![Master of Answers](https://community.intersystems.com/sites/default/files/badges/master_of_answers.png)
Followers:
Following:
Kevin has not followed anybody yet.
Yeah, the JVM encoding problem has been discovered internally and we're actively trying to correct it.