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
0
votes
2 answers

Browsing VSAM files and DB2 tables using TSQ

I'm finding better ways on browsing VSAM records and DB2 tables in CICS. The current one I'm practicing is by using readnext/prev for browsing VSAM files and using cursors to browse DB2 tables. How can I utilize TSQ when I do browsing of…
Roger Strycova
  • 109
  • 9
0
votes
1 answer

How to calculate space allocated to VSAM files

I am creating a tool which will estimated space should be given to the VSAM file based on number of records, record length and block size parameters. While going through different sources on internet I got an article on IBM website about space…
Siddhesh
  • 179
  • 2
  • 12
0
votes
1 answer

Can you loop on a single file with SSIS?

I have a EBCDIC (Mainframe) VSAM file without any carriage return. It is like a million characters long. With SSIS, could I loop on the file's single line and add a carriage return each time I hit the SIN of the first record type? (record control…
user6854154
  • 67
  • 1
  • 1
  • 4
0
votes
1 answer

LOGSTREAMID parameter for VSAM

I'm trying to alter a vsam file for write logs for any update operation. I perform the updates through a cics transaction. Can anyone give me an idea, how can i save immediately all updates in logstream file?
neo
  • 33
  • 1
  • 8
0
votes
0 answers

Record count and Filename from VSAM Source EBCDIC encoding in Informatica PowerCenter

I need to get the filename and then count the number of records in that VSAM source file in Informatica PowerCenter 10. I had already done similar thing with other flat files in which from the source instance I can get the file name by checking…
KeenLearner
  • 685
  • 1
  • 8
  • 25
0
votes
1 answer

Pointer position at the time of VSAM START command

I am a bit confused. I know when you START a VSAM file, a pointer is set to a specific record, which will be read by subsequent READ command. Let's assume that VSAM has records: 100 200 300 400 500 When you write: START filename KEY IS…
Vivek8086
  • 47
  • 5
0
votes
1 answer

Logic to Delete record from VSAM file

I have Input file as VSAM file and Parm value passed from JCL. if these two match the record needs to be deleted from the input VSAM file. Please could you give me the logic in Cobol code for this.
Sunitha S
  • 1
  • 1
  • 3
0
votes
2 answers

Calcite for VSAM

I am trying to expose Mainframe files for more dynamic use from both COBOL programs and external programs in Java. My reading shows that I can configure COBOL to use a JDBC connection. This may be just configuration in the JCL but I assume it is…
Mr-H
  • 21
  • 1
0
votes
2 answers

PowerCenter Designer issue with COBOL VSAM file

I'm working in PowerCenter Designer on a Cobol Mainframe VSAM sourcefile and need to know what values in Prec and Scale should I use to get a PIC S9(9)V99 COMP-3... A coworker mentioned Informatica recognizes it like PIC S9(9)V9(2) COMP-3, and so I…
Ciro1977
  • 1
0
votes
1 answer

Extended VSAM allocation

I have been tasked with a project that requires a VSAM file over the 4GB limit. I am trying to define an extended VSAM using IDCAM, but I cannot find an example or guide to help me. This is how I would define a regular VSAM: //STEP1 EXEC…
SaggingRufus
  • 1,814
  • 16
  • 32
0
votes
0 answers

How to specify COBOL copybook in Sqoop + OpenSource Syncsort

I'm trying to import some VSAM files from Mainframe into Hive. https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_purpose_3 I found out that Sqoop 1.4.6 includes Syncsort as an Open-Source contrib. I went through the documentation and it is…
Diego Moreira
  • 21
  • 4
0
votes
1 answer

How to replicate VSAM files (Mainframe) to Database?

What is an efficient solution/technology (other than ETL) to do a near real-time replication of data from a VSAM file (Mainframe) to an RDBMS (outside Mainframe) ? Note: This VSAM file has COM3 data, so the replication technology should be able to…
yathirigan
  • 5,619
  • 22
  • 66
  • 104
0
votes
3 answers

How to manually edit the key of a KSDS VSAM file?

I have a KSDS file. I want to change the key of the file for testing purposes. I am unable to edit the key in File-Aid. Is there any way to do that ? I have searched multiple forums, unable to find an answer.
Soumendra
  • 1,518
  • 3
  • 27
  • 54
0
votes
2 answers

VSAM Search VS COBOL search/loop

I have a file that could contain about 3 million records. Certain records of this file will need to be updated multiple times throughout the run of the program. If I need to pull specific records from this file, which of the following is more…
SaggingRufus
  • 1,814
  • 16
  • 32
0
votes
0 answers

How to resolve Vsam File status error code 93?

When I am trying to access a Vsam Sequential dataset(which is also opened in CICS) from batch, I use EXTEND mode to open the file and append some data to it. Earlier it was working fine. All of a sudden , it is not working now and I am getting File…
Dineshbabu Nandakumar
  • 1
  • 1
  • 2
1 2
3
4