Re: Mainframe FTP status

2024-09-25 Thread Don Johnson
Thanks, Charles, that does make a lot of sense. I have tried to search for AT-TLS, and find a lot of details, but I am not quite ready for that yet. Do you know of a primer that starts at 20,000 feet and brings me into the process easily? Don ---

Mainframe FTP status

2024-09-25 Thread Don Johnson
lease? Thanks for putting my mind at ease! Don Johnson -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Reading VSAM LDS data records

2024-07-24 Thread Don Johnson
hat I need with it. If you have a program that will help me read these LDS files, I would be so grateful! Thanks! Don Johnson -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.u

IGGCSI00 Catalog Search interface

2024-03-14 Thread Don Johnson
Good morning! I am working with the IGGCSI00 module, and have looked at the field descriptions and think I am missing something. Does anyone know the CSI field name and format where I can discover if a file is a BASIC or LARGE DSNtype? Thanks! Don

Re: SORT Help with JFY and SQZ

2023-11-09 Thread Don Johnson
Kolusu, thanks once again! This is now complete and working as I had hoped! Have a good evening! Don -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO

Re: SORT Help with JFY and SQZ

2023-11-09 Thread Don Johnson
Hi Kolusu, I have one question about a situation that just came up. If the input file has no records to process, I would like to set a return code so I can bypass further processing. Is there a way that I can tweak this SORT input that you gave me to know if the SORTCMD1 file is empty, and set a

Re: SORT Help with JFY and SQZ

2023-11-08 Thread Don Johnson
Kolusu, thanks...this gave me just what I needed in those files! Have a wonder-filled day! Don -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-M

Re: SORT Help with JFY and SQZ

2023-11-08 Thread Don Johnson
Well, I found that I could not release 2 records into the Copy from INREC. So here is what I did to produce all the output. Kolusu, if you have an easier way, I would be happy to learn and adapt! This is what I did to get what I needed: //SYSINDD * OPTION COPY

Re: SORT Help with JFY and SQZ

2023-11-08 Thread Don Johnson
Thanks for the tip, Kolusu; it worked great! Now, I was trying to create a second command file, without that last comma and field. For example, the statements you gave me created -UTL COPY,TABLE,B400-TRANHIST(0003),HST0400A and for the second file, I need -RPT FIELD,TABLE,B400-TRANHIST(0003) Ho

SORT Help with JFY and SQZ

2023-11-08 Thread Don Johnson
#x27;,C'H', C'09',C'I',C'10',C'J'),NOMATCH=(C'$'),80:X) I tried to use 05,32,SQZ=(SHIFT=LEFT), and that may have worked, but then it just padded the rest of the 32 bytes with spaces, so it did nothing. Thanks in advance! Don Johnson -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

How to list ciphers used in FTP

2023-08-02 Thread Don Johnson
from the SSH EXEC PGM=BPXBATCH environment? Since I need to test both FTP and SFTP access to the servers, I welcome any guidance for these that you can give me. The end goal is to produce a before/after list showing the differences. Thanks! Don Johnson

Re: SORTWK space usage

2023-07-05 Thread Don Johnson
Ok, thanks, Kolusu. Unless there would be a compelling reason to redirect the SORT a different way, I will let the program determine the best way to go. So far, it sounds like each of these memory paths will produce somewhat similar stats to other paths, and I would not want to ask my client try

Re: SORTWK space usage

2023-07-05 Thread Don Johnson
Yes, the records are FB, and I have run several tests today, so I could get a "close but not exact" count here to see those results. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listse

Re: SORTWK space usage

2023-07-05 Thread Don Johnson
This has been a good thread, even if it is a bit long, and it was quite expedient for me, as I had a client just ask me about how to determine sortwork sizes needed for a large database file they are processing. The records are coming from inside a program via E15/35, so I can't use the standard

Re: Can I use JOINKEYS?

2023-05-04 Thread Don Johnson
Kolusu, this is great - I did not think this could be done, and it works so well. The changed format is fine, as that is easy to understand. Thanks so much for teaching me along the way! Now let me ask, is there a way to incorporate the Sort extract that creates either or both of the files into

Can I use JOINKEYS?

2023-05-03 Thread Don Johnson
things. Let me know what you think. Thanks for your guidance and assistance! Don Johnson -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Trying to Parse a LISTCAT with SORT

2022-10-21 Thread Don Johnson
Hello! I just tried to post a question with embedded code and fixed formatting, but it was rejected because HTML is not supported. So I will post it in plain text, and you can cut/paste into notepad or 3270 to see how it lines up. If there is a way to use code blocks here, please let me know an

Re: How to update ZSTART variable in ISP Profile

2022-04-26 Thread Don Johnson
Lionel, thank you for this tool. It works perfectly, and saved me a lot of time and effort! Have a great day! Don -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the

How to update ZSTART variable in ISP Profile

2022-04-26 Thread Don Johnson
Hi all, I have a teammate who wants to change his ISPF ZSTART profile variable in the ISP profile, and I wanted to see if there is an easy way to do this. ISPF 7.3 won't work, as that is only showing ISR profile variables. I can write a quick little utility that will (1) copy ISPPROF to some oth

Re: Using SORT to add quotes around CHAR fields? (Listserv)

2022-03-29 Thread Don Johnson
Kolusu, thank you for putting this together. I am hopeful to be able to try it out today, but then will be away through next week. Let me ask one question here. Would it be easier if I changed the separator from a comma to a tilde? If so, then the output looks like this ITM_ID~DESC~SHORT_DESC~U_

Re: Using SORT to add quotes around CHAR fields? (Listserv)

2022-03-24 Thread Don Johnson
Wayne, thanks for these great solution ideas - they give me other ideas, too. I might try the Datasource for Excel option for another need I have. The IBM DB2 Rexx is interesting, and I will have to see if I could adapt it to my Datacom table (at first blush, it seems too DB2-centric). Thanks a

Re: Using SORT to add quotes around CHAR fields? (Listserv)

2022-03-24 Thread Don Johnson
Kolusu, here are the first 3 column definitions: CHAR(10) N.N., CHAR(30) NOT NULL, CHAR(8) N.N., As you can see, each of the columns is separated by a comma, which is outside of the parens. The N.N. is an abbreviation for Not Null, and the abbreviation is used when the column width is less than

Using SORT to add quotes around CHAR fields? (Listserv)

2022-03-23 Thread Don Johnson
,8.99,550,25,"N",500,1.5,0,0,87,02,03 "A10006","MONOGRAMMED SPLASH GUARDS","SPLSHGRD","PAIR",11.99,300,0,"N",250,1.5,0,0,86,02,20 Is there a way to see which column type contains CHAR( -- each of the types is c