GoAnywhere Forum

Good morning,
I am primarily an IBMi guy and SQL is pretty new to me, so bear with me on this question.
is there a way in GoAnywhere to get a list of tables in a SQL database on a SQL server? For example, using FTP I can run a LS command to get a list of files from an IBMi. I want to be able to do something similar using a database server, build a FileList in GA, and use the table names as a variable in a SQL Select command such as
Select * from ${tablename}

If this is not available, would I be able to have a GA project that looped through a text (or csv) file with table names and used each name as a variable in the select statement above?

TIA,
Kevin

I found a solution using a search

SELECT name
FROM sysobjects
WHERE xtype='U'
and name like 'PROMO%'
ORDER BY name;

this gives me a list of tables in a database whose name begins with PROMO. now I need to read this list of tables and copy/move each table to another server or archive it.

Kevin,

You can also address "SysTables" in the SysIBM library. It can give you quite a bit to query from to get those lists. There are other indexes and tables in that same library that you can use as well.