Available Data Types

The table below describes the string representations of the basic server types that can be used in the struct parameter passed to a batch process operation.

Table 1. String Representations of the Basic Server Types

Type

String Representation

SVR_CHAR

The first character in the string is accepted as the character value.

SVR_INT8

A number in the range of -128 to 127, for example, -100, or 78.

SVR_INT16

A number in the range of -32768 to 32767, for example, 25601.

SVR_INT32

A number in the range of -2147483648 to 2147483647, for example, 40101.

SVR_INT64

A number in the range of

-9223372036854775808 to 9223372036854775807, for example 3456789012.

SVR_FLOAT

A single precision floating point number. The maximum positive value is 3.402823466e+38 and the minimum positive value is 1.175494351e-38. For negative values, the magnitudes are the same. The numbers can be expressed in exponential form, -3.78123e3 or as a decimal -3781.23.

SVR_DOUBLE

A double precision floating point number. The maximum positive value is 1.7976931348623158e+308 and the minimum positive value is 2.2250738585072014e-308. For negative values, the magnitudes are the same. The numbers can be expressed in exponential or decimal form.

SVR_STRING

As is.

SVR_DATETIME

A date in ISO 8601:1988 format yyyymmddThhMMss. For example, 6:49:02pm on December 9, 1999, would be represented as 19991209T184902.

SVR_DATE

A date in ISO8601:1988 format yyyymmdd. For example, the previous date would be represented as 19991209.

SVR_MONEY

Same as for SVR::Double.

SVR_BOOLEAN

One of true or false. The value is case insensitive.