Stack Overflow
Stack Overflow

Questions tagged [vsam]

VSAM is an IBM DASD file storing method.

VSAM stands for Virtual Storage Access Method. This is file storing method by IBM mainframe in DASD format. It consists of four types of data set organizations.

  1. ESDS [Entry Sequenced Data Set]
  2. KSDS [Key Sequenced Data Set]
  3. RRDS & [Relative Record Data Set]
  4. LDS [Linear Data Set]

KSDS is mostly used out of all these four types.

56 questions
4
votes
2 answers

How can I query VSAM data from Java?

Is there a way (JDBC, Resource Adapter, etc) to query VSAM data from Java? Do solutions require something be installed on the VSAM system? If JDBC, what limitations exist on the SQL allowed?
Alex Miller
  • 69,183
  • 25
  • 122
  • 167
3
votes
0 answers

Sequential dataset (like VSAM) for Java

Is there a VSAM-like sequential and/or key-value dataset library for Java? I'm thinking about reading or writing from and to flat files.
matiasf
  • 1,098
  • 1
  • 9
  • 17
3
votes
2 answers

What are the advantages of DB2 over VSAM?

What are the advantages of DB2 over VSAM?
user257912
  • 31
  • 1
  • 2
2
votes
1 answer

File status 39 in VSAM KSDS file

Vsam file creation - //VSAMKSDS JOB CLASS=A,MSGCLASS=A,MSGLEVEL=(1,1),PRTY=15, // NOTIFY=&SYSUID //STEP10 EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* …
Rahul
  • 117
  • 1
  • 14
2
votes
1 answer

How to read VSAM files from z/OS using Java?

I am trying to connect to VSAM files in z/OS in Java. I have tried using VSE Redirector Connector with below code: package test; import java.sql.DriverManager; import java.sql.ResultSetMetaData; public class TestVSAM { public static void…
S Swetha Bathulapalli
  • 21
  • 1
2
votes
1 answer

How to store the credentials of a VSAM password file in COBOL?

This is the code which IBM official page recommends to handle a VSAM password protected file: INPUT-OUTPUT SECTION. FILE-CONTROL. SELECT LIBFILE ASSIGN TO PAYMAST ORGANIZATION IS INDEXED RECORD KEY IS EMPL-NUM PASSWORD…
mllamazares
  • 7,876
  • 17
  • 61
  • 89
2
votes
2 answers

IDCAMS LISTCAT deleting VSAM file when next step is IEFBR14

I have a requirement wherein I need to check if a VSAM file exists or not. If it is not present then I need to create it like TEST.FILE2. My JCL is as : //STEP01 EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* …
user3104950
  • 23
  • 7
2
votes
1 answer

How to do Delete/Define with using IDCAMS using batch JCL (z/VSE)

I have a sample code of delete/define using IDCAMS in z/OS, but I dont think it will work on z/VSE. Can someone help me convert this? The file created should be VSAM-kSDS. //VDFNDEL JOB 1,SAMPLE,MSGCLASS=X //STEP1 EXEC PGM=IDCAMS //SYSPRINT DD…
user2155147
  • 55
  • 2
  • 3
  • 7
2
votes
2 answers

Having trouble writing a Cobol program that pulls information from separate vsam files

I have three VSAM Files. One for customers, videos, and rentals. In these VSAM files each customer, video and rental has an id. Below is an example of the customer file: 300, Bob, 315-123-1414 301, Ryan, 315-213-2617 302, Smith,…
user1486774
  • 107
  • 3
  • 9
1
vote
1 answer

Calculating the record size of alternate index for a VSAM ksds file

In the IBM documentation, the formula to calculate the record size of AIX for a KSDS file is given as 5 + alternate-key length + (n * base cluster's prime-key length) In my case, the alternate-key is non-unique to the value of n, according to the…
Saif
  • 39
  • 8
1
vote
1 answer

Printing records from a VSAM KSDS shows characters with periods

I am trying to view the contents of a VSAM dataset using the following jcl code: //REPRO2 JOB REPROJCL //IDCAMS EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=A //SYSIN DD *,SYMBOLS=EXECSYS PRINT - …
Abel
  • 113
  • 4
1
vote
1 answer

Defining Alternate Index for VSAM KSDS

I have problem defining alternate index for my VSAM KSDS. It says IDC3211I KEYWORD 'DATA' IS IMPROPER Here is my VSAM KSDS definition: DEFINE CLUSTER - (NAME(IBMUSER.TEST.SAMPLE.KSDS) - …
Roger Strycova
  • 109
  • 9
1
vote
1 answer

How does PSP (Rocket Software product) improves performance of Mainframe job

Performance Essential (PSP, Rocket Software offering) reduces the CPU time, I/O for a COBOL program program. How can we do it manually without using their product to calculate optimal balance between memory and speed for Cobol program? One of the…
deepaklearner
  • 151
  • 1
  • 6
  • 22
1
vote
2 answers

How to read VSAM file in Python3

I have VSAM file in the unix system. I want to read the file using the layout of that file in the python. Out of the .idx and .dta, I copied .dta to my local machine and tried to read using the below code, infile =…
Nilesh
  • 69
  • 1
  • 11
1
vote
1 answer

VSAM to DB2 conversion - COBOL

I'm trying to convert a vsam file to db2 table using load utility. However, one of my variables is pic s9(8)v99. When i try to load it into a column decimal(10,2) an error occurs - 02 invalid input numeric. Can you please help?
Ana S.
  • 11
  • 1
1
2 3 4