How different the Natural/DB2 working environment

monasu1998 · Active User Joined: 23 Dec 2005 Posts: 176 Location: India

Hi All,

There are chances that I will be working in a Natural/DB2 project. Could any one help me to understand how different Natural/Db2 environment and what all things need to be considered.

Thanks in Advance

ofer71 · Posted: Thu Aug 23, 2007 11:31 am

Different from what?

O.

dr_te_z · Posted: Thu Aug 23, 2007 11:46 am

It depends:

are you using natural DML (read/histrogram/find) or SQL?
are you allowed (as application programmer) to define DB2-views?

I'd say: use natural DML. Simple.

If you require more than simple access: build a view (containg all the complex-SQL-joins-and-stuff) and access that using simple natural DML!

So, start by bringing the DBA his/her coffee

M Venkatesh · New User Joined: 24 Aug 2007 Posts: 2 Location: Chennai

There are lot of programs in my shop which needs uses Natural/ DB2. For the programming consideration you need not worry. Natural DDM(which is natural view of the Db2 table) is one you will use. When you write your Natural code the, Natural will transalate the these statements into SQL equilavent. I can tell you it is Natural at any given is easier to code.. If you need more information, please get back..