Need a valid VSAM file sample



Help for IBM's record-oriented filesystem VSAM, ESDS, KSDS, RRDS, LDS and Storage management Subsystems

Need a valid VSAM file sample

Postby ramikh86 » Tue Mar 12, 2013 7:55 pm

Hello everybody,
we are working on a sanitization solution, a customer asked if we can process VSAM files. we use .Net for our solution and is supports VSAM processing but we need a VSAM file. Please if you can give me a VSAM file to test on it would very much appreciated.

Thanks
ramikh86
 
Posts: 2
Joined: Tue Mar 12, 2013 7:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Need a valid VSAM file sample

Postby steve-myers » Tue Mar 12, 2013 8:03 pm

I'm kind of confused. As I understand it, .net applications run in Windoze. How is a Windoze application going to process a VSAM data set on a mainframe???
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times

Re: Need a valid VSAM file sample

Postby Robert Sample » Tue Mar 12, 2013 9:28 pm

You need to more clearly define what you want. If you need access just to VSAM data, you can get an unloaded (sequential) file of data. If you want access to an actual VSAM file, you need access to the particular mainframe where the VSAM file is located (and getting access to a mainframe can be a non-trivial process) before you can even talk about getting access to the VSAM file (which, again, may be a non-trivial process depending upon the security policies of the mainframe site).
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Need a valid VSAM file sample

Postby c62ap90 » Tue Mar 12, 2013 9:32 pm

I assume you need a keyed VSAM file? Here is an example Delete-Define-Load of a VSAM file with a key of 9-characters and record-length of 80-characters. I'm just guessing what you need.
//XXXXXXXX JOB ...                                                 
//*-- STEPS:   STEP010 - DELETE AND DEFINE KSDS VSAM FILE         
//*--          STEP020 - LOAD              KSDS VSAM FILE         
//*-- NOTES:   - RECSZ IS FILE SIZE; EXAMPLE IS 80-CHARACTER FIXED
//*--          - KEYS  IS SSN BEGINNING IN COLUMN 1 (OFFSET ZERO) 
//*--          - ".CL" IS VSAM CLUSTER DATASET NAME               
//*----------------------------------------------------------------
//*                                                               
//STEP010  EXEC PGM=IDCAMS                                         
//SYSPRINT DD SYSOUT=*                                             
//SYSOUD   DD SYSOUT=*                                             
//SYSOUT   DD SYSOUT=*                                             
//SYSIN    DD *                                                   
   DELETE XXXXXXXX.XXXXXXXX.CL              -                     
       CLUSTER             -                                       
       PURGE                                                       
   DEFINE CLUSTER          -                                       
      (INDEXED             -                                       
       NAME (XXXXXXXX.XXXXXXXX.CL)          -                     
       OWNER (USER001)     -             
       UNIQUE              -             
      )                    -             
      DATA                 -             
      (NAME (XXXXXXXX.XXXXXXXX.DATA)   - 
       OWNER(USER001)      -             
       TRK(030,015)        -             
       RECSZ (80,80)       -             
       CISZ (4096)         -             
       KEYS (9 0)          -             
       SHR (2 3)           -             
      )                    -             
      INDEX                -             
      (NAME (XXXXXXXX.XXXXXXXX.INDEX)   -
       OWNER (USER001)     -             
       TRK(5,3)            -             
       CISZ (1024)         -             
       SHR (2 3)           -             
      )                                   
/*                                     
//*-----------------------             
//STEP020  EXEC PGM=IDCAMS             
//SYSPRINT DD SYSOUT=*                 
//SYSUDUMP DD SYSOUT=*                 
//SYSOUD   DD SYSOUT=*                 
//SYSOUT   DD SYSOUT=*                 
//FILEA    DD DSN=YOUR.FILE.HERE,       
//            DISP=SHR                 
//FILEB    DD DSN=XXXXXXXX.XXXXXXXX.CL,
//            DISP=OLD                 
//SYSIN    DD *                         
   REPRO                         -     
      INFILE(FILEA)              -     
      OUTFILE(FILEB)                   
//                                     
c62ap90
 
Posts: 125
Joined: Thu Oct 11, 2012 10:24 pm
Has thanked: 1 time
Been thanked: 7 times

Re: Need a valid VSAM file sample

Postby BillyBoyo » Tue Mar 12, 2013 10:06 pm

If you have something which supports VSAM files, then you need to find out how to use define a file and put some data into it. No-one can "give" you a VSAM file which you'd expect to be able to just copy onto your non-mainframe system and it would work with what you have.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Need a valid VSAM file sample

Postby ramikh86 » Wed Mar 13, 2013 2:54 am

.Net in windows has an add-on to process VSAM files as they say in MSDN documentation.
as you say VSAVM files must be generated in an IBM enviroment, it cannot be transfered into windows platform as lets say oracle database files ?!
sorry for lake of experience in this topic.
ramikh86
 
Posts: 2
Joined: Tue Mar 12, 2013 7:33 pm
Has thanked: 0 time
Been thanked: 0 time


Return to VSAM/SMS

 


  • Related topics
    Replies
    Views
    Last post