Programming with Reflection

image\rwnprg32.gif Xfr400SelectString property



object.Xfr400SelectString = Value

Data type




Returns (first syntax line) or specifies (second syntax line) which fields to transfer. Note: SQL query options can also be set using the SetSQLStatement method. Transfer options set using the method supersede any transfer options entered using this property.

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. If you don't enter any field names, all fields in the file are transferred. Use this syntax to list particular fields:

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

For example:

Session.Xfr400SelectString = "LAST, FIRST, ID, PHONE"

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

<function>(<field name>)

For example:

Session.Xfr400SelectString = "AVG(PAY)"

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


image\jump.gif Keyword Index

image\popup.gif Related Topics

image\popup.gif Reflection products that use this property