| View previous topic :: View next topic |
| Author |
Message |
jyotika_anand
Beginner
Joined: 28 Nov 2005
Posts: 5
Topics: 3
|
 Posted: Mon Nov 28, 2005 11:30 am Post subject: VSAM error code of 37 |
 |
|
Hi Phantom,
This might be a silly question to you, but its becoming a problem for me. I am a fresher and having a problem with VSAM error code of 37.
I want to use a QSAM file in the program and the SELECT statement is
SELECT CMRC assign to DDCMR
file status is W500-CMR
In the run JCL, everytime it runs it deletes the file and creates the same file afresh.
This error comes while OPENING the file.
Can you help me in this? Also what is the difference between QSAM & VSAM file ?
Don't you require, ACCESS MODE for a QSAM file. If yes? what would that be?
I am just a fresher so please bear with me.
Regards,
Jyotika |
|
| Back to top |
|
 |
Manas Biswal
Intermediate
Joined: 29 Nov 2002
Posts: 382
Topics: 27
Location: Chennai, India
|
| Posted: Mon Nov 28, 2005 11:42 am Post subject: |
|
|
jyotika_anand,
What mode are you opening the file in?
Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948) |
|
| Back to top |
|
|
jyotika_anand
Beginner
Joined: 28 Nov 2005
Posts: 5
Topics: 3
|
| Posted: Mon Nov 28, 2005 11:55 am Post subject: |
|
|
Hi,
This is what I have coded
SELECT CMR-FILE ASSIGN TO DDCMR
FILE STATUS IS W500-STATUS-CMR.
and the file is OPEN in OUTPUT mode.
Regards,
Jyotika |
|
| Back to top |
|
|
Cogito-Ergo-Sum
Advanced
Joined: 15 Dec 2002
Posts: 637
Topics: 43
Location: Bengaluru, INDIA
|
| Posted: Mon Nov 28, 2005 1:05 pm Post subject: |
|
|
Jyotika,
Can you please paste your job ?
_________________
ALL opinions are welcome.
Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12384
Topics: 75
Location: San Jose
|
| Posted: Mon Nov 28, 2005 2:02 pm Post subject: |
|
|
jyotika_anand,
You get a file status of 37 in the following conditions
An OPEN statement was attempted on a file that would not support the open mode specified in the OPEN statement. Possible violations are:
1. The EXTEND or OUTPUT phrase was specified but the file would not support write operations.
2. The I-O phrase was specified but the file would not support the input and output
operations permitted.
3. The INPUT phrase was specified but the file would not support read operations.
4. Under VSE, the EXTEND phrase was specified for a SAM file.
Check this link which explains in detail about vsam and Qsam
http://www.simotime.com/utldat01.htm
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
jyotika_anand
Beginner
Joined: 28 Nov 2005
Posts: 5
Topics: 3
|
| Posted: Wed Nov 30, 2005 1:39 am Post subject: Thanks |
|
|
| Thanx Kolusu for the reply, but I haven't tried it out yet. I will reply back if I have any problems with the QSAM file. |
|
| Back to top |
|
|
Phantom
Data Mgmt Moderator
Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet
|
| Posted: Wed Nov 30, 2005 9:35 am Post subject: |
|
|
jyotika_anand,
When posting any queries, please do not address it to any one particular person. We have a whole group of SMEs (Subject Matter Experts) in this forum who will be answering your queries.
I was a bit too busy for a couple of days. Anyway I am glad that you got the solution.
Thanks,
Phantom |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
