Property | Type | Access | Description |
---|---|---|---|
AtEOF | Boolean | RO | Indicate whether or not a DJImport object is at the end of file. |
ConnectString | String | RW | Set/get the connection string for the DJExport or DJImport object. |
CurrentRecordType | Integer | RO | Get the record type index of the last record read or written. |
Database | String | RO | Get the database name component of the connection string. |
Encoding | Integer | RO | Get the character set encoding number used by the DJExport or DJImport object. |
FieldCount | Integer | RO | Get the number of fields in the default record layout. |
Fields | DJField | RO | Get a reference to a field by name or by ordinal position. |
FileName | String | RO | Get the file name component of the connection string. |
LogFile | String | RW | Retrieve and set logging for individual DJImport / DJExport objects. |
LogMask | String | RW | Retrieve and set masking for individual DJImport / DJExport objects. |
Name | String | RW | Get/set the target file/table name. |
Nulls | DJExport or DJImport | RW | Get/set the Nulls warning level. |
Overflow | DJExport or DJImport | RW | Get/set the Overflow warning level. |
Properties | String | RW | Get/set a named adaptor property. |
RecordNumber | Long | RW | Get/set the current record number for a DJImport object. |
Record | DJRecord | RO | Get a reference to a record layout by name or by ordinal position. |
Self | DJExport or DJImport | RO | Return a reference to the object itself. |
Server | String | RO | Get the server name component of the connection string. |
SQLStatement | String | WO | Set the SQL statement for a DJImport object. |
Table | String | RO | Get the table name component of the connection string. |
Truncation | DJExport or DJImport | Get/set the truncation warning level. | |
TypeName | String | RO | Get the adaptor type name. |
UserName | String | RO | Get the user name component of the connection string. |
Value | String | RO | Get the adaptor type name (default property). |
Type | Required | Description |
DJImport | Yes | Reference to the DJImport which is the subject of the property or method invocation. |
Attribute | Description |
---|---|
DATABASE | Database name. This attribute is used for database management types of data sources. |
EXTRA | Attribute for specifying adaptor specific connection information. This is sometimes used for data access middleware such as ODBC or OLE DB. |
FILE | Name of a file or URI for the data source. This attribute is used for file oriented data sources. |
FILENAME | A synonym for FILE. |
PASSWORD | Password used for authentication with the security system for the data source. |
SERVER | Name of a database server. This attribute is primarily with server based database management systems. |
TABLE | Table name. This attribute is typically used with relational database management systems or with partitioned data sources, such as spreadsheets. |
USERID | User name used for authentication with the security system for the data source. |
USERNAME | Synonym for USERID. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
String | Yes | Expression that evaluates to a character string with connection information. |
Exception | Description |
ERR_TYPEMISMATCH | Returned if the connection string is invalid. |
ERR_PROPASSGN | Returned when an error is returned from the adaptor. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Type | Required | Description |
---|---|---|
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Type | Required | Description |
---|---|---|
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Integer or String | Yes | Expression that evaluates to a string with the name of the field or an integer with the position of the field in the container. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Type | Required | Description |
Number or String | Yes when setting No when retrieving | • WL_IGNORE, 0, "IGNORE" - If a null is encountered, the record is not rejected and warning message is not written to the log. • WL_WARN, 1, "WARN" - If a null is encountered, the record is not rejected and a warning message is logged. • WL_ERROR, 2, "ERROR" - This is the default value. If a null is encountered, the record is rejected and an error will be logged. |
Type | Required | Description |
Number or String | Yes when setting. No when retrieving | • WL_IGNORE, 0, "IGNORE" - If an overflow occurs, the record is not rejected and warning message is not written to the log. • WL_WARN, 1, "WARN" - If an overflow occurs, the record is not rejected and a warning message is logged. • WL_ERROR, 2, "ERROR" - This is the default value. If an overflow is encountered, the record is rejected and an error will be logged. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
String | Yes | Name of the adapter property to get or set. |
String | Yes | Expression that evaluates to a string that is used to set the property value. |
Exception | Description |
ERR_TYPEMISMATCH | Returned if the property name is invalid or if there is an error setting the specified property. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Exception | Description |
---|---|
ERR_TYPEMISMATCH | Returned if the record number is less than 1 or if the property is called with a DJExport object. |
ERR_EOF | Returned when the record number causes an attempt to read past the end of the data source. |
ERR_PROPASSGN | Returned when an error is returned from the adapter. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Integer or String | Yes | Expression that evaluates to a record layout number or to a record layout name. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Type | Required | Description |
DJImport | Yes | Reference to the DJImport that is the subject of the property or method invocation. |
Exception | Description |
ERR_TYPEMISMATCH | Returned if property is assigned using a DJExport object or if the adapter does not support SQL. |
ERR_EOF | Returned if the row set returned by the SQL statement is empty. |
ERR_PROPASSGN | Returned when an error is returned from the adapter. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Type | Required | Description |
Number or String | Yes when setting. No when retrieving. | • WL_IGNORE, 0, "IGNORE" - If truncation occurs, the record is not rejected and warning message is not written to the log. • WL_WARN, 1, "WARN" - If truncation occurs, the record is not rejected and a warning message is logged. • WL_ERROR, 2, "ERROR" - This is the default value. If truncation occurs, the record is rejected and an error will be logged. |
Required | Description |
Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
Method | Type | Description |
Copy Method (Variant 1) | Copy the field contents from another record object. The clear flag indicates whether the target fields are cleared before doing the copy operation. | |
Copy Method (Variant 2) | Copy the field contents from the nth row of a DJRowSet object. The clear flag indicates whether the target fields are cleared before doing the copy operation. | |
NewField Method | DJField | Append a new field to the DJImport or DJExport object. If a field reference is provided, it is used as a template for data type. |
PutRecord Method | Write a record of the specified type to the target. |
Type | Required | Description |
---|---|---|
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
DJRecord | Yes | Reference to a DJRecord object to be used as the source for the copy. |
Boolean | No | Flag indicating whether or not the target record contents should be cleared before the copy operation. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
DJRowSet | Yes | Reference to a DJRowSet. |
Integer | Yes | Index of the record in the DJRowSet collection to be used as the source for the copy. |
Boolean | No | Flag indicating whether or not the target record contents should be cleared before the copy operation. |
Exception | Description |
ERR_TYPEMISMATCH | Returned if any of the arguments for the method are invalid. |
Type | Required | Description |
DJExport or DJImport | Yes | Reference to the DJExport or DJImport that is the subject of the property or method invocation. |
DJField | No | Reference to a DJField object used as a template for field data type information. |
Exception | Description |
ERR_OBJREQ | Returned if optional field parameter is not a reference to a valid DJField object. |
ERR_OUTOFMEM | Returned when there is not enough memory to create a new DJField object. |
ERR_ROOBJECT | Returned when there is an attempt to add a field to a read-only object. |
Type | Required | Description |
DJExport | Yes | Reference to the DJExport that is the subject of the property or method invocation. |
Integer or String | No | Name of a record type or an index into the Records container of the type of record to write. |
Exception | Description |
ERR_ROOBJECT | Returned when there is an attempt to put a record to a read-only DJExport object. |
ERR_TYPEMISMATCH | Returned if the object of the PutRecord operation is not a DJExport object or if the adapter returns an error during the put. |
ERR_RECACCESS | Returned if the type parameter does not match a defined record type. |
Operator | Type | Description |
New Operator | DJExport or DJImport | Create a new object. |
Type | Required | Description |
String | Yes | Expression that evaluates to a string with the name of the data adapter to create for the DJExport or DJImport object. |
Exception | Description |
ERR_TYPEMISMATCH | Returned if the adapter type name does not match a registered or licensed adapter type. |
ERR_OBJNOTSET | Returned if there is an error creating the adapter instance. |