Programming with Reflection

image\rwnprg32.gif Xfr400SelectString property

 

Syntax

object.Xfr400SelectString
object.Xfr400SelectString = Value

Data type

String

 

Description

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.

Values

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