|
|
| Author |
Message |
Pankaj Gupta
New User
Joined: 07 May 2008
Posts: 32
Location: Bangalore
|
|
|
|
Hello everyone,
I am having a problem with my SQLS to access data in IMS DB databases.
It is not compiling but I am having DFSRC000 in my jcls. |
|
| Back to top |
|
 |
References
|
|
 |
kalukakkad
Active User
Joined: 10 Mar 2005
Posts: 73
|
|
|
|
Can you give more detail about the problem you are facing.
Your statement below is not clear.
"I am having a problem with my SQLS to access data in IMS DB databases.
It is not compiling but I am having DFSRC000 in my jcls." |
|
| Back to top |
|
|
enrico-sorichetti
Global Moderator
Joined: 14 Mar 2007
Posts: 3277
Location: italy
|
|
|
|
not to be rude, but it would be wise to review Your understanding of the issue
and the relations between IMS SQL DFSRRC00
| Quote: |
| I am having a problem with my SQLS to access data in IMS DB databases |
SQL is not used to access IMS databases
| Quote: |
| It is not compiling but I am having DFSRC000 in my jcls. |
DFSRRC00 is used to run/execute a program ( load module )
ask Your peers or Your support for the proper procedures
to be used for the different tasks
the program containing Your quoted text will not compile because the
format of the query is ... wrong
read and try to understand the error messages and search them in the manual
and if something is not clear post again |
|
| Back to top |
|
|
Sandy Zimmer
Senior Member
Joined: 13 Jun 2007
Posts: 472
Location: Wilmington, DE
|
|
|
|
| Unless something new and great has happened - IMS is NOT accessible by SQL commands. You would need to write an IMS program to extract data from your DB2 database first - load it - then write and IMS program to retrieve it. IMS is completely different from relational database theory. |
|
| Back to top |
|
|
Pankaj Gupta
New User
Joined: 07 May 2008
Posts: 32
Location: Bangalore
|
|
|
|
| But underneath it is being the same databses? There is one database and we can be choosing to use the sqls or ims to retrieve the datas, depending if we are IMS or DB2 programmer. |
|
| Back to top |
|
|
PeD
Senior Member
Joined: 26 Nov 2005
Posts: 354
Location: Belgium
|
|
|
|
maybe VSAm files underneath but relational is not hierarchical
Each has its own access mode |
|
| Back to top |
|
|
dick scherrer
Global Moderator
Joined: 23 Nov 2006
Posts: 9183
Location: 221 B Baker St
|
|
|
|
Hello,
| Quote: |
But underneath it is being the same databses? There is one database and we can be choosing to use the sqls or ims to retrieve the datas, depending if we are IMS or DB2 programmer.
|
Underneath it is far from being the same "database". Before attempting any more code, i suggest you do some major review of the functionality available to you with each "environment".
While there is some truth to saying that vsam, ims, and db2 are all vsam implementations, there is nothing useful in the statement. While ims and db2 "ride" on "vsam files", these vsam files are not to be used directly by the programmer (ims is in a proprietary format only meant to be accessed by ims and db2 uses something called Linear Data Sets (LDS). If the database is ims, the code uses ims calls. If the database is db2, the code uses sql (one needs to also be careful not to equate DB2, Oracle, and SQLServer sql - they are not completely the same).
Whether to use vsam, ims, or sql is not interchangeable - the coder does not get to choose how data will be accessed. The data needs to be accessed the way it is managed. |
|
| Back to top |
|
|
|
|
