Author |
Message |
Topic: Replace variable digits with zero |
jathampy
Replies: 3
Views: 1161
|
Forum: Utilities Posted: Wed Oct 23, 2024 1:40 pm Subject: Replace variable digits with zero |
I tested the SORT JCL and its working fine as expected. Many Thanks Kolusu for providing the solution |
Topic: Replace variable digits with zero |
jathampy
Replies: 3
Views: 1161
|
Forum: Utilities Posted: Tue Oct 22, 2024 4:03 am Subject: Replace variable digits with zero |
Many Thanks Kolusu. I really appreciate your timely help. I admire your mainframe technical skills.
I am on leave Today and will try the SORT JCL Tomorrow. |
Topic: Replace variable digits with zero |
jathampy
Replies: 3
Views: 1161
|
Forum: Utilities Posted: Mon Oct 21, 2024 1:42 pm Subject: Replace variable digits with zero |
I am looking for a SORT to replace a numeric field that can vary between 1 and 11 digits with zero at same position
The first 4 character indicate record type. There are 5 other record types simila ... |
Topic: SFTP to list large number of files |
jathampy
Replies: 6
Views: 4023
|
Forum: TSO and ISPF Posted: Sun Apr 28, 2024 1:24 pm Subject: SFTP to list large number of files |
Many Thanks kolusu. It's a Single directory where all files are placed. |
Topic: SFTP to list large number of files |
jathampy
Replies: 6
Views: 4023
|
Forum: TSO and ISPF Posted: Sat Apr 27, 2024 1:54 pm Subject: SFTP to list large number of files |
Thanks Kolusu. Just couple of questions
1. The "sh ls " command you mentioned seems listing directory of mainframe unix directory. The issue I am facing is getting the directory listing ... |
Topic: SFTP to list large number of files |
jathampy
Replies: 6
Views: 4023
|
Forum: TSO and ISPF Posted: Fri Apr 26, 2024 11:24 am Subject: SFTP to list large number of files |
Thanks Kolusu for the reply
Currently I am using EXEC PGM=BPXBATCH,PARM='sh sftp -vvv -b <unix file> <User@IPaddress>' to list the files
The sftp commands like CD and DIR * are store ... |
Topic: SFTP to list large number of files |
jathampy
Replies: 6
Views: 4023
|
Forum: TSO and ISPF Posted: Wed Apr 24, 2024 1:46 pm Subject: SFTP to list large number of files |
Due to large number of files (150000+ files) in sftp location, my SFTP job failed failed with return code 255 while executing DIR * command. I can see "xreallocarray: out of memory" messag ... |
Topic: Convert file fields into Varchar format |
jathampy
Replies: 2
Views: 2667
|
Forum: Utilities Posted: Fri Aug 25, 2023 4:35 am Subject: Convert file fields into Varchar format |
Many thanks Kolusu for providing the solution. It worked. |
Topic: Convert file fields into Varchar format |
jathampy
Replies: 2
Views: 2667
|
Forum: Utilities Posted: Thu Aug 24, 2023 1:43 pm Subject: Convert file fields into Varchar format |
I am having a CSV file as shown below.
0001,xyz,pedfgh,zehhhee,yutte8901
0002,ABCDEE,UFGGGGGGGH,ytettetteee,9
0003,pqrst,asd,mnopql,fdghsjjss
Want to convert this file into varchar format. ... |
Topic: Convert external floating point number to COMP-2 |
jathampy
Replies: 4
Views: 3686
|
Forum: Application Programming Posted: Mon Aug 14, 2023 9:29 am Subject: Convert external floating point number to COMP-2 |
I tried NUMVAL-F before also and it's not working. The Other intrinsic functions NUMVAL and NUMVAL-C are working fine with the compiler version 4.2.0 V4R2 . When I use NUMVAL-F,it's giving compilation ... |
Topic: Convert external floating point number to COMP-2 |
jathampy
Replies: 4
Views: 3686
|
Forum: Application Programming Posted: Sat Aug 05, 2023 3:47 am Subject: Convert external floating point number to COMP-2 |
Thanks Kolusu for providing the solution. I tried the solution but job failed with
"IGZ0040S An invalid separate sign was detected in program" while executing the move statement " M ... |
Topic: Convert external floating point number to COMP-2 |
jathampy
Replies: 4
Views: 3686
|
Forum: Application Programming Posted: Wed Aug 02, 2023 11:13 am Subject: Convert external floating point number to COMP-2 |
I have an input file that contain amount fields in exponential form like "-2.2204462782314e-16". I want to convert this into COMP-2 format.
Tried NUMVAL-F intrinsic function and the co ... |
Topic: Convert decimal number into Comp-3 |
jathampy
Replies: 3
Views: 4206
|
Forum: Utilities Posted: Thu Jul 28, 2022 7:21 am Subject: Convert decimal number into Comp-3 |
Thanks Kolusu. The one mentioned in the link previously work only for two fixed decimal digits.As per the new requirement the number of digits after decimal places can vary between 0 and 4. It worked ... |
Topic: Convert decimal number into Comp-3 |
jathampy
Replies: 3
Views: 4206
|
Forum: Utilities Posted: Wed Jul 27, 2022 12:16 pm Subject: Convert decimal number into Comp-3 |
I am having an input file with 10 amount fields that contain decimal numbers but decimal point is not always guaranteed. I need to convert each of these amount fields into COMP-3 of length 5. The maxi ... |
Topic: floating point to decimal |
jathampy
Replies: 2
Views: 2801
|
Forum: Utilities Posted: Sat Jul 09, 2022 2:26 am Subject: floating point to decimal |
Many thanks kolusu. I will use COBOL program to do the same |
|