Reflection Desktop VBA Guide
Attachmate.Reflection.Objects.Emulation.IbmHosts Library / Attachmate.Reflection.Objects.Emulation.IbmHosts Library / FileTransfer Object / Xfr400SelectString Property
Example
Xfr400SelectString Property
Gets or sets which fields to transfer.
Syntax
expression.Xfr400SelectString As String
where expression is a variable that represents a FileTransfer Object

Property Value


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

Remarks

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.

Example
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