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!
Asked
Active
Viewed 2,936 times
3
-
I'm confused... why would you need to turn of journaling in Sql Server in order to write to an AS400? – Michael Fredrickson Jan 27 '12 at 22:31
-
Why do you feel that you need to turn it off? What limitation do you think is preventing you from doing what you need to do? – Joe Stefanelli Jan 27 '12 at 22:31
-
The error that i got specifically in sql server is: – Loganj99 Jan 27 '12 at 22:35
-
not journaled, no authority to the journal, or the journal state is *STANDBY. Files with an RI constraint action of CASCADE, SET NULL, or SET DEFAULT must be journaled to the same journal. – Loganj99 Jan 27 '12 at 22:37
-
1@Loganj99 That error isn't from SQL Server, it's from the AS400... how are you trying to write to the table in AS400? – Michael Fredrickson Jan 27 '12 at 22:39
-
Just insert into
(column1, column2)
– Loganj99 Jan 27 '12 at 22:45
1 Answers
8
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
James Allman
- 40,573
- 11
- 57
- 70
-
-
We ended up having to create a ODBC connection instead of using IBMDASQL. – Loganj99 Feb 02 '12 at 20:45
-
@Loganj99 : CommitMode=0, would be "Commit immediate (*NONE)", on the advanced server options dialogue for an iSeries ODBC configuration, which you get to by pushing the "Advanced" button on the "Server" tab, right? – Andreas Jansson Jan 02 '13 at 16:03