# END TRANSACTION Needed with Oracle? **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Natural, Natural-on-Linux\ **Created:** [November 5, 2009, 3:22pm UTC](https://techcommunity.softwareag.com/t/end-transaction-needed-with-oracle/92024 "2009-11-05T15:22:35Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Ats](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Ats](https://techcommunity.softwareag.com/u/Ats)\ **Post date:** [November 5, 2009, 3:22pm UTC](https://techcommunity.softwareag.com/t/end-transaction-needed-with-oracle/92024/1 "2009-11-05T15:22:35Z")
Hi Friends, Have queries on Natural/Oracle under Unix platform. Curious if ET (END TRANSACTION) is really needed for Oracle database? I wrote a simple code: DEFINE DATA LOCAL 1 EMP VIEW OF EMPLOYEE 2 EMP\_ID END-DEFINE * * * SELECT \* INTO VIEW EMP FROM EMPLOYEE WHERE ACCOUNT\_ID = 1234567890 DISPLAY EMP \* MOVE 2222222222 TO EMP\_ID UPDATE END-SELECT * * * SELECT \* INTO VIEW EMP FROM EMPLOYEE WHERE ACCOUNT\_ID = 1234567890 DISPLAY EMP END-SELECT \* END * * * Output: 1. In 1st DISPLAY I got EMP\_ID as 1111111111 (the initial database value) 2. In 2nd DISPLAY I received EMP\_ID = 2222222222 Means the value was updated in Oracle database without ET (I queried dabase as well thru other software and got the updated value). Can anyone throw some light on this as curious on why our past programmers have coded ET logic in every UPDATE? And how will it cost as far as CPU usage is concern. Also, 1. Since there is no ADABAS, no TT will come in picture so how does HOLD queue time and record limit etc comes in picture for this case? or how does UPDATE works for Oracle? ---
**Author:** ![Finn\_the\_Dane1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/finn_the_dane1/32/132_2.png) [@Finn\_the\_Dane1](https://techcommunity.softwareag.com/u/Finn_the_Dane1)\ **Post date:** [November 5, 2009, 3:33pm UTC](https://techcommunity.softwareag.com/t/end-transaction-needed-with-oracle/92024/2 "2009-11-05T15:33:28Z")
A qualified guess would be that the Natural parameter ETEOP (ET at End Of Program) is set to true ?! Finn ---
**Author:** ![Ats](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Ats](https://techcommunity.softwareag.com/u/Ats)\ **Post date:** [November 5, 2009, 3:43pm UTC](https://techcommunity.softwareag.com/t/end-transaction-needed-with-oracle/92024/3 "2009-11-05T15:43:46Z")
Hey Finn, Can I know where should I look for the settings? I tried GLOBALS but no luck. ---
**Author:** ![Finn\_the\_Dane1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/finn_the_dane1/32/132_2.png) [@Finn\_the\_Dane1](https://techcommunity.softwareag.com/u/Finn_the_Dane1)\ **Post date:** [November 5, 2009, 3:57pm UTC](https://techcommunity.softwareag.com/t/end-transaction-needed-with-oracle/92024/4 "2009-11-05T15:57:02Z")
It’s in the natural parameterfile. So use the natparm program, select the relevant parmfile and then it’s in Database Management /General Parameters Finn ---
**Author:** ![Ats](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Ats](https://techcommunity.softwareag.com/u/Ats)\ **Post date:** [November 5, 2009, 5:19pm UTC](https://techcommunity.softwareag.com/t/end-transaction-needed-with-oracle/92024/5 "2009-11-05T17:19:52Z")
Hi Finn, Thanks for your valuable note. I tried this but no luck. Received below screen but nowhere ‘general parameters’ found. I tried to search the ETEOP but ☹ 05/11/2009 ±------------------------------+ User: (Config) 22:56:30 | ADABAS Parameters | File: NATPARM | Batch Mode | ±---------------------| Buffer Sizes |-----------------------+ |File Edit | Character Assignments | Search | ±---------------------| Compiler Options |-----------------------+ | Database Management System | | DCOM Support | | Devices… | | Environment Assignments | | Error Handling | | Function Keys | | Limits | | Miscellaneous | | Product Configuration… | | Program Loading and Deletion | | Remote… | | Report Parameters | | System Files | | System Variables | | Work Files | | Year 2000 Support | ±------------------------------+ Year 2000 Parameters (DFOUT, DFSTACK, DFTITLE, YSLW) ---
**Author:** ![Ats](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Ats](https://techcommunity.softwareag.com/u/Ats)\ **Post date:** [November 5, 2009, 5:22pm UTC](https://techcommunity.softwareag.com/t/end-transaction-needed-with-oracle/92024/6 "2009-11-05T17:22:28Z")
We are using Natural V5.1.1 on Unix ---
**Author:** ![Finn\_the\_Dane1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/finn_the_dane1/32/132_2.png) [@Finn\_the\_Dane1](https://techcommunity.softwareag.com/u/Finn_the_Dane1)\ **Post date:** [November 5, 2009, 5:42pm UTC](https://techcommunity.softwareag.com/t/end-transaction-needed-with-oracle/92024/7 "2009-11-05T17:42:08Z")
Hi Ats, I don’t have an (ancient;-) 511 available, and neither the documentation… but in your screenshot above there is a "Database Management System " menu item - have you explored that ? Finn PS Current Natural version is 6.3.7 - considering an upgrade ?! ---
**Author:** ![Ats](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Ats](https://techcommunity.softwareag.com/u/Ats)\ **Post date:** [November 5, 2009, 6:00pm UTC](https://techcommunity.softwareag.com/t/end-transaction-needed-with-oracle/92024/8 "2009-11-05T18:00:21Z")
Yes Finn, I checked that option and found nothing. ---
**Author:** ![Finn\_the\_Dane1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/finn_the_dane1/32/132_2.png) [@Finn\_the\_Dane1](https://techcommunity.softwareag.com/u/Finn_the_Dane1)\ **Post date:** [November 5, 2009, 6:27pm UTC](https://techcommunity.softwareag.com/t/end-transaction-needed-with-oracle/92024/9 "2009-11-05T18:27:28Z")
After a little googling for an old manual I found that the ETEOP parameter is new in 6.1.1. - so that explains it’s absence in you parm 😉 Before 611 it was handled by the OPRB parameter! Have a look at the description of the OPRB in you 5.1.1 manual or see the enhancement in the 611 doc here: [http://itmdapps.milwaukee.gov/citygov/natural421/rnarchive/nat611win.pdf](http://itmdapps.milwaukee.gov/citygov/natural421/rnarchive/nat611win.pdf) Finn ---
**Author:** ![Ats](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Ats](https://techcommunity.softwareag.com/u/Ats)\ **Post date:** [November 6, 2009, 9:37am UTC](https://techcommunity.softwareag.com/t/end-transaction-needed-with-oracle/92024/10 "2009-11-06T09:37:54Z")
Got it Finn!!! Thanks a lot! ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 2:57pm UTC](https://techcommunity.softwareag.com/t/end-transaction-needed-with-oracle/92024/11 "2021-04-02T14:57:43Z")