Turn off Journaling in Sql Server/ T-SQL

Question

I need to turn off journaling in Sql Server/T-SQL to write to a file/table in as400. I have found that you can do it in SQLite with Pragma. However, I have discovered that doesn't exist in T-SQL. Any ideas?

Thanks!

Answer 1

You need to disable commitment control on the link. Which provider are you using?

.NET

DefaultIsolationLevel=Chaos

OLEDB (IBMDA400)

Extended Properties="Default Isolation Level=NC;Auto Commit Mode=True"

ODBC

CommitMode=0