The SQL Wizard in GoAnywhere Director™ allows you to quickly build SQL Select statements using intuitive screens. You would first choose the database server to connect to, and then you can drill-down and select the schemas (libraries), tables (files) and columns (fields). You can additionally specify the column headings, WHERE, JOIN and ORDER BY criteria on the remaining screen tabs.
A preview of the SQL Select statement is shown on the bottom of the screen as you advance through the tabs in the wizard. When finished, the generated SQL Select statement will be inserted within the Project.
GoAnywhere Director can be installed onto Windows, VMware, Linux, IBM i, AIX (pSeries), UNIX, HP-UX, Mac OS and Solaris platforms. IBM i is also referred to as System i, iSeries, as400, as/400 and i5.