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.