OHDSI Home | Forums | Wiki | Github

How to do Post-connection setup in createConnectionDetails() function?

Hi Folks,

I am attempting to use the createConnectionDetails() to create details for database connection. The Can anyone suggest that which argument (e.g., extraSettings?) I should use to correspond to the post-connection setup (e.g., post_connect_sql in srcr())? Thanks a lot!

NOTE: “post_connect_sql allows you to pass a series of SQL statements to the newly-established database session for execution. In this way, you can change database session settings to match the intended use of the connection. While these statements can make any changes the database server will permit, they cannot alter the R environment directly.”