Author |
Message |
Topic: Variables in fileaid batch JCL |
kolusu
Replies: 6
Views: 525
|
Forum: Utilities Posted: Sun Mar 09, 2025 8:38 am Subject: Variables in fileaid batch JCL |
For example, in the below statement
$$DD01 COPY MOVE=(1,20,1),MOVE=(76,10C? ?)
in place of 20, I want to use some variable STP which has value 20.
something like this
STP=2 ... |
Topic: Mixed dups. |
kolusu
Replies: 1
Views: 987
|
Forum: Utilities Posted: Fri Dec 20, 2024 5:29 pm Subject: Mixed dups. |
ramy2016,
You need to use the trick of joinkeys matching the file to it self. The second file will count the number of duplicates and upon matching every record has the counter. Now we can just el ... |
Topic: DFSort/ICETOOL PARSE on optional fields in variable position |
kolusu
Replies: 4
Views: 1033
|
Forum: Utilities Posted: Mon Nov 04, 2024 1:21 pm Subject: DFSort/ICETOOL PARSE on optional fields in variable position |
peterwarren,
Try these untested control cards
//SYSIN DD *
OPTION COPY,VLSCMP
INCLUDE COND=((2363,1,CH,NE,C'Y ... |
Topic: DFSort/ICETOOL PARSE on optional fields in variable position |
kolusu
Replies: 4
Views: 1033
|
Forum: Utilities Posted: Sat Nov 02, 2024 2:24 am Subject: DFSort/ICETOOL PARSE on optional fields in variable position |
peterwarren,
It is not clear as to what the real requirement is. Please answer the following questions
1. What is the LRECL and RECFM of the input file?
2. Can the records contain ALL 3 se ... |
Topic: Replace variable digits with zero |
kolusu
Replies: 3
Views: 767
|
Forum: Utilities Posted: Mon Oct 21, 2024 11:30 pm Subject: Replace variable digits with zero |
jathampy,
It is quite simple to replace the variable contents. Here is an untested DFSORT JCL that will give you the desired results.
//SYSIN DD * ... |
Topic: EBCDIC to UTF-8 |
kolusu
Replies: 3
Views: 985
|
Forum: Utilities Posted: Sun Sep 29, 2024 9:10 pm Subject: EBCDIC to UTF-8 |
psivamadhusudhan,
You need to talk to your system programmer if the conversion service is installed. If you are authorized to issue system commands then you can issue the command D UNI,CONV OR
... |
Topic: EBCDIC to UTF-8 |
kolusu
Replies: 3
Views: 985
|
Forum: Utilities Posted: Sun Sep 29, 2024 9:15 am Subject: EBCDIC to UTF-8 |
psivamadhusudhan,
Sort products do not have the ability to perform character set conversions. However you can use iconv utility to do the conversion. Check this link
https://www.ibm.com/docs/ ... |
Topic: Calling a UDF with multiple parameters in |
kolusu
Replies: 2
Views: 1815
|
Forum: Database Posted: Fri Sep 27, 2024 3:03 am Subject: Calling a UDF with multiple parameters in |
misi01,
A bunch of problems.
RETURNS DECIMAL(18)
This will return ONLY 1 item
EXTERNAL NAME 'MSUDF1'
You need to invoke the function as MSUDF1 instead of bi ... |
Topic: Converting hex values to decimal |
kolusu
Replies: 3
Views: 1793
|
Forum: Database Posted: Thu Jul 11, 2024 11:30 am Subject: Converting hex values to decimal |
I didn't forget, but maybe you misunderstood my question?
Misi01,
I did not misunderstand your question. First off you did not mention about replicating the REXX functions as you merely asked ... |
Topic: Converting hex values to decimal |
kolusu
Replies: 3
Views: 1793
|
Forum: Database Posted: Mon Jul 08, 2024 3:21 pm Subject: Converting hex values to decimal |
misi01,
You seem to forget the solutions you got recently. In the previous thread titled "Displaying binary data as "readable" such" I pointed a link. here is that post
... |
Topic: English expression |
kolusu
Replies: 2
Views: 2383
|
Forum: Related Non-Technical Topics Posted: Wed Jul 03, 2024 12:50 pm Subject: English expression |
misi01,
Sensitive Data masking or Data privacy masking is what you are looking for. |
Topic: Period missing after END-EXEC in WS |
kolusu
Replies: 2
Views: 1606
|
Forum: Application Programming Posted: Fri Jun 28, 2024 4:52 pm Subject: Period missing after END-EXEC in WS |
chuck,
Is it the Precompiler that issued the error message when the period is missing or is it the COBOL compiler that issued the message?
According Db2 12 , Period is OPTIONAL if it is in betw ... |
Topic: Need help in formatting output |
kolusu
Replies: 4
Views: 2358
|
Forum: Utilities Posted: Mon May 27, 2024 6:45 pm Subject: Need help in formatting output |
I lost DFSORT usage to some extent.
shekar123,
Any programming language/utility is like riding a bike. You learn once and never forget. I haven't coded COBOL programs since 2006 as I prima ... |
Topic: Need help in formatting output |
kolusu
Replies: 4
Views: 2358
|
Forum: Utilities Posted: Mon May 27, 2024 9:46 am Subject: Need help in formatting output |
shekar123,
What a waste of time and resources. A simple 10 line report can be generated much faster by hand rather than running 6 passes of data for getting only partial data ... |
Topic: Displaying binary data as "readable" such |
kolusu
Replies: 3
Views: 1995
|
Forum: Database Posted: Thu May 16, 2024 2:52 pm Subject: Displaying binary data as "readable" such |
misi01,
What I would like to do would be to show the EBCDIC characters as ASCII (?), ie, show a 40 as a "space" and the D6 results as the letter O (as in Oscar).
It is not ASCII. X' ... |
|