InfoConnect for Airlines VBA Guide
Xfr400SelectString Property
Gets or sets which fields to transfer.
Object.Xfr400SelectString As String

Property Value

If you don't enter any field names, all fields in the file are transferred.


To list particular fields, use this syntax:

<field name1>,<field name2>,<field name3>

To perform functions on the contents of a field, use this syntax:

<function>(<field name>)

The available functions are AVG, COUNT, MAX, MIN, and SUM.

This property affects AS/400 data transfer and is only relevant for 5250 sessions. The default is "". This string can be up to 220 characters long.

Setting which fields to transfer
Sub SelectString()
    'This statement lists the LAST, FIRST, ID, and PHONE fields
    ThisIbmTerminal.FileTransfer.Xfr400SelectString = "LAST, FIRST, ID, PHONE"
    'This statement specifies the average of the PAY field.
    ThisIbmTerminal.FileTransfer.Xfr400SelectString = "AVG(PAY)"
End Sub
See Also