background image
<< System Environment Variable Settings | Appendix B - Standard Datapool Data Types >>
<< System Environment Variable Settings | Appendix B - Standard Datapool Data Types >>

INFORMIX on a UNIX Agent computer

392
Appendix B - Standard Datapool Data Types
Standard data type name
Description
Examples
Address - Street
Street numbers and names. No period after
abbreviations.
20 Maguire Road
860 S Los Angeles St 8th Fl
75 Wall St 22nd Fl
Cities - U.S.
Names of U.S. cities.
Lexington
Cupertino
Raleigh
Company Name
Company names (including designations
such as Co and Inc where appropriate).
Rational Software Corp
TSC Div Harper Lloyd Inc
Sofinnova Inc
Date - Aug 10, 1994
Dates in the format shown.
The day portion of the string is always two
characters. Days 1 through 9 begin with a
blank space.
To include the comma ( , ) as an ordinary
character rather than as the .csv file
delimiter, the dates are enclosed in double
quotes when stored in the datapool.
To set a range of dates from January 1, 1900
through December 31, 2050, set
Minimum
to
01011900 and
Maximum
to 12312050.
Oct 8, 1997
Jun 17, 1964
Nov 10, 1978
If the comma is the
delimiter, the values are
stored in the datapool as
follows:
"Oct 8, 1997"
"Jun 17, 1964"
"Nov 10, 1978"
Date - August 10, 1994
Dates in the format shown.
The day portion of the string is always two
characters. Days 1 through 9 begin with a
blank space.
To include the comma ( , ) as an ordinary
character rather than as the .csv file
delimiter, the dates are enclosed in double
quotes when stored in the datapool.
To set a range of dates from January 1, 1900
through December 31, 2050, set
Minimum
to
01011900 and
Maximum
to 12312050.
October 8, 1997
June 17, 1964
November 10, 1978
If the comma is the
delimiter, the values are
stored in the datapool as
follows:
"October 8, 1997"
"June 17, 1964"
"November 10, 1978"