1,397 questions
0
votes
0
answers
27
views
Mainframe DFSORT - Load Balancing in N Files Clean Split
I have a file sorted on Student nbr (2 Digit Char + 6 Digit Number)..
My requirement is to split this data into N (5 in below example) files to divide the load "nearly equally".. But during ...
0
votes
1
answer
66
views
Mainframe DFSORT - Get top N of each group by count
I have an input File with records as below :
FILE_NAME1 DATA_REC_1
FILE_NAME1 DATA_REC_2
FILE_NAME1 DATA_REC_2
FILE_NAME1 DATA_REC_2
FILE_NAME1 DATA_REC_3
FILE_NAME1 DATA_REC_3
FILE_NAME1 ...
1
vote
1
answer
59
views
replace the substring in 1st file by anther string from 2nd file
I have 2 input files as below
File1:
AST
BDT
CFT
EDT
FRT
File2:
T.ABC.TXT.***.EF.TAXSE.IWS.WISHS ...
0
votes
1
answer
114
views
Calling REST APIs from Mainframe Batch
One mainframe system (A) has a batch that expects millions of records from another system (B) which is hosted on AWS with a relational database. Until now both the systems were on mainframe and data ...
1
vote
1
answer
88
views
SAS Mainframe ASA Carriage Control Behaviour
I am currently working on SAS conversion to python. I noticed that there are ASA Carriage Control Character at the first column in the output file in mainframe. After some research, I noticed that 1 ...
4
votes
3
answers
137
views
Nested tables using depending
I am facing problem with nested DEPENDING ON Clause. I need to generate the table with below requirement.
For example.
....
....
20 Person occurs 1 to 20
depending on cnt-...
0
votes
0
answers
73
views
Trouble while launching Mainframe Terminal TN3270.ws via Python
I am currently working on a Python-based automation task that involves interacting with a mainframe terminal. As part of the requirement, I need to:
Launch the mainframe terminal.
Enter the username ...
-1
votes
1
answer
214
views
Mainframe Sort JCL - transpose the rows to column
I have the following input:
.TY records can vary from 1 to 30 times
I tried with build & PUSH in sort but i couldn't get the expected below output
I need to get it using SORT not COBOL.
The BEGIN ...
0
votes
1
answer
108
views
Handling PCOMM events in Windows Forms application
Is there a way to register/trap the PCOMM events in a Windows Forms application?
I invoke the PCOMM Application using the Interop.AutConnMgrTypeLibrary, on a button click on the form. This all works ...
0
votes
3
answers
250
views
"The import com.ibm.jzos cannot be resolved" when exporting CICS bundle to z/OS UNIX File System
I'm trying to export a CICS bundle to a z/OS Unix file system using IBM Developer for z/OS.
One of the projects in my bundle has a library I'm importing (ibmjzos-2.4.11.3.jar). I added the library to ...
0
votes
0
answers
72
views
zOS/Mainframe Java Shell Script for TrustStore and Certs
I a executing a Mainframe Java program using a shell script and JCL. I have been using the "export" command along with IBM_JAVA_OPTIONS and the JAVA_TOOL_OPTIONS parameters to integrate an ...
0
votes
2
answers
702
views
Bit size of PIC S9(13)v99 in COBOL [closed]
I read somewhere that PIC s9(13)v99 takes 54 bits of storage such that 1 full word(36 bits) and 1 half word(18 bits). Could someone please explain? TIA
0
votes
1
answer
309
views
How to see constraints of table db2
I have a DB2 table and i want to see which columns are declared NOT NULL.
What are the other constraints of all columns of the table (Primary Key) ?
0
votes
1
answer
114
views
IBM HPU 5.2 - Converting EBCDIC Characters to Blanks
We are using the latest available HPU in our shop, version 5.2.
We need to unload some tables that are quite large (hundreds of millions of records) and transfer those files to an IBM Datastage system ...
0
votes
1
answer
150
views
what is the impact of the point at the end of instruction COBOL
what is the impact of the point at the end of instruction COBOL when i use SECTION. It seem that the end point is very important.
What is the difference between:
SELECT SECTION.
MOVE xxx TO Bbb
...