Search found 24 matches

by Ramesh_Mainframe
Thu Apr 25, 2024 11:04 am
Forum: Interview Questions.
Topic: Mainframe Interview Questions (3-5 Years Experience)
Replies: 3
Views: 133
India

Re: Mainframe Interview Questions (3-5 Years Experience)

DB2What happens when you encounter a SUM FIELDS = NONE condition in COBOL?
 
Is not this only applicable to SORT jobs, can this happen in a COBOL program too?
by Ramesh_Mainframe
Thu Apr 25, 2024 10:41 am
Forum: IBM DB2 and IMS DB/DC
Topic: -911(SQL dead lock) abend
Replies: 3
Views: 149
India

Re: -911(SQL dead lock) abend

Thanks zum13, this is really helpful. Is there a document which can help me to learn more about SQLCA?
by Ramesh_Mainframe
Mon Apr 22, 2024 11:26 pm
Forum: IBM DB2 and IMS DB/DC
Topic: -911(SQL dead lock) abend
Replies: 3
Views: 149
India

-911(SQL dead lock) abend

Hi,

Need a help here.

I have got -911(SQL dead lock) abend, how to get to know what are the resources were locked by this dead lock issue?
by Ramesh_Mainframe
Fri Mar 25, 2016 1:39 pm
Forum: Thought of the Day, General Talk & Jokes.
Topic: Where do you live?
Replies: 251
Views: 229187
India

Re: Where do you live?

India!
by Ramesh_Mainframe
Fri Mar 25, 2016 1:38 pm
Forum: Suggestions & Feedback : About the website.
Topic: How did you find us?
Replies: 294
Views: 500626
India

Re: How did you find us?

Hi,

A search on ISPF Tips in google suggested about this website to me.
by Ramesh_Mainframe
Fri Mar 25, 2016 1:36 pm
Forum: SMS & VSAM and BDAM, BSAM, QSAM, BPAM, ISAM, OAM.
Topic: Copy a VSAM to a PDS member?
Replies: 3
Views: 542
India

Re: Copy a VSAM to a PDS member?

Will take care about it in future.
by Ramesh_Mainframe
Fri Mar 25, 2016 1:33 pm
Forum: SMS & VSAM and BDAM, BSAM, QSAM, BPAM, ISAM, OAM.
Topic: How to handle VSAM status code in JCL itself?
Replies: 3
Views: 510
India

Re: How to handle VSAM status code in JCL itself?

That is a good idea. But apart from that can JCL never know about such a case?
by Ramesh_Mainframe
Wed Mar 23, 2016 7:51 am
Forum: SMS & VSAM and BDAM, BSAM, QSAM, BPAM, ISAM, OAM.
Topic: How to handle VSAM status code in JCL itself?
Replies: 3
Views: 510
India

How to handle VSAM status code in JCL itself?

Hi, In one of the COBOL programs, it reads a VSAM dataset. When the file is empty program ends with a VSAM status code. The file is opened in INPUT or I-O mode. I see STAYS code handling in COBOL program but I do not want to handle it in program rather in a JCL. Can I do that? Can you please suggest...
by Ramesh_Mainframe
Wed Mar 23, 2016 7:43 am
Forum: SMS & VSAM and BDAM, BSAM, QSAM, BPAM, ISAM, OAM.
Topic: Copy a VSAM to a PDS member?
Replies: 3
Views: 542
India

Re: Copy a VSAM to a PDS member?

Thanks. //* // EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=A //VSAM DD DSN=VSAM.DATASET,DISP=OLD //PDSB  DD DSN=PDS.SEQ.BACKUP(VSAMBKUP),UNIT=SYSDA, //     DISP=SHR //SYSIN DD * REPRO -  INFILE(VSAM) -  OUTFILE(PDSB) /* I have used the above JCL (edit: and control card s). Edit: coded - please do it yourse...
by Ramesh_Mainframe
Wed Mar 23, 2016 7:35 am
Forum: TSO, ISPF & REXX (Do you still do CLIST?!).
Topic: Stopping upper case in ISPF.
Replies: 10
Views: 4627
India

Re: Stopping upper case in ISPF.

nicc wrote:Why do you want an example of how to screw things up?
I did not understand that prino was saying that. I thought there is some proper way of executing some macro he is telling about. I did not know it's about screwing things.
by Ramesh_Mainframe
Wed Mar 16, 2016 1:51 pm
Forum: SMS & VSAM and BDAM, BSAM, QSAM, BPAM, ISAM, OAM.
Topic: Copy a VSAM to a PDS member?
Replies: 3
Views: 542
India

Copy a VSAM to a PDS member?

Hi,

Can we copy a VSAM file to a PDS member on mainframes?

I have a VSAM file, My.VSAM.file. And want to copy it to a PDS, named My.PDS in a new member. Can this be done, please guide.
Thanks in advance.
by Ramesh_Mainframe
Wed Mar 16, 2016 12:33 pm
Forum: TSO, ISPF & REXX (Do you still do CLIST?!).
Topic: Stopping upper case in ISPF.
Replies: 10
Views: 4627
India

Re: Stopping upper case in ISPF.

@prino,

Can you please share an example ?
by Ramesh_Mainframe
Fri May 02, 2014 8:37 pm
Forum: SMS & VSAM and BDAM, BSAM, QSAM, BPAM, ISAM, OAM.
Topic: Alternate index and Base Cluster - confusion.
Replies: 6
Views: 2155
India

Re: Alternate index and Base Cluster - confusion.

Thanks Enrico. Robert: Remember that an alternate index CANNOT be defined until there is at least one record in the base. If you set the high-used RBA to zero, you no longer have any records in the base -- so what happens to the alternate index records that were defined on that base? they are gone? :?
by Ramesh_Mainframe
Fri May 02, 2014 8:35 pm
Forum: TSO, ISPF & REXX (Do you still do CLIST?!).
Topic: Stopping upper case in ISPF.
Replies: 10
Views: 4627
India

Re: Stopping upper case in ISPF.

You need to find the ISPF bookshelf and read up on profiles. Also, if a data set has no lower-case characters when ISPF edit opens the data set, there is an implicit CAPS ON done if CAPS OFF is set; the opposite is also true (CAPS OFF will be done if there are lower case characters). So what should...
by Ramesh_Mainframe
Wed Apr 30, 2014 4:44 pm
Forum: Testing Tools, Mainframe Application Testing, Abends Solution & QA.
Topic: Xpeditor and Region allocation.
Replies: 4
Views: 2723
India

Re: Xpeditor and Region allocation.

Thanks Robert but I don't have an interface like you show at my shop. Is there any other way to pass the value of region parameter in this case?
by Ramesh_Mainframe
Wed Apr 30, 2014 4:43 pm
Forum: SMS & VSAM and BDAM, BSAM, QSAM, BPAM, ISAM, OAM.
Topic: Alternate index and Base Cluster - confusion.
Replies: 6
Views: 2155
India

Re: Alternate index and Base Cluster - confusion.

That make sense but I've to read it multiple time to understand...I still don't understand this:
if the cluster's high-used RBA is set to zero, how would all of the alternate index records be deleted?
by Ramesh_Mainframe
Wed Apr 30, 2014 4:41 pm
Forum: SMS & VSAM and BDAM, BSAM, QSAM, BPAM, ISAM, OAM.
Topic: What is CATALOG, MASTER CATALOG and USER CATALOG?
Replies: 5
Views: 4134
India

Re: What is CATALOG, MASTER CATALOG and USER CATALOG?

You said USER CATALOG points to a application, does that mean a USER CATALOGs ate not defined for individual users?
by Ramesh_Mainframe
Wed Apr 30, 2014 4:39 pm
Forum: TSO, ISPF & REXX (Do you still do CLIST?!).
Topic: Stopping upper case in ISPF.
Replies: 10
Views: 4627
India

Re: Stopping upper case in ISPF.

I'm sorry I meant alphabets only.

I've used CAPS OFF but whenever I open the member again after a fresh log-in to the system, it comes back to the CAPS ON?

Go to advanced search