Copyright © Cloud Software Group, Inc. All Rights Reserved

Extract a Table

You can use this command to print a list of the fields for a selected iProcess table, optionally including the data associated with those fields. You can also choose to export the fields to a file.

You can either select this utility from the swutil menu (see Using swutil), or use the following command:

swutil EXTTAB

The utility prompts you for the name of the table to print a list of fields for, optionally including the data associated with those fields.

The following example illustrates the output if you elect to disregard the table data or if no data is present in the table.

---

 

Table structures

Table: SOFTWARE (Dataspace 30 bytes)

Field name Type Length DP

SITEM Text 18
SPRICE Numeric 8 0

---

 

This example illustrates the output with data.

---

 

Table structures and data

Table: HARDWARE (Dataspace 30 bytes)

Field name Type Length DP Data

HITEM Text 18 Tiny machine
HPRICE Numeric 8 0 995

HITEM Text 18 Medium machine
HPRICE Numeric 8 0 1995

HITEM Text 18 Large machine
HPRICE Numeric 8 0 5995

---

 

The Dataspace bytes indicates the total amount of space that will be allocated to any one case to hold data from the selected table.

The Length of a field indicates the maximum length of that field; the table data for that field may not exceed this amount.

Copyright © Cloud Software Group, Inc. All Rights Reserved