Manual selection of database data for copying

To copy a selection of rows from tables, you can add selections in a copy from source and you can change the value on fields in the target. This is the syntax:

[Source selection]: [#]FIELDNAME] [[ > | < | = | != | <> | >= | <= ] [VALUE]] [AND | OR [[#]FIELDNAME] [[ > | < | = | != | <> | >= | <= ] [VALUE]]]*

[FIELDNAME]: Specify the name of the selected field, excluding the prefix (two letters). The optional # character indicates that the field must be included in all tables. Tables where this field is missing will not be copied.

[Target values]:[FIELDNAME]=[VALUE] [,[FIELDNAME]=[VALUE]]*

Example 1 - Copy rows selected on multiple fields, one of them mandatory, and replace target values

Source selection: #CONO=133 and DIVI=’AAA’

Target values: CONO=134, DIVI=’BBB’

This example only copies tables that contain the field CONO. If the table contains CONO and DIVI, only rows where CONO=133 and DIVI=’AAA’ are copied, and the values are replaced with CONO=134 and DIVI=’BBB’. If the table only contains CONO, all rows where CONO=133 are copied (and the value for CONO is replaced with 134).

Example 2 - Copy rows selected on single field and replace target value

Source selection: CONO=123

Target values: ITNO=’12345678’

This example copies all tables. If the table contains CONO, only rows where CONO=123 are copied. If ITNO is included in the table, all rows will have ITNO set to ‘12345678’.

Example 3 - Copy rows selected on multiple fields with unspecified target value

Source selection:#CONO and #DIVI

Target values: Leave blank

This example copies all tables that contain the fields CONO and DIVI and does not specify any new target values.