Search found 55 matches

by alpna
Tue Apr 10, 2018 12:15 pm
Forum: SMS & VSAM and BDAM, BSAM, QSAM, BPAM, ISAM, OAM.
Topic: How to randomly access the vsam file using partial key?
Replies: 2
Views: 2747

How to randomly access the vsam file using partial key?

Hello All,

How to randomly access the vsam file using partial key? I don't have much hands on with VSAM, can someone please help?
by alpna
Wed Feb 07, 2018 5:36 pm
Forum: JCL - Job Control Language.
Topic: Job is taking too long to run.
Replies: 3
Views: 1400

Re: Job is taking too long to run.

I have also noticed that the Job card of the Job is:

Code: Select all

//xxxx1234 JOB SYSTEMS,
without an accounting information. I would like to experiment with this but can this really be a problem as this is production job and updates a lot of databases.
by alpna
Wed Feb 07, 2018 5:29 pm
Forum: JCL - Job Control Language.
Topic: Job is taking too long to run.
Replies: 3
Views: 1400

Job is taking too long to run.

Hi, One of our Job is taking too long to execute, upon investigation there is no error found in the JCL and later the Job completed successfully too but it took too long to execute. There was one message which was populated in JESMSGLG: JOB12345 INGUJI3E xxxx1234 BAD ACCOUNT CODE JOB TYPE (1ST FIELD...
by alpna
Sat Oct 14, 2017 8:32 pm
Forum: IBM COBOL, GnuCOBOL (OpenCOBOL), OOCobol.
Topic: Reading the records from a KSDS in reverse order in COBOL.
Replies: 1
Views: 545

Reading the records from a KSDS in reverse order in COBOL.

Hi,

How Can we read the records in a KSDS in reverse order in COBOL? Could you please advise.
by alpna
Tue Oct 10, 2017 8:51 pm
Forum: Interview Questions.
Topic: Why to give the program name in SYSTSIN.
Replies: 5
Views: 1014

Re: Why to give the program name in SYSTSIN.

Note there is no connection between program and plan; specifying a plan name does not indicate what program should use it. Yes, there is no connection. I also said to the interviewer that they need to be given there as it's a rule but he kept on insisting on it. And I felt my answer was not correct.
by alpna
Mon Oct 09, 2017 3:39 pm
Forum: Interview Questions.
Topic: Why to give the program name in SYSTSIN.
Replies: 5
Views: 1014

Why to give the program name in SYSTSIN.

Hi,

In an interview I got a question that when there is a plan is given why there is need of the program name in the SYSTSIN, when we run the COBOl DB2 program?
by alpna
Mon Oct 09, 2017 3:01 pm
Forum: Site Announcements and Rules.
Topic: Switch the width of the Forum.
Replies: 6
Views: 3274

Re: Switch the width of the Forum.

This feature is great. The forums looks new now.
by alpna
Wed Mar 22, 2017 4:49 pm
Forum: IBM DB2 and IMS DB/DC
Topic: Host varaiables in DB2.
Replies: 1
Views: 525

Host varaiables in DB2.

Hi,

In DB2 can we fetch the data without the host variables?
by alpna
Mon Feb 06, 2017 11:07 am
Forum: Interview Questions.
Topic: Intrinsic function of COBOL to identify a specific day of the month?
Replies: 3
Views: 1170

Re: Intrinsic function of COBOL to identify a specific day of the month?

Thanks Robert.

Could you please help me to layout a logic for it in COBOL?
by alpna
Wed Jan 25, 2017 5:14 pm
Forum: Interview Questions.
Topic: Intrinsic function of COBOL to identify a specific day of the month?
Replies: 3
Views: 1170

Intrinsic function of COBOL to identify a specific day of the month?

Hi,

Do we have some intrinsic function of COBOL to identify a specific day of the month? For example to check if the given date is second Monday of the month?

I did not answer this question. I thought there was a function but I cold not find one later online.
by alpna
Sat Jan 02, 2016 8:21 am
Forum: Site Announcements and Rules.
Topic: Happy New Year 2016.
Replies: 18
Views: 2515

Re: Happy New Year 2016.

Image

Happy new year all.
by alpna
Sat Jan 02, 2016 8:16 am
Forum: IBM COBOL, GnuCOBOL (OpenCOBOL), OOCobol.
Topic: Significance of the sequence number in COBOL.
Replies: 9
Views: 1919

Re: Significance of the sequence number in COBOL.

I actually wrote a source code processing program to do exactly that. Can you please share the code, if it can be shared here? Here's the essential code (for fixed-length COBOL source files), based on the recently posted GET/PUT Assembler shell format (posted under the Convert "VB to FB file b...
by alpna
Mon Nov 30, 2015 2:22 pm
Forum: IBM COBOL, GnuCOBOL (OpenCOBOL), OOCobol.
Topic: Significance of the sequence number in COBOL.
Replies: 9
Views: 1919

Re: Significance of the sequence number in COBOL.

ApexNC wrote:I actually wrote a source code processing program to do exactly that.
Can you please share the code, if it can be shared here?
by alpna
Mon Nov 30, 2015 2:21 pm
Forum: IBM COBOL, GnuCOBOL (OpenCOBOL), OOCobol.
Topic: Significance of the sequence number in COBOL.
Replies: 9
Views: 1919

Re: Significance of the sequence number in COBOL.

So basically they are of no use now a days?
by alpna
Mon Nov 30, 2015 2:20 pm
Forum: Mainframe Performance, Capacity Planning and Software Cost.
Topic: 4-hour MSU rolling average.
Replies: 3
Views: 2295

Re: 4-hour MSU rolling average.

Thanks. So is there something more like 1 hour-, 2 hour-rolling average too? Are there some specific set of rules which IBM publish for this?

If I need to a assessment exercise for a client who is using 4-hour MSU rolling average what are the thing I should consider? Please hep with your guidance.
by alpna
Mon Nov 30, 2015 2:18 pm
Forum: IBM DB2 and IMS DB/DC
Topic: Help in solving SQLCODE -144.
Replies: 4
Views: 821

Re: Help in solving SQLCODE -144.

Recompiling and rebind has helped in solving the problem. Thanks everyone who has helped.
by alpna
Mon Nov 30, 2015 2:17 pm
Forum: IBM COBOL, GnuCOBOL (OpenCOBOL), OOCobol.
Topic: Reverse string in COBOL without using REVERSE function?
Replies: 4
Views: 1988

Re: Reverse string in COBOL without using REVERSE function?

For a continuous string of length 50, I have used the following logic, this seem to work:

Code: Select all

ws-counter=1 
Perform reverse-string-para 
varying ws-counter=1 from 50 by -1 
until ws-counter=0 

Reversa-para 
Move name(ws-counter:1) to namer(ws-counter2:1) 
ws-counter2=ws-counter2+1
by alpna
Sat Nov 28, 2015 12:03 pm
Forum: IBM COBOL, GnuCOBOL (OpenCOBOL), OOCobol.
Topic: Significance of the sequence number in COBOL.
Replies: 9
Views: 1919

Significance of the sequence number in COBOL.

I read that Cobol kept the first 6 positions for a line sequence number. Column 7 was a continuation / comment / debug / form-feed. Area "A", or Columns 8-11, indicated certain special language artifacts like 01 levels, section or paragraph names. Columns 73 - 80 were for OS sequence numbe...
by alpna
Mon Nov 23, 2015 4:44 pm
Forum: Mainframe Performance, Capacity Planning and Software Cost.
Topic: 4-hour MSU rolling average.
Replies: 3
Views: 2295

4-hour MSU rolling average.

Hi,

What is the meaning of "4-hour MSU rolling average"? How and where we use it? How it relates to mainframes?
by alpna
Tue Nov 17, 2015 10:52 pm
Forum: IBM DB2 and IMS DB/DC
Topic: Help in solving SQLCODE -144.
Replies: 4
Views: 821

Help in solving SQLCODE -144.

Hi,

For a SELECT statement I am getting SQLCODE -144. The explanation about it says 'INVALID SECTION NUMBER number '. What does that mean? How do I solve it? Please help.

Thanks.

Go to advanced search