Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How different the Natural/DB2 working environment

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries
View previous topic :: :: View next topic  
Author Message
monasu1998

Active User


Joined: 23 Dec 2005
Posts: 176
Location: India

PostPosted: Thu Aug 23, 2007 8:56 am    Post subject: How different the Natural/DB2 working environment
Reply with quote

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
Back to top
View user's profile Send private message

ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Thu Aug 23, 2007 11:31 am    Post subject:
Reply with quote

Different from what?

O.
Back to top
View user's profile Send private message
dr_te_z

New User


Joined: 08 Jun 2007
Posts: 71
Location: Zoetermeer, the Netherlands

PostPosted: Thu Aug 23, 2007 11:46 am    Post subject:
Reply with quote

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 icon_smile.gif
Back to top
View user's profile Send private message
M Venkatesh

New User


Joined: 24 Aug 2007
Posts: 2
Location: Chennai

PostPosted: Fri Aug 24, 2007 12:57 pm    Post subject:
Reply with quote

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.. icon_biggrin.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Natural ADABAS Opening with CTS enikhilk Mainframe Jobs 0 Wed Nov 30, 2016 5:37 pm
No new posts SCRNAME not working on my mainframe? mrsidhu12 TSO/ISPF 7 Thu Sep 01, 2016 2:17 pm
No new posts Casting a Binary Number to Numeric in... Bob Steinkraus Java & MQSeries 6 Tue Aug 09, 2016 5:58 pm
No new posts 2 same CLIST pgm but with different n... boyti ko CLIST & REXX 5 Fri Jun 03, 2016 4:55 pm
No new posts REXX Screen not working due to LINKED... sundarkudos CLIST & REXX 1 Mon May 09, 2016 1:44 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us