Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# 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:

    swutilEXTTAB

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.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.