SQL that is run after the SQL connection is established where n is a number (1, 2, 3, ...). Multiple initial SQL statements are allowed to support databases that only allow single SQL statements. Example, to use in Oracle:
Code Block |
---|
|
initialSql1=ALTER SESSION SET NLS_TERRITORY = GERMANY|initialSql2=ALTER SESSION SET NLS_LANGUAGE = GERMAN |
No results are kept and any errors generates a macro exception. Using beforeSql is recommended for Postgres and other databases that support multiple SQL statements, as it is more efficient than multiple separated actions.