The format of the SQL statements differs depending on which database type you are using.

For PostreSQL, SAP HANA and SybaseIQ, the path to the file (stated as <path to file> in the code blocks below) can be entered in three different ways:

• Entering the path explicitly, e g 'Users/mine/mypath'
• Stating the UDR field containing the path by entering $(UDR.fullpath)
• Stating the MIM value containing the path, e g $(Source_Pathname) for the Disk agent

PostgreSQL

For server side loading (file resides in the server filesystem of the database)

COPY table_name [(column1,colunm2,...,columnN)]  FROM <path to file> DELIMITER ',' csv;

Stating columns is optional.

SAP HANA

For server side loading (file resides in the server file system of the database)

1. Create a control file containing code below (this example ctl file name is abc.ctl, abc.txt is the csv file): 

   import data into table SYSTEM."TEST_LOADER" from 'abc.txt' record delimited by '\n' fields delimited by ',' optionally enclosed by '"' error log 'abc.err'

    

2. Run the workflow with the following command: 

   import from '/<path>/abc.ctl'

Sybase IQ

For server side loading (file resides in the server file system of the database)

LOAD TABLE TABLENAME (COLUMNNAME, COLUMNNAME2) USING FILE <path to file> FORMAT BCP ESCAPES OFF 
DELIMITED BY ','