Previous Topic Next topic Print topic


To export data for uploading to a mainframe

  1. Click SQL for DB2 on the Tools menu; then click SQL Wizard.
  2. In SQL Wizard, click New > Export on the File menu.
  3. On the Export window, in the Source Table Information group, click Browse to specify the table's location and name (or type the location and name in the Table Name field and press Enter).

    The names of all columns in the table appear in the Included list.

  4. Remove the names of any columns you don't want to export by clicking them in the list and clicking <<.
  5. Optionally, change the order of columns in the table by selecting a column name and clicking Up or Down to change its position in the list.
  6. Optionally, type a condition (in SQL syntax) in the Where Condition field to export a subset of rows in the table. For example: CUST_NO < 12850
  7. In the Target File Information group, select the type of file from the Format list.
  8. Change the settings as appropriate for the type of file you want to create.
  9. Click Browse to specify a location and name for the file you want to create (or type a location and name and press Enter).
  10. Click Run on the Export menu.

    A new file is created containing the data you specified.

Previous Topic Next topic Print topic