IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Can we use sql in ims database


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
miaoluzeng

New User


Joined: 29 Aug 2007
Posts: 10
Location: CHINA

PostPosted: Mon Apr 14, 2008 11:37 am
Reply with quote

hi all,
the GU GHU GN GNP call.. is difficult for a relational databaser,but as i know the hierarchic database is a kind of relational database.as a pgmer i do not want and need to know the physical operation,so can any tools or program translate sql to ims calls?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Apr 14, 2008 8:09 pm
Reply with quote

Hello miaoluzeng and welcome to the forums,

Quote:
but as i know the hierarchic database is a kind of relational database
No, it is not. Relational concepts may be used when the tables are designed, but the underlying engine is not relational (and is not meant to be).

Quote:
as a pgmer i do not want and need to know the physical operation
If you intend to be a productive ims programmer, you do. One of the reasons that ims has such high performance is that there is the ability to specifically direct the processing flow at a lower level.

There may be some add-on products that provide some sql front-end, but i'll let those more deeply versed in ims tools reply.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue Apr 15, 2008 9:12 am
Reply with quote

SQL is not available for IMS.

If you dont want to write IMS calls, then you have to develop some IO routines and give it to other programmers including you which will allow you not to worry about the IMS calls.

There are some 3rd party tools like Telon with IMS.
Back to top
View user's profile Send private message
miaoluzeng

New User


Joined: 29 Aug 2007
Posts: 10
Location: CHINA

PostPosted: Tue Apr 15, 2008 9:55 am
Reply with quote

hi dick scherrer,
thanks a lot for your answer, but i still have troubles about the basic.
Quote:
Relational concepts may be used when the tables are designed, but the underlying engine is not relational (and is not meant to be).

the internal engine of relational database is not relational,then the hierarchial database engine is not hierarchial?
if yes
how can ims optimize performance?
else
as we know the two types of database:relational and hierarchial,now one is for logical design the other is for physical...i think it is difficult to explain it.
Back to top
View user's profile Send private message
miaoluzeng

New User


Joined: 29 Aug 2007
Posts: 10
Location: CHINA

PostPosted: Tue Apr 15, 2008 10:23 am
Reply with quote

Devzee wrote:
SQL is not available for IMS.

If you dont want to write IMS calls, then you have to develop some IO routines and give it to other programmers including you which will allow you not to worry about the IMS calls.

There are some 3rd party tools like Telon with IMS.

hi Devzee,
so in this way some programers manually translate my io to ims calls.but i think the best way is use translation's program(if have).
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Tue Apr 15, 2008 10:48 am
Reply with quote

Quote:
...the internal engine of relational database is not relational,then the hierarchial database engine is not hierarchial?


It would be wise to review Your understandings of databases archtecture

the internal engines are exactly what the name suggests
relational and hierarchical
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Apr 15, 2008 11:51 am
Reply with quote

Hello,

Quote:
the internal engine of relational database is not relational,then the hierarchial database engine is not hierarchial?
This might make for interesting phylosophical discussion. . . . I'm not sure how it applies to implementing an application.

Quote:
as we know the two types of database:relational and hierarchial,now one is for logical design the other is for physical...
I believe that we do not all know this - it is bacically not accurate. There are logical and physical aspects of all database applications.

Quote:
i think it is difficult to explain it.
Things not understood clearly are most difficult to explain icon_smile.gif

Quote:
how can ims optimize performance
A short answer is that ims typically requires far less overhead than DB2. If this is not what you are asking, please clarify.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Tue Apr 15, 2008 6:41 pm
Reply with quote

I need to add my two cents. IMS is the best thing ever invented - it is extremely fast and accurate - it was invented for the first US moon mission. All the major transaction processing banks use it. It also requires some effort to become good at it.
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Wed Apr 16, 2008 1:56 am
Reply with quote

miaoluzeng wrote:
hi all,
the GU GHU GN GNP call.. is difficult for a relational databaser,but as i know the hierarchic database is a kind of relational database.as a pgmer i do not want and need to know the physical operation,so can any tools or program translate sql to ims calls?


First the basic question: no..... there's no transalation from sql to ims.

The reason why: the hierarchic database is NOT a kind of relational database. The only relationship is that pfysical IMS databases can be combined into logical databases. The basics however differ very much from the way DB2-tables are joined. A join of a couple of DB2-tables leads to an explosion of intermediate tables. IMS is just hierarchical and uses the index for that. As stated before an IMS programmer is able (in co-orporation with the DBA) to find the most perfect pathcalls in order to use the best calls for a perfect performance. Like Sandy wrote it's a matter of understanding how to access the database. If you don't understand the way IMS works it's hardly no use to try and develop programs in it; unlike DB2 and SQL IMS-programming is an art icon_wink.gif
Back to top
View user's profile Send private message
miaoluzeng

New User


Joined: 29 Aug 2007
Posts: 10
Location: CHINA

PostPosted: Fri Apr 18, 2008 11:21 am
Reply with quote

hi all,
it found some tools depand on my mind,
it can use sql->websphere->ims.

let's see www.ibm.com/developerworks/db2/library/techarticle/dm-0504zikopoulos/
"DB2 Connect can to deliver transparent access to other data sources such as Oracle, Microsoft SQL Server, Sybase, IMS, VSAM, and a whole host of other data sources."

before i found this, i just think we can use pgm to translate sql to imscalls and the pgm just needs parse DBD and SQL sentence.maybe someone had developed it yet, so i write the topic.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Fri Apr 18, 2008 4:21 pm
Reply with quote

Have you tried to use it?
Back to top
View user's profile Send private message
miaoluzeng

New User


Joined: 29 Aug 2007
Posts: 10
Location: CHINA

PostPosted: Mon Apr 21, 2008 1:08 pm
Reply with quote

no,i have no chance to use it and no one knows it around me,so bad icon_cry.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts What database does Jobtrac use CA Products 4
No new posts Capturing COBOL job and program names... All Other Mainframe Topics 2
No new posts Products/Tools to Optimize Adabas Dat... Compuware & Other Tools 2
No new posts AUTHORIZED database error in HALDB IMS DB/DC 2
No new posts linking an ALC program to a Relationa... PL/I & Assembler 1
Search our Forums:

Back to Top