Get table status

This operation regularly acquires the number of lines in a temporary table and checks for errors.

If values accumulate in the temporary table without being written, the number of lines in the temporary table increases, and it is detected as an error.

You can display the get table status operation screen by displaying the script canvas on the Designer screen, clicking the following items in the following order, and then dragging and dropping the component icon onto the script canvas:

  • Tool palette > Basic > Temporary table > Get table status

 

Figure 2.6 Get table status operation screen

(1) Field list

This is a list of the fields to configure for the get table status operation.

Table 2.7 Field list

Field Name

Initial Value

Setting Value

Omission

Notes

Name

 

Single-byte alphanumeric characters and certain symbols (*1)

-

A value that begins with a single-byte alphabetic character

Required settings

 

 

Table

 

Temporary table name

-

 

Interval

 

From 1 to 1314000

-

Unit: seconds

Set as integer

Comment

 

Comment

 

Characters

 

:

Possible to omit

-

:

Impossible to omit

*1

:

Only "_" (underscore) can be specified.

(2) Description of each field

This section explains each of the fields to configure for the get table status operation.

After changing these settings, click Finish to save the settings.

Click Cancel to discard the changes.

Name

Name of the get table status operation component

Single-byte alphanumeric characters and "_" (underscore) can be used.

Use a value that begins with a single-byte alphabetic character.

Required settings

Table

Temporary table that is the target for table status acquisition

Select the temporary table that defines the schema.

When you click Add, the temporary table settings screen appears.

For details on the temporary table settings screen, refer to Temporary table settings.

When you click Edit list..., the editing screen for the resource list appears.

For details on the editing screen for the resource list, refer to Edit resource list.

Interval

Interval to acquire the status of data in the temporary table as present or absent (seconds)

Specify the interval as a numerical value between "1" and "1314000".

Comment

Comment

Comment regarding the get table status operation

You can enter a comment.