I know this is information exists based on the GUI driven process of connecting to a server; however, I don't know if it's possible to do with JSL. I'm basically looking to get an array/list of database names so I that can loop through each name, create a connection, and extract my specified table fields.
This is specific to MySQL. On some databases, you would use EXEC sp_databases . Anyway, you could do something like the syntax below. This will return the list in a JMP table. You will then have to query the cells of the table to get the individual database names.
dt =Open Database ("DSN=MySQL Server;SERVER=mysql.ip.com;UID=MyUserID;PWD=MyPassword", "SHOW DATABASES", "DB List");