Author |
Message |
Topic: COBOL and SQL IS BINARY DB2 column |
kolusu
Replies: 2
Views: 112
|
Forum: Application Programming Posted: Wed May 08, 2024 3:08 pm Subject: COBOL and SQL IS BINARY DB2 column |
misi01,
If the db2 column is defined as BInary, and if you are loading a packed decimal number, do you get right values if there is a comparison or arithmetic operation on column ?
You are bett ... |
Topic: Dataset name with a workday. |
kolusu
Replies: 6
Views: 516
|
Forum: Utilities Posted: Mon Apr 29, 2024 5:06 pm Subject: Dataset name with a workday. |
ramy2016"]
But something is off, let's say I ran it on Friday last time, so my PDS member = //WKLD SET WKDAY=FRI
and today is Monday. As I ran it on Monday, Step1 and Step2 ran, setting WDAY to MON, ... |
Topic: SFTP to list large number of files |
kolusu
Replies: 6
Views: 290
|
Forum: TSO and ISPF Posted: Sun Apr 28, 2024 8:34 am Subject: SFTP to list large number of files |
jathampy,
1. Yes. You can SFTP to your remote site and then issue the CD to the desired directory and then LS command to list the files.
2. check this link which explains all the options of LS ... |
Topic: SFTP to list large number of files |
kolusu
Replies: 6
Views: 290
|
Forum: TSO and ISPF Posted: Fri Apr 26, 2024 7:20 pm Subject: SFTP to list large number of files |
jathampy,
Here is an example of getting the directory listing and then you parse the output. I am just showing how the directory listing will be. You can add the parsing logic to generate the SF ... |
Topic: Dataset name with a workday. |
kolusu
Replies: 6
Views: 516
|
Forum: Utilities Posted: Fri Apr 26, 2024 7:09 pm Subject: Dataset name with a workday. |
Thank you kolusu for the link, I did searched but what I've found had limited options. For ex. I've already done dataset rename using internal reader, but this time it's a large number of files and if ... |
Topic: SFTP to list large number of files |
kolusu
Replies: 6
Views: 290
|
Forum: TSO and ISPF Posted: Fri Apr 26, 2024 12:38 am Subject: SFTP to list large number of files |
jathampy,
You can list the files in USS directory with BPXBATCH. You can also generate the SFTP commands from that list. Let me know if you are interested in that approach. |
Topic: Dataset name with a workday. |
kolusu
Replies: 6
Views: 516
|
Forum: Utilities Posted: Fri Apr 26, 2024 12:34 am Subject: Dataset name with a workday. |
ramy2016,
You have been member for a long time and yet you cannot follow simple rules of searching before posting.
Check this link which shows you how to created a dataset with current date.
... |
Topic: Incorrect day shown. |
kolusu
Replies: 2
Views: 485
|
Forum: Utilities Posted: Wed Apr 24, 2024 12:26 am Subject: Re: Incorrect day shown. |
CUR_DAY,S'&WDAY'
Ramy2016,
You used WDAY which gives you the day of the week, based on UTC. Shown in three characters: SUN, MON, TUE, WED, THU, FRI or SAT. Use &LWD ... |
Topic: Replace variable in File 2 using File 1 |
kolusu
Replies: 8
Views: 477
|
Forum: Utilities Posted: Wed Apr 03, 2024 12:01 pm Subject: Replace variable in File 2 using File 1 |
Hi Kolusu,
I made some changes in the positions that's why it wasn't working for me. This code is working.
Srishti Rawat,
You should have mentioned that, instead of implying that the propo ... |
Topic: Replace variable in File 2 using File 1 |
kolusu
Replies: 8
Views: 477
|
Forum: Utilities Posted: Thu Mar 28, 2024 9:46 am Subject: Replace variable in File 2 using File 1 |
Hi Kolusu,
Thank you for the solution.
Condition:
Replace the records starting from position 10 with first field of File1 and if records starting from position 40 is not spaces than replace wi ... |
Topic: Replace variable in File 2 using File 1 |
kolusu
Replies: 8
Views: 477
|
Forum: Utilities Posted: Fri Mar 22, 2024 6:54 pm Subject: Replace variable in File 2 using File 1 |
Srishti Rawat,
You need to pay attention to the questions asked and ensure you answered all of them
I asked you this
what are the DCB properties of file 1 and file 2?
You answered with jus ... |
Topic: Replace variable in File 2 using File 1 |
kolusu
Replies: 8
Views: 477
|
Forum: Utilities Posted: Fri Mar 22, 2024 1:18 pm Subject: Replace variable in File 2 using File 1 |
For all the records starting with '05' in File2, we want to replace the records starting from position 10 with first field of File1 and if records starting from position 40 is not spaces than replac ... |
Topic: SHIFT entire file contents |
kolusu
Replies: 2
Views: 259
|
Forum: TSO and ISPF Posted: Wed Mar 06, 2024 7:37 pm Subject: SHIFT entire file contents |
chuck,
You have to write your own DO WHILE logic to shift for each line and it is painstakingly slow. You are better running it in batch using a utility |
Topic: Compiling Rexx scripts |
kolusu
Replies: 10
Views: 984
|
Forum: TSO and ISPF Posted: Thu Feb 15, 2024 11:36 am Subject: Re: Keeping your Rexx source/CEXEC libraries in synch |
The idea (?) behind compiled Rexx is to be able to distribute your code as object code only while "protecting" your source code from prying eyes.
Misi01,
My sample JCL uses the option ... |
Topic: Compiling Rexx scripts |
kolusu
Replies: 10
Views: 984
|
Forum: TSO and ISPF Posted: Mon Feb 12, 2024 2:42 pm Subject: Compiling Rexx scripts |
misi01,
Here is the example that I use
//***************************************************************
//* COMPILE THE REXX EXEC *
//****************** ... |
|