We have created a database on MYSQL on Linux Debian 11 using emergency transport data (approximately 67 million) from 2007 to 2020 published by the Ministry of Internal Affairs and Communications, and are searching the data from JMP 15.0 (SAS) on Windows 10 via an ODBC connection. However, when searching for a MYSQL server from JMP on a PC via an ODBC connection, the IP address changes every time in a DHCP environment, making it difficult to create search scripts. In addition, the database used has different variable definitions depending on the year, making it necessary to write scripts for each year. We will introduce the steps to easily perform these processes at the individual researcher level.
