No, there's no one statement that you can use. You'll have to use an odbc connection and the odbc command SQLTABLES to create a table with a list of all the tables. Then you have to iterate through that new table and for each record in that table get the name of the source table you want to load from your source database and load the first 100 records.
Something like this maybe:
LIB CONNECT TO 'AG1';
For i = 1 to NoOfRows('TableList')
LET vTableName = Trim(FieldValue('TABLE_NAME',$(i)));