SQL Loader Agent UDRs

The Route FileReferenceUDR checkbox in the configuration dialogs in the Disk, FTP and SFTP agents should be selected when using the SQL Loader agent.

 

Route FileReferenceUDR checkbox



The SQL Loader agent then forwards an SQLLoaderResultUDR containing information about loaded file, number of inserted rows, execution time and any error messages, for logging purposes. 

 

Workflow with the SQL Loader agent

UDR Types

The UDR types used in combination with the SQL Loader agent are FileReferenceUDR and SQLLoaderResultUDR:

FileReferenceUDR

The FileReferenceUDR is the UDR format used to send data from the collection agent to the SQL Loader agent.

The following fields are included in the FileReferenceUDR: 

Field

Description

Field

Description

directory (string)

This field states the name of the directory the data file is located in. 

filename (string)

This field states the name of the file data should be collected from. 

fullpath (string)

This field states the full path to the data file.

OriginalData (long)

This field contains the original data in byte array format. 

SQLLoaderResultUDR 

The SQLLoaderResultUDR is the UDR that the SQL Loader agent sends out after having loaded the data into the database. This UDR contains information for logging purposes that should be handled by another agent in the workflow. 

The following fields are included in the SQLLoaderResultUDR: 

Field

Description

Field

Description

errorMessage (string)

This field contains any error message that might have been returned during the loading of data. 

executionTime (long)

This field indicates the time it took to load the data into the database.

filename (string)

This field contains the name of the file from which data was uploaded.

rowsAffected (long)

This field indicates the number of affected rows.

OriginalData (long)

This field contains the original data in byte array format.

For more information on the Ultra Format Definition Language and UDR format, refer to Ultra Reference Guide.