Best Practices > Following Best Practices > Using Actian Warehouse as an Integration Source and Target > EZScript
Was this helpful?
EZScript
Put the ODBC connection string given as value for the DriverOpts parameter into single quotes.
The following is a sample DJImport example which does not use a DSN. This example runs locally and in Actian Data Platform (formerly Avalanche) cloud environment.
Set Aval = New DJImport "Actian Warehouse"
Aval.ConnectString = "
DriverOpts='$(AVL_DRIVER_OPTIONS)';
UserId=$(AVALANCHE_USERNAME);
Password=$(AVALANCHE_PASSWORD)"
Aval.SQLStatement = "select count(*) as rows from sample.ontime"
LogMessage("Info", "SQL query on table sample.ontime shows " & Aval.fields(0) & "tuples.")
Last modified date: 10/22/2024