Mainframer Talk





Conditional Continue-statement

Created on Nov. 29, 2023, 1:52 p.m. - by Hans, Van Battel

In batch-processing of big datasets every speed-up is important, so Is there any difference in the execution-speed between:

     IF a = b
          continue
     ELSE
          MOVE b to a
     END-IF

and:

     IF a <> b
Read more


i have excute a query in tsom1 uisng spufi and i got output..same query excute in Prod using spufi then i got output now my question how to compare those two spufi outputs

Created on Feb. 20, 2023, 1:19 p.m. - by Ravi, Pasupuleti

i have  excute  a query in tsom1  uisng  spufi  and i got output..same query excute in Prod using spufi  then i got output now my question how to compare those two spufi outputs

 

Note:Prod output  already transper to Mplex 

 

Read more

Breaking into a Mainframe/COBOL job

Created on July 28, 2022, 9:06 p.m. - by Nicholas,

Hello ladies and gents,

I cut my teeth in the indurstry on IBM Assembler, COBOL, ISAM, VSAM, DL1, CICS, and utilities [no IMS, worked in a VSE world].  At the time, we, out of necessity, did a lot of things with COBOL that wasn't available off the shelf, like bit …

Read more

what is Asra abend in Cics?how to reslove step by step?

Created on Sept. 27, 2021, 6:23 a.m. - by Ravi, Pasupuleti

 what is Asra abend in Cics?how to reslove step by step?

Read more

I try to insert duplicate values got -803 sql error.even i inserted duplicates values we dont get -803 How?i.e we need continue

Created on Sept. 3, 2021, 2:15 a.m. - by Ravi, Pasupuleti


 I try to insert duplicate values got -803 sql error.even i inserted duplicates values we dont get   -803 How?i.e we  need continue

Read more

what is temporary table in db2?what is usage of it?

Created on Aug. 30, 2021, 8:28 a.m. - by Ravi, Pasupuleti

what is temporary table in db2?what is usage of it?

Read more

if we added new column in a table how to do the impact analysis .i.e (what are all changes will do in copybook and that corresponding cobol modules)

Created on Aug. 24, 2021, 4:45 a.m. - by Ravi, Pasupuleti

if we added new column in a table how to do the impact analysis .i.e (what are all changes will do  in copybook and that corresponding cobol modules)
 

Read more

In Db2 i have field name 'xyz'.how to find what are all modules used that field and next time onwords dont want use.plz explain?

Created on Aug. 14, 2021, 6:15 a.m. - by Ravi, Pasupuleti


 In Db2  i have field  name 'xyz'.how to find what are all modules used that field  and next time onwords dont want  use.plz explain?

Read more

i have 5 steps in job.after second step got null .what will happen either execute next steps or not in

Created on Aug. 11, 2021, 6:33 a.m. - by Ravi, Pasupuleti

i have 5 steps in job.after second step got null .what will happen either execute next steps or not in 

Read more

i have file 100 records.first recod will go output1 and second record goes tp output2 and third records goes to output3 and agiain fouth record goes to output1 in files in cobol

Created on July 23, 2021, 8:11 a.m. - by Ravi, Pasupuleti

i have file 100 records.first recod will go output1 and second record goes tp output2 and third records goes to output3 and agiain fouth record goes to output1  in files in cobol

Read more

Delete an element adding it to Endevor Package

Created on June 11, 2021, 8:23 a.m. - by Divya, MK

How to Delete an element adding it to Endevor Package? Divya 

Read more

How to add header using JCL SORT utility

Created on May 15, 2021, 5:34 a.m. - by Jack, Peter

I want to add header detail in the output file using SORT utility

Read more

What is the difference between STOP RUN and GOBACK in COBOL

Created on May 12, 2021, 4:31 p.m. - by John, Prince

Please explain the difference between STOP RUN and GOBACK

Read more

how to suppress the zero in sort utility

Created on May 11, 2021, 1:05 p.m. - by Michael, Nicholas

I want to remove the leading zeroes in the number.

For example, I have an input file. 

00015
00220
07000

and the output file should be,
15
220
7000
 
Can anyone please suggest?

Read more

how to count the records in a file using sort jcl

Created on May 11, 2021, 12:34 p.m. - by Henry, Iris

I want to count the number of records in a file using the JCL sort utility and have to copy them to a specific position in an output file.

Please help me.

Read more

How to split single record line into two line?

Created on May 8, 2021, 7:34 p.m. - by Revathy, Sambathraj

I have a dataset with data till 80 length in it..
Due to some restriction.. I want the data (from 65 byte to 77 byte) to be copied to next line.. 
Is there any way we can achieve this ?

Read more

Support for API on Mainframes

Created on Jan. 28, 2021, 9:41 p.m. - by Kotesh, G

Hi Team,

Is there any support for API (Application Programming Interface) on IBM Mainframes.

Mainly for retrieving the VSAM Files/DB2 Tables from Mainframes (we are not considering option of Stored Procedures)

Thanks & Regards,

Kotesh.

 

Read more

Identifying a Character,Numeric & Special Character using Sort

Created on Dec. 23, 2020, 12:10 a.m. - by Kotesh, G

Hi Team,

Can I get a sort card for identifying the below

Alphabets (A to Z) there should not be any hard coding.

For eg if there is any alphabet between position 10 to 15,records should be included in the file.

Similar case with Numbers and Special characters.

Thanks & Regards,

Read more

What is Mainframe Modernization?

Created on Dec. 2, 2020, 4:54 a.m. - by Kalaiarasan, Panneer Selvam

So what Does ‘Mainframe Modernization’ Really Mean?

Read more

Cobol v6 Migration Challenges

Created on Sept. 15, 2020, 3:23 p.m. - by CobolJim, CobolJim

Who's migrating to Cobol v6 and what difficulties have you encountered?

Read more
Copyright 2020 by ibmmainframer. All Rights Reserved.