# \#Natural-Database-Interfaces-on-Open-Systems **URL:** https://techcommunity.softwareag.com/tag/natural-database-interfaces-on-open-systems/129.md [Latest](https://techcommunity.softwareag.com/latest.md) · [Categories](https://techcommunity.softwareag.com/categories.md) · [Tags](https://techcommunity.softwareag.com/tags.md) --- ## [Why Natural to started ADABAS user session with an implicit OPEN](https://techcommunity.softwareag.com/t/why-natural-to-started-adabas-user-session-with-an-implicit-open/227140)
**Author:** [@Boris\_Zaslavskiy](https://techcommunity.softwareag.com/u/Boris_Zaslavskiy)\ **Replies:** 5\ **Last updated:** [June 4, 2020, 9:10pm UTC](https://techcommunity.softwareag.com/t/why-natural-to-started-adabas-user-session-with-an-implicit-open/227140 "2020-06-04T21:10:03Z")
What could be a cause for Natural to start ADABAS user session with an implicit OPEN? Extract from adaopr di=uq: session started with an implicit OPEN has blank User Id ES-Id\_\_\_User Id\_\_\_Type\_\_Status 30194\_\_\_\_\_\_\_\_\_\_\_… --- ## [NAT3041 - Just installed Natural for windows CE](https://techcommunity.softwareag.com/t/nat3041-just-installed-natural-for-windows-ce/208051)
**Author:** [@sathya7586](https://techcommunity.softwareag.com/u/sathya7586)\ **Replies:** 2\ **Last updated:** [April 27, 2020, 9:59pm UTC](https://techcommunity.softwareag.com/t/nat3041-just-installed-natural-for-windows-ce/208051 "2020-04-27T21:59:15Z")
Hi all, I installed natural CE for windows and am able to execute a hello world program. I read in the site that installation already comes with adabas. However im unable to access my new ddm or any existing sample ddms… --- ## [How to call Java programs from Natural program](https://techcommunity.softwareag.com/t/how-to-call-java-programs-from-natural-program/200514)
**Author:** [@Tushar\_Patil](https://techcommunity.softwareag.com/u/Tushar_Patil)\ **Replies:** 0\ **Last updated:** [August 17, 2018, 10:03am UTC](https://techcommunity.softwareag.com/t/how-to-call-java-programs-from-natural-program/200514 "2018-08-17T10:03:22Z")
As of now i have Natural program calling COBOL program but COBOL programs are getting replaced with JAVA programs now. In this case how to call JAVA programs from Natural program ? --- ## [Why is Multi-fetch limited to a 4k buffer?](https://techcommunity.softwareag.com/t/why-is-multi-fetch-limited-to-a-4k-buffer/194554)
**Author:** [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\ **Replies:** 2\ **Last updated:** [May 13, 2017, 1:45am UTC](https://techcommunity.softwareag.com/t/why-is-multi-fetch-limited-to-a-4k-buffer/194554 "2017-05-13T01:45:54Z")
DEFINE DATA LOCAL 1 EMP VIEW EMPLOYEES 2 ADDRESS-LINE (101) 1 REDEFINE EMP 2 #LEN (A2020) END-DEFINE LIMIT 10 R. READ MULTI-FETCH ON EMP PHYSICAL END-READ WRITE \*COUNTER (R.) (SG=F AD=L) END With MUL… --- ## [Problem : Natural for Windows -\> Entire Access -\> Oracle 11g](https://techcommunity.softwareag.com/t/problem-natural-for-windows-entire-access-oracle-11g/101852)
**Author:** [@Rd\_Lau](https://techcommunity.softwareag.com/u/Rd_Lau)\ **Replies:** 1\ **Last updated:** [December 5, 2012, 2:49pm UTC](https://techcommunity.softwareag.com/t/problem-natural-for-windows-entire-access-oracle-11g/101852 "2012-12-05T14:49:20Z")
Hi all, I am testing Natural for Windows (community version) + Entire Access + Oracle 11g and encountered the following problems: Some details: 2 Oracle 11g - 1 local Orcale in Windows, 1 remote Oracle in Linux DBMS … --- ## [Accessing Postgresql from Natural](https://techcommunity.softwareag.com/t/accessing-postgresql-from-natural/101687)
**Author:** [@Axt](https://techcommunity.softwareag.com/u/Axt)\ **Replies:** 4\ **Last updated:** [October 31, 2012, 11:49am UTC](https://techcommunity.softwareag.com/t/accessing-postgresql-from-natural/101687 "2012-10-31T11:49:20Z")
Hi people, I’m trying to access a PostgreSQL 8.1.23 database on a x86\_64-redhat-linux. Step done are: Postgresql installation Postgresql odbc driver installation Odbc manager installation. Natural 6.3.12 installation E… --- ## [How to use CALLDBPROC](https://techcommunity.softwareag.com/t/how-to-use-calldbproc/61571)
**Author:** [@half-time](https://techcommunity.softwareag.com/u/half-time)\ **Replies:** 3\ **Last updated:** [May 16, 2012, 5:33pm UTC](https://techcommunity.softwareag.com/t/how-to-use-calldbproc/61571 "2012-05-16T17:33:06Z")
Hi everyone, I am trying to use CALLDBPROC on Windows and Unix and I have some problems (and doubts). I have installed Natural 611 PL17, Entire Access 531 and Oracle 10g. The application is using the statement standar… --- ## [NAT3520 ORACLE error :1: occurred. - CALLDBPROC for Oracle](https://techcommunity.softwareag.com/t/nat3520-oracle-error-occurred-calldbproc-for-oracle/100565)
**Author:** [@Kevin\_Brown1](https://techcommunity.softwareag.com/u/Kevin_Brown1)\ **Replies:** 3\ **Last updated:** [May 16, 2012, 4:45pm UTC](https://techcommunity.softwareag.com/t/nat3520-oracle-error-occurred-calldbproc-for-oracle/100565 "2012-05-16T16:45:57Z")
I am running the following code and getting error the error: NAT3520 ORACLE error :1: occurred. TEXT: Internal ORACLE error :1: occurred. EXPL: ORACLE has encountered an internal error. ACTN: For more information s… --- ## [Natural community edition and Entire Access](https://techcommunity.softwareag.com/t/natural-community-edition-and-entire-access/100524)
**Author:** [@Kevin\_Brown1](https://techcommunity.softwareag.com/u/Kevin_Brown1)\ **Replies:** 5\ **Last updated:** [May 12, 2012, 2:21am UTC](https://techcommunity.softwareag.com/t/natural-community-edition-and-entire-access/100524 "2012-05-12T02:21:56Z")
I have installed Natural community edition and want to access Oracle databae. I dont have Entire Access and I dont see any website for it or download link etc. For learning Natrual with Oracle is there some documentati… --- ## [Access Oracle table from Natural for Windows](https://techcommunity.softwareag.com/t/access-oracle-table-from-natural-for-windows/76271)
**Author:** [@Osman\_Sanchez](https://techcommunity.softwareag.com/u/Osman_Sanchez)\ **Replies:** 1\ **Last updated:** [May 9, 2012, 2:41am UTC](https://techcommunity.softwareag.com/t/access-oracle-table-from-natural-for-windows/76271 "2012-05-09T02:41:47Z")
Hi everyone, I am trying to access an Oracle table from Natural via ODBC and I’ve got a problem when the key is defined as varchar. Have you ever heard something related to?. I asked to the customer who reported me that… --- ## [Multi-fetch support](https://techcommunity.softwareag.com/t/multi-fetch-support/100118)
**Author:** [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\ **Replies:** 0\ **Last updated:** [April 9, 2012, 8:26pm UTC](https://techcommunity.softwareag.com/t/multi-fetch-support/100118 "2012-04-09T20:26:27Z")
This is from the Natural for Windows documentation for the READ statement. Would someone please explain its rationale? It would make sense to me when processing LOBs, but what if they are not involved? Is Adabas perf… --- ## [Natural for Windows--Connect to Mainframe ADABAS](https://techcommunity.softwareag.com/t/natural-for-windows-connect-to-mainframe-adabas/91258)
**Author:** [@JoeV](https://techcommunity.softwareag.com/u/JoeV)\ **Replies:** 6\ **Last updated:** [September 17, 2009, 10:37pm UTC](https://techcommunity.softwareag.com/t/natural-for-windows-connect-to-mainframe-adabas/91258 "2009-09-17T22:37:48Z")
Hello: I’ve downloaded and installed Natural for Windows Community Edition. I would like to run some Natural programs on it and read ADABAS files from our mainframe Development environment. How do I connect? Also, is… --- ## [How can I access Ms SQL Server 5](https://techcommunity.softwareag.com/t/how-can-i-access-ms-sql-server-5/90953)
**Author:** [@Osman\_Sanchez](https://techcommunity.softwareag.com/u/Osman_Sanchez)\ **Replies:** 1\ **Last updated:** [August 13, 2009, 10:30pm UTC](https://techcommunity.softwareag.com/t/how-can-i-access-ms-sql-server-5/90953 "2009-08-13T22:30:03Z")
Hello Everyone, I would like to know what do I do to access MS SQL Server 5 from Natural 6.1.1?, Where I can find information about it? Regards --- ## [How many records is ON?](https://techcommunity.softwareag.com/t/how-many-records-is-on/80715)
**Author:** [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\ **Replies:** 1\ **Last updated:** [April 15, 2009, 11:07am UTC](https://techcommunity.softwareag.com/t/how-many-records-is-on/80715 "2009-04-15T11:07:10Z")
On a mainframe you specify MULTI-FETCH number For Open Systems you specify MULTI-FETCH ON To determine the number of records returned by Open Systems, I ran the following DEFINE DATA LOCAL 1 EMP VIEW EMPLOYEES 2 … --- ## [Multi-fetch settings ignored](https://techcommunity.softwareag.com/t/multi-fetch-settings-ignored/80710)
**Author:** [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\ **Replies:** 1\ **Last updated:** [April 15, 2009, 11:03am UTC](https://techcommunity.softwareag.com/t/multi-fetch-settings-ignored/80710 "2009-04-15T11:03:48Z")
Windows XP; Natural 635; Adabas 614 In NATPARMs MFSET=ON, but when I RUN or EXecute the following program, Adabas does not return multiple records with each call. DEFINE DATA LOCAL 1 EMP VIEW EMPLOYEES 2 PERSONNEL… --- ## [NATURAL access to SQL Server](https://techcommunity.softwareag.com/t/natural-access-to-sql-server/79089)
**Author:** [@storm](https://techcommunity.softwareag.com/u/storm)\ **Replies:** 3\ **Last updated:** [September 23, 2008, 5:19pm UTC](https://techcommunity.softwareag.com/t/natural-access-to-sql-server/79089 "2008-09-23T17:19:09Z")
Hi, I recently downloaded the community editions of NATURAL and ADABAS. I had no problem accessing the ADABAS database. However, I am facing difficulty in accessing the MS SQL Server. I have the DBID and still I am unab… --- ## [Acceding MySQL from Natural](https://techcommunity.softwareag.com/t/acceding-mysql-from-natural/76475)
**Author:** [@Osman\_Sanchez](https://techcommunity.softwareag.com/u/Osman_Sanchez)\ **Replies:** 2\ **Last updated:** [August 30, 2008, 2:34am UTC](https://techcommunity.softwareag.com/t/acceding-mysql-from-natural/76475 "2008-08-30T02:34:49Z")
Hello everyone!!! I would like to know if someone of you were read data from Natural to MySQL. If you done how did you do?. I read something about CALLDBPROC used to access Oracle DB. Can I use CALLDBPROC to access MySQ… --- ## [NAT6235 error](https://techcommunity.softwareag.com/t/nat6235-error/78290)
**Author:** [@sotretus](https://techcommunity.softwareag.com/u/sotretus)\ **Replies:** 3\ **Last updated:** [June 16, 2008, 8:31pm UTC](https://techcommunity.softwareag.com/t/nat6235-error/78290 "2008-06-16T20:31:37Z")
Hello Guys, we are running a natural program that came up with a NAT6235 Internal error during processing of operation stack. VVVVVVVVVVVVVVVVVVVVVVVVVVVVVVV 2856 READ WORK FILE 3 RECORD FILE01 Contact Software AG An… --- ## [Setup in Linux environment](https://techcommunity.softwareag.com/t/setup-in-linux-environment/76895)
**Author:** [@Sathya](https://techcommunity.softwareag.com/u/Sathya)\ **Replies:** 0\ **Last updated:** [June 9, 2008, 4:13pm UTC](https://techcommunity.softwareag.com/t/setup-in-linux-environment/76895 "2008-06-09T16:13:10Z")
I have the Natural code developed and the databases created in Oracle. I want to setup the runtime Natural code in zLinux OS server, Oracle as the database. The client mechines are going to run in the windows environment… --- ## [Reading XLS with Natural windows (SPOD)](https://techcommunity.softwareag.com/t/reading-xls-with-natural-windows-spod/76405)
**Author:** [@alphonsstijnen](https://techcommunity.softwareag.com/u/alphonsstijnen)\ **Replies:** 2\ **Last updated:** [March 28, 2008, 12:28am UTC](https://techcommunity.softwareag.com/t/reading-xls-with-natural-windows-spod/76405 "2008-03-28T00:28:42Z")
Is there a way to read Excel files with Natural for Windows (SPOD)?? If yes, do you have a piece of example code --- ## [Reading XLS with Natural windows (SPOD)](https://techcommunity.softwareag.com/t/reading-xls-with-natural-windows-spod/76404)
**Author:** [@alphonsstijnen](https://techcommunity.softwareag.com/u/alphonsstijnen)\ **Replies:** 1\ **Last updated:** [March 20, 2008, 7:07pm UTC](https://techcommunity.softwareag.com/t/reading-xls-with-natural-windows-spod/76404 "2008-03-20T19:07:31Z")
Is there a way to read Excel files with Natural for Windows (SPOD)?? If yes, do you have a piece of example code --- ## [Natural and Adabas Long Variables](https://techcommunity.softwareag.com/t/natural-and-adabas-long-variables/75439)
**Author:** [@Tom\_Philpott](https://techcommunity.softwareag.com/u/Tom_Philpott)\ **Replies:** 0\ **Last updated:** [September 27, 2007, 4:19am UTC](https://techcommunity.softwareag.com/t/natural-and-adabas-long-variables/75439 "2007-09-27T04:19:17Z")
It is not clear to me through the documentation as to which version of Natural on Open Systems supports the Adabas 5.1 long variables and the Adabas 6.1 long variables. Thanks --- ## [Natural return NAT3224 under Windows](https://techcommunity.softwareag.com/t/natural-return-nat3224-under-windows/75231)
**Author:** [@Osman\_Sanchez](https://techcommunity.softwareag.com/u/Osman_Sanchez)\ **Replies:** 2\ **Last updated:** [August 22, 2007, 1:54am UTC](https://techcommunity.softwareag.com/t/natural-return-nat3224-under-windows/75231 "2007-08-22T01:54:57Z")
Hi everyone, I would like to know if someone of you can help me in regards of the following problem. We have a customer who suddenly is receiving a NAT3224. The Production environment is: ADA331, NAT611, WCP2610. I alre… --- ## [Natural and DB2 on XP](https://techcommunity.softwareag.com/t/natural-and-db2-on-xp/62273)
**Author:** [@Marcelo\_Shulman](https://techcommunity.softwareag.com/u/Marcelo_Shulman)\ **Replies:** 6\ **Last updated:** [June 15, 2007, 12:09am UTC](https://techcommunity.softwareag.com/t/natural-and-db2-on-xp/62273 "2007-06-15T00:09:16Z")
Dear people: I’m working for IBM now, my T60 Thinkpad (Windows XP) has DB2 UDB installed; I also installed Natural Studio 6.2.3 and ADABAS 5.1.5 but I don’t know how to connect them. Can you help me? Many thanks… --- ## [Natural calls Oracle - several instances](https://techcommunity.softwareag.com/t/natural-calls-oracle-several-instances/61636)
**Author:** [@half-time](https://techcommunity.softwareag.com/u/half-time)\ **Replies:** 0\ **Last updated:** [October 28, 2006, 12:25am UTC](https://techcommunity.softwareag.com/t/natural-calls-oracle-several-instances/61636 "2006-10-28T00:25:54Z")
Hi, I have an application on mainframe that needs to call via RPC a subprogram that access Oracle. The problem on it is that depend on the situation, the mainframe application needs to call a different Oracle instance. … --- ## [3148 : Database 3 is not active or not accessible](https://techcommunity.softwareag.com/t/3148-database-3-is-not-active-or-not-accessible/61392)
**Author:** [@papajohn](https://techcommunity.softwareag.com/u/papajohn)\ **Replies:** 4\ **Last updated:** [September 9, 2006, 12:37am UTC](https://techcommunity.softwareag.com/t/3148-database-3-is-not-active-or-not-accessible/61392 "2006-09-09T00:37:31Z")
I am getting this message trying to execute a program that reads a file which only exists in one Database, 10. DDM is defined to Security, I have all the links set. Our Testing Database is TEST10, I have no clue where it… --- ## [Natural Native Interface and ADABAS](https://techcommunity.softwareag.com/t/natural-native-interface-and-adabas/61369)
**Author:** [@Eng1958](https://techcommunity.softwareag.com/u/Eng1958)\ **Replies:** 2\ **Last updated:** [August 25, 2006, 8:15pm UTC](https://techcommunity.softwareag.com/t/natural-native-interface-and-adabas/61369 "2006-08-25T20:15:06Z")
Hello, I’m trying to use the Natural Native Interface to call a NATURAL subprogram. In this subprogramm everything works fine, when there is no access to the database. When a do a FIND or anything else in this subprog… --- ## [I wish to invoke a Function in Oracle](https://techcommunity.softwareag.com/t/i-wish-to-invoke-a-function-in-oracle/60078)
**Author:** [@Mike\_Brice](https://techcommunity.softwareag.com/u/Mike_Brice)\ **Replies:** 2\ **Last updated:** [July 26, 2005, 5:31pm UTC](https://techcommunity.softwareag.com/t/i-wish-to-invoke-a-function-in-oracle/60078 "2005-07-26T17:31:20Z")
I am using Entire Access to talk to Oracale and would like to invoke a Function defined in an Oracle package. I have been able to call a stored procedure uisng the following syntax Process SQL DDM-ORACLE \<\< Begin pack… --- ## [Tamino](https://techcommunity.softwareag.com/t/tamino/60057)
**Author:** [@Gyro\_Gearloose](https://techcommunity.softwareag.com/u/Gyro_Gearloose)\ **Replies:** 2\ **Last updated:** [July 2, 2005, 3:44pm UTC](https://techcommunity.softwareag.com/t/tamino/60057 "2005-07-02T15:44:48Z")
Ladies and Gentlemen, can I access the Tamino server the same way as I do already access the Adabas ? Thank You.