Alternative for creating sample data to define triggers, indexes, and fields

You define triggers, indexes, and fields from your actual data by using the graphical indexing tool of the OnDemand Administrator client.

Typically, you use the OnDemand Administrator client to download your selected spooled file sample data for you. If you require an alternative to the spooled file download function, you can instead create a stream file for input. For example, if you do not have IBM i Access Client Solutions - Windows Application Package on your system, you need to use a stream file as input to the graphical indexing tool.
You can create this stream file of your sample data by using the Print Text (PRTTXTOND) command on your IBM i system.
  1. To use this method, first locate the spooled file that you need to define to Content Manager OnDemand. For example, you can use the Work with Spooled Files (WRKSPLF) command on your IBM i system to find the spooled file.
  2. On the Work with All Spooled Files window, use option 2 (Change) or option 8 (Attributes) to determine the spooled file name, job name, job user, job number, and spooled file number of the spooled file.
  3. Enter the PRTTXTOND command and press F4 to prompt for parameters before you press Enter.
  4. Enter the spooled file attributes collected previously. Specify *END for the Ending page parameter to capture the entire spooled file.
  5. Press F10 for more parameters. For the Stream file (STMF) parameter, enter the IFS path and file name where you want the PRTTXTOND output stored.
  6. After the PRTTXTOND command completes, map a drive from your workstation to the IBM i system.
  7. Drag the sample data from the IBM i system to the directory on your workstation where you want to store the sample data. Alternately, you can use FTP to transfer the file from the IBM i system to your workstation.
  8. After the file is on your workstation, open the OnDemand Administrator client, logon to the server, and start the Report Wizard by clicking the Report Wizard icon.
  9. After the Report Wizard starts, select the data type, such as SCS or AFP, and click Select Sample Data.
  10. On the Select File pane, click PC File and Pages to Display > All Pages.
  11. Click OK, select the sample data file on your workstation, and click Open.
  12. Markup the triggers, indexes, and fields as needed. The entire spooled file is available to help you verify the accuracy of your indexer parameters.