All Forums Database
Raja_KT 1246 posts Joined 07/09
03 Feb 2010
ANSI and BTET

Hi,Using bteq, some sql dmls I want to use btet and some I want to use ANSI in the same script. I know how to set it(.set session trans.....). Can we use bt et in first part of the script and once that is done in the last part of the script I want to implement ANSI(commit, rollback) because of business requirement. Please let me know.

Raja K Thaw

My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1

Street Children suffer not by their fault. We can help them if we want.

Paul Johnson 12 posts Joined 01/10
03 Feb 2010

Would the entire script be re-runnable if it failed in the ANSI section?

Raja_KT 1246 posts Joined 07/09
03 Feb 2010

The script must be run only once and it should be successful.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Paul Johnson 12 posts Joined 01/10
03 Feb 2010

Phew!

dnoeth 4628 posts Joined 11/04
03 Feb 2010

Hi Raja,you could logoff after the first part, then specify the new session mode and logon again.But why do you think you need to mix BTET and ANSI in the same batch?IMHO there's nothing you can't rewrite for the other mode.Dieter

Dieter

Raja_KT 1246 posts Joined 07/09
04 Feb 2010

Dieter,It is just that I want to see the solution. I guess between the logon and logoff, I cannot change from btet to ansi. Am I right?Thanks and regards,

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

dnoeth 4628 posts Joined 11/04
04 Feb 2010

Hi Raja,just try to change mode and watch the error message :-)Dieter

Dieter

Raja_KT 1246 posts Joined 07/09
04 Feb 2010

Hi Supreme,I can try that ..no issue. But company pays me for my result-oriented works..not for error-producing codes.If I know it 100% right in the first shot (getting the right info from the document) then it saves time. The organization I work for will be happy :))))) :).. JUST KIDDING....Regards,Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.