VSAM Interview Questions and Answers For Experienced | Mostly Asked in An Interview | Mainframe Guru

Поделиться
HTML-код
  • Опубликовано: 8 янв 2025

Комментарии • 10

  • @AbhiChopade
    @AbhiChopade 3 года назад +1

    its helpful

  • @muthulakshmi2217
    @muthulakshmi2217 3 года назад +1

    Why we can use only vsam files in CICS

    • @MainframeGuru
      @MainframeGuru  3 года назад +1

      Thanks @Muthu Lakshmi for watching the video. I think that we use the VSAM files in CICS because it makes easier for application program to execute an input-output operation. VSAM is a high performance access method used to organize data in form of files in Mainframes. VSAM is used by COBOL and CICS in Mainframes to store and retrieve data. All the files used in CICS application, should be registered in FCT with the complete attributes. CICS commands use the FCT entries to get the file DSN and for performing the operations on the file.
      All the best for your future. 🙏

  • @udayakiranupanayan
    @udayakiranupanayan 4 года назад +1

    Pls upload more interview real time scenario imsdb,cics brother

    • @MainframeGuru
      @MainframeGuru  4 года назад

      Yes Udaykiran, we will upload the video regarding IMS DB & CICS soon. Thank You.

  • @sanjyottambekar7895
    @sanjyottambekar7895 2 года назад

    In a Vsam file how to change the single record without copying the file into another file?

    • @MainframeGuru
      @MainframeGuru  2 года назад +1

      Thanks Sanjyot for watching the video. You can use the fileaid tool to edit/change the record.🙏

    • @MainframeGuru
      @MainframeGuru  2 года назад +1

      You can also change like below.
      //STEP02 EXEC PGM=FILEAID
      //SYSPRINT DD SYSOUT=*
      //SYSUDUMP DD SYSOUT=*
      //SYSLIST DD SYSOUT=*
      //SYSABEND DD SYSOUT=*
      //SYSOUT DD SYSOUT=*
      //DD01 DD DSN=INPUT.FILE,DISP=OLD
      //SYSIN DD *
      $$DD01 UPDATE KEY=C'IND #########KB',IN=1,REPL=(121,C'Y')
      //*

  • @adeshtiwari5152
    @adeshtiwari5152 Год назад

    how to insert a record in between KSDS file?

    • @MainframeGuru
      @MainframeGuru  Год назад

      You can insert the records manually through FileAid based on the primary key sort data. KSDS VSAM key contains the data in the sorted order. So If you will try to insert record manually, then it would check the key sequence (i.e. whether data is in sorted order based on key).
      Next way is to use the repro replace command through IDCAMS utility. All the best for your future. 🙏