Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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
No new posts LIBDEF not working in called proc packerm CLIST & REXX 0 Fri Sep 15, 2017 7:22 pm
No new posts Working with hex values in Filemanage... Emile Straker IBM Tools 0 Tue Sep 12, 2017 1:42 am
No new posts ISREDIT MACRO NOT WORKING! :cry: kirank889 TSO/ISPF 3 Thu Aug 03, 2017 5:46 pm
No new posts Reg:Displaying the particular month o... bhavana yalavarthi All Other Mainframe Topics 4 Sat Jul 08, 2017 8:13 pm
No new posts Restart=Step not working ALAK SAHA JCL & VSAM 6 Fri Jun 30, 2017 6:28 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us