Author |
Message |
Topic: DAYS vs YEAR return different date |
Nic Clouston
Replies: 5
Views: 5303
|
Forum: Database Posted: Mon Jan 04, 2021 4:40 pm Subject: DAYS vs YEAR return different date |
Chuck, that was the result Santosh got and was querying. My post was to point him in the right direction to get the explanation. |
Topic: DAYS vs YEAR return different date |
Nic Clouston
Replies: 5
Views: 5303
|
Forum: Database Posted: Mon Jan 04, 2021 7:10 am Subject: DAYS vs YEAR return different date |
If you had cared to look up how date arithmetic is performed in DB2 you would have found this:
If a duration of years is added or subtracted, only the year portion of the date is affected.
Now go ... |
Topic: REPLACE OFF |
Nic Clouston
Replies: 7
Views: 4929
|
Forum: Application Programming Posted: Fri Dec 11, 2020 5:58 am Subject: REPLACE OFF |
No access to a mainframe at the moment
COBOL compilers are available, for free, for Windows and Linux. |
Topic: QW for MVS/QuickRef is not working in my shop |
Nic Clouston
Replies: 2
Views: 4755
|
Forum: TSO and ISPF Posted: Thu Sep 10, 2020 5:26 am Subject: QW for MVS/QuickRef is not working in my shop |
I believe Quickref is a vendor prodct not IBM so your shop may not have purchased it. If they have, we do not work at your shop so we would not know what your internl problems are. Ask your colleagues ... |
Topic: Unstring using EasyTrieve - Variable data |
Nic Clouston
Replies: 10
Views: 8723
|
Forum: Job Control Language(JCL) Posted: Wed Sep 02, 2020 2:52 pm Subject: Unstring using EasyTrieve - Variable data |
It helps if you show the error messages. |
Topic: Unstring using EasyTrieve - Variable data |
Nic Clouston
Replies: 10
Views: 8723
|
Forum: Job Control Language(JCL) Posted: Mon Aug 31, 2020 4:13 pm Subject: Unstring using EasyTrieve - Variable data |
You have an Easytrieve problem not a JCL problem so why post in the JCL part of the forum instead of the Application Programming section the description of which specifically mentions Easytrieve? |
Topic: Sort file, keys in different position for different layouts |
Nic Clouston
Replies: 5
Views: 5912
|
Forum: Utilities Posted: Wed Jun 03, 2020 2:09 pm Subject: Sort file, keys in different position for different layouts |
Kolusu
I was suggesting adding it in the program that created the data in the first place so it would be one pas of both programs as is your solution. |
Topic: Sort file, keys in different position for different layouts |
Nic Clouston
Replies: 5
Views: 5912
|
Forum: Utilities Posted: Wed Jun 03, 2020 4:19 am Subject: Sort file, keys in different position for different layouts |
As it is an extract and not an unload why not have the extract add an extra field at the beginning of each record to hold the account number, sort on that and remove it in the output phase of sort? |
Topic: PL/I Help on PIC variable. |
Nic Clouston
Replies: 5
Views: 5068
|
Forum: Application Programming Posted: Tue Apr 14, 2020 8:23 am Subject: PL/I Help on PIC variable. |
You can clarify easily enough by yourself. Write a little program to declare a variable with a floating - and move a positive number into it and display it. Repeat with a negative number. |
Topic: EXEC DLI command - PSB |
Nic Clouston
Replies: 4
Views: 5045
|
Forum: IMS Posted: Mon Mar 16, 2020 6:32 am Subject: EXEC DLI command - PSB |
Which language are you using as that does not look like COBOL, PL/1 or assembler? |
Topic: ftp file rename dynamically |
Nic Clouston
Replies: 2
Views: 5698
|
Forum: Job Control Language(JCL) Posted: Wed Feb 26, 2020 8:37 am Subject: ftp file rename dynamically |
Are your FTP control statements in-line in your FTP job or a PDS member? If in-line then you should be able to simply use system symbols in your JCL otherwise you cannot do it with JCL but will have t ... |
Topic: How to get Line of code for each application |
Nic Clouston
Replies: 10
Views: 5832
|
Forum: Utilities Posted: Mon Feb 24, 2020 4:51 pm Subject: How to get Line of code for each application |
And how about blank lines or lines with multiple statements or statements crossing multiple lines? |
Topic: SORT to identify last business day of the month |
Nic Clouston
Replies: 27
Views: 11508
|
Forum: Utilities Posted: Wed Feb 19, 2020 10:13 am Subject: SORT to identify last business day of the month |
I do see it but didn't look to see if I could - I thought I was only allowed to edit within 10 minutes of posting. Now tht it is mentioned I seem to vaguely remember that this was granted some eons ag ... |
Topic: SORT to identify last business day of the month |
Nic Clouston
Replies: 27
Views: 11508
|
Forum: Utilities Posted: Wed Feb 19, 2020 5:30 am Subject: SORT to identify last business day of the month |
Ah.
Point 1 - this is rexx on a windows OS hence "CLS". I cut out a load of code that was related as I only use Windows. It is still in the original post.
2 - that would be the NOT symbo ... |
Topic: SORT to identify last business day of the month |
Nic Clouston
Replies: 27
Views: 11508
|
Forum: Utilities Posted: Tue Feb 18, 2020 10:39 am Subject: SORT to identify last business day of the month |
And here is the updated Rexx version:
/*- Rexx ------------------------------------------------------------*/
/* */
/* Name ... |
|