Comparing two PS - Source codes
Hello I have two PS datasets having some programming codes , Is it possible to compare these two PS and produce a third PS datasets by removing duplicate entries ? Jake -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Using SORT to add quotes around CHAR fields? (Listserv)
Don, Microsoft Powershell will add quotes around a comma delimited field. However, it does it for all fields, not just Alphanumeric. It's a free download. This example command does the quote addition: import-csv C:\Users\wayne\Documents\book2.csv | export-csv C:\Users\wayne\Documents\book3.csv -NoTypeInformation -Encoding UTF8 In REXX, you can parse out each field from your CSV and use the STRIP function to take out the words that are numeric. This file: a, 1, 2, three abc, 5, 3, def hgi, 4, 6, ttt Becomes: "a","1","2","three" "abc","5","3","def" "hgi","4","6","ttt" PARSE VALUE mystring with F1 ',' F2',' F3 ',' F4 F2 = STRIP(F2,,'"') F4 = STRIP(F4,,'"') OUTSTR = F1 F2 F3 F4 Having said all this, I'd just PARSE your original records and add the quotes word by word where needed. They are in known positions, so you know which ones to STRIP and rebuild. On Thu, Mar 24, 2022 at 7:47 AM Don Johnson < 02ee771a0785-dmarc-requ...@listserv.ua.edu> wrote: > This is a post now to the listserv, instead of the Google group. Sorry for > the duplication! > > Hi, I have a comma-delimited extract from a file that has numeric and > character fields, and I would like to turn it into a true CSV file by > making the character fields quoted. > > I have a 2-line header (column names, and column types) which indicates > which are CHAR fields, but cannot figure out how to capture the information > from the header to apply to the actual data lines. > > For example, I have this in my file: > ITM_ID,DESC,SHORT_DESC,U_M,UNIT_PRICE,ON_HAND,COMMIT,INV_HOLD,DISC_QTY,DISC_PCT,B_O_QTY,ON_ORD,ACT_YR,ACT_MO,ACT_DAY > > CHAR(10) N.N.,CHAR(30) NOT NULL,CHAR(8) N.N.,CHAR(4) N.N.,DEC(7,2) > N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(1) N.N.,DEC(7,0) N.N.,DEC(3,1) > N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(2) N.N.,CHAR(2) N.N.,CHAR(2) N.N. > A1,CARPETED RUBBER > MATS-FRONT-RED,FLOORMAT,PAIR,22.99,135,205,Y,5000,1.5,0,0,87,02,02 > A10001,CARPETED RUBBER > MATS-REAR(RED),FLOORMAT,PAIR,12.99,277,14,N,250,1.5,0,0,86,02,20 > A10002,PERSONALIZED VINYL > MATS(BEIGE),FLOORMAT,PAIR,19.99,296,7,N,250,1.5,0,0,87,02,03 > A10003,4-PIECE CARPET MAT SET (BLUE),MAT > SET,SET,19.99,275,2,N,250,1.5,0,0,87,02,03 > A10004,SPLASH > GUARDS-ALUMINUM,SPLSHGRD,PAIR,8.99,523,55,N,500,1.5,0,0,87,02,03 > A10005,SPLASH > GUARDS-VINYL,SPLSHGRD,PAIR,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 > > and want the output to look like this: > "A1","CARPETED RUBBER > MATS-FRONT-RED","FLOORMAT","PAIR",22.99,135,205,"Y",5000,1.5,0,0,87,02,02 > "A10001","CARPETED RUBBER > MATS-REAR(RED)","FLOORMAT","PAIR",12.99,277,14,"N",250,1.5,0,0,86,02,20 > "A10002","PERSONALIZED VINYL > MATS(BEIGE)","FLOORMAT","PAIR",19.99,296,7,"N",250,1.5,0,0,87,02,03 > "A10003","4-PIECE CARPET MAT SET (BLUE)","MAT > SET","SET",19.99,275,2,"N",250,1.5,0,0,87,02,03 > "A10004","SPLASH > GUARDS-ALUMINUM","SPLSHGRD","PAIR",8.99,523,55,"N",500,1.5,0,0,87,02,03 > > "A10005","SPLASH > GUARDS-VINYL","SPLSHGRD","PAIR",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 column separated -- and then be able to apply quotes to that > particular output field? I am not sure about this, but hope there is an > answer here. > > Thank you for your help! > Don Johnson > Sr. Principal Support Engineer | MSD - Datacom product family > Broadcom Software > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Wayne V. Bickerdike -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Using SORT to add quotes around CHAR fields? (Listserv)
Ack, Export to CSV for MS-DOS only appears to work on Mac, not IBM PC. On Thu, Mar 24, 2022 at 7:47 AM Don Johnson < 02ee771a0785-dmarc-requ...@listserv.ua.edu> wrote: > This is a post now to the listserv, instead of the Google group. Sorry for > the duplication! > > Hi, I have a comma-delimited extract from a file that has numeric and > character fields, and I would like to turn it into a true CSV file by > making the character fields quoted. > > I have a 2-line header (column names, and column types) which indicates > which are CHAR fields, but cannot figure out how to capture the information > from the header to apply to the actual data lines. > > For example, I have this in my file: > ITM_ID,DESC,SHORT_DESC,U_M,UNIT_PRICE,ON_HAND,COMMIT,INV_HOLD,DISC_QTY,DISC_PCT,B_O_QTY,ON_ORD,ACT_YR,ACT_MO,ACT_DAY > > CHAR(10) N.N.,CHAR(30) NOT NULL,CHAR(8) N.N.,CHAR(4) N.N.,DEC(7,2) > N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(1) N.N.,DEC(7,0) N.N.,DEC(3,1) > N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(2) N.N.,CHAR(2) N.N.,CHAR(2) N.N. > A1,CARPETED RUBBER > MATS-FRONT-RED,FLOORMAT,PAIR,22.99,135,205,Y,5000,1.5,0,0,87,02,02 > A10001,CARPETED RUBBER > MATS-REAR(RED),FLOORMAT,PAIR,12.99,277,14,N,250,1.5,0,0,86,02,20 > A10002,PERSONALIZED VINYL > MATS(BEIGE),FLOORMAT,PAIR,19.99,296,7,N,250,1.5,0,0,87,02,03 > A10003,4-PIECE CARPET MAT SET (BLUE),MAT > SET,SET,19.99,275,2,N,250,1.5,0,0,87,02,03 > A10004,SPLASH > GUARDS-ALUMINUM,SPLSHGRD,PAIR,8.99,523,55,N,500,1.5,0,0,87,02,03 > A10005,SPLASH > GUARDS-VINYL,SPLSHGRD,PAIR,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 > > and want the output to look like this: > "A1","CARPETED RUBBER > MATS-FRONT-RED","FLOORMAT","PAIR",22.99,135,205,"Y",5000,1.5,0,0,87,02,02 > "A10001","CARPETED RUBBER > MATS-REAR(RED)","FLOORMAT","PAIR",12.99,277,14,"N",250,1.5,0,0,86,02,20 > "A10002","PERSONALIZED VINYL > MATS(BEIGE)","FLOORMAT","PAIR",19.99,296,7,"N",250,1.5,0,0,87,02,03 > "A10003","4-PIECE CARPET MAT SET (BLUE)","MAT > SET","SET",19.99,275,2,"N",250,1.5,0,0,87,02,03 > "A10004","SPLASH > GUARDS-ALUMINUM","SPLSHGRD","PAIR",8.99,523,55,"N",500,1.5,0,0,87,02,03 > > "A10005","SPLASH > GUARDS-VINYL","SPLSHGRD","PAIR",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 column separated -- and then be able to apply quotes to that > particular output field? I am not sure about this, but hope there is an > answer here. > > Thank you for your help! > Don Johnson > Sr. Principal Support Engineer | MSD - Datacom product family > Broadcom Software > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Wayne V. Bickerdike -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Using SORT to add quotes around CHAR fields? (Listserv)
Hi Don, Since you have access to Broadcom software. Why don't you use your table as a Datasource utilizing Datacom Server and export to CSV from spreadsheet? On Thu, Mar 24, 2022 at 7:47 AM Don Johnson < 02ee771a0785-dmarc-requ...@listserv.ua.edu> wrote: > This is a post now to the listserv, instead of the Google group. Sorry for > the duplication! > > Hi, I have a comma-delimited extract from a file that has numeric and > character fields, and I would like to turn it into a true CSV file by > making the character fields quoted. > > I have a 2-line header (column names, and column types) which indicates > which are CHAR fields, but cannot figure out how to capture the information > from the header to apply to the actual data lines. > > For example, I have this in my file: > ITM_ID,DESC,SHORT_DESC,U_M,UNIT_PRICE,ON_HAND,COMMIT,INV_HOLD,DISC_QTY,DISC_PCT,B_O_QTY,ON_ORD,ACT_YR,ACT_MO,ACT_DAY > > CHAR(10) N.N.,CHAR(30) NOT NULL,CHAR(8) N.N.,CHAR(4) N.N.,DEC(7,2) > N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(1) N.N.,DEC(7,0) N.N.,DEC(3,1) > N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(2) N.N.,CHAR(2) N.N.,CHAR(2) N.N. > A1,CARPETED RUBBER > MATS-FRONT-RED,FLOORMAT,PAIR,22.99,135,205,Y,5000,1.5,0,0,87,02,02 > A10001,CARPETED RUBBER > MATS-REAR(RED),FLOORMAT,PAIR,12.99,277,14,N,250,1.5,0,0,86,02,20 > A10002,PERSONALIZED VINYL > MATS(BEIGE),FLOORMAT,PAIR,19.99,296,7,N,250,1.5,0,0,87,02,03 > A10003,4-PIECE CARPET MAT SET (BLUE),MAT > SET,SET,19.99,275,2,N,250,1.5,0,0,87,02,03 > A10004,SPLASH > GUARDS-ALUMINUM,SPLSHGRD,PAIR,8.99,523,55,N,500,1.5,0,0,87,02,03 > A10005,SPLASH > GUARDS-VINYL,SPLSHGRD,PAIR,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 > > and want the output to look like this: > "A1","CARPETED RUBBER > MATS-FRONT-RED","FLOORMAT","PAIR",22.99,135,205,"Y",5000,1.5,0,0,87,02,02 > "A10001","CARPETED RUBBER > MATS-REAR(RED)","FLOORMAT","PAIR",12.99,277,14,"N",250,1.5,0,0,86,02,20 > "A10002","PERSONALIZED VINYL > MATS(BEIGE)","FLOORMAT","PAIR",19.99,296,7,"N",250,1.5,0,0,87,02,03 > "A10003","4-PIECE CARPET MAT SET (BLUE)","MAT > SET","SET",19.99,275,2,"N",250,1.5,0,0,87,02,03 > "A10004","SPLASH > GUARDS-ALUMINUM","SPLSHGRD","PAIR",8.99,523,55,"N",500,1.5,0,0,87,02,03 > > "A10005","SPLASH > GUARDS-VINYL","SPLSHGRD","PAIR",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 column separated -- and then be able to apply quotes to that > particular output field? I am not sure about this, but hope there is an > answer here. > > Thank you for your help! > Don Johnson > Sr. Principal Support Engineer | MSD - Datacom product family > Broadcom Software > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Wayne V. Bickerdike -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Using SORT to add quotes around CHAR fields? (Listserv)
The IBM sample REXX is here: https://www.ibm.com/docs/en/db2-for-zos/11?topic=examples-sample-db2-rexx-application The DRAW function builds this: INSERT INTO SAN_JOSE.DSN8B10.EMP ( "EMPNO" , "FIRSTNME" , "MIDINIT" , "LASTNAME" , "WORKDEPT" , "PHONENO" , "HIREDATE" , "JOB" , "EDLEVEL" , "SEX" , "BIRTHDATE" , "SALARY" , "BONUS" , "COMM" ) VALUES ( -- ENTER VALUES BELOW COLUMN NAME DATA TYPE , -- EMPNO CHAR(6) NOT NULL , -- FIRSTNME VARCHAR(12) NOT NULL , -- MIDINIT CHAR(1) NOT NULL , -- LASTNAME VARCHAR(15) NOT NULL , -- WORKDEPT CHAR(3) , -- PHONENO CHAR(4) , -- HIREDATE DATE , -- JOB CHAR(8) , -- EDLEVEL SMALLINT , -- SEX CHAR(1) , -- BIRTHDATE DATE , -- SALARY DECIMAL(9,2) , -- BONUS DECIMAL(9,2) ) -- COMM DECIMAL(9,2) On Thu, Mar 24, 2022 at 7:47 AM Don Johnson < 02ee771a0785-dmarc-requ...@listserv.ua.edu> wrote: > This is a post now to the listserv, instead of the Google group. Sorry for > the duplication! > > Hi, I have a comma-delimited extract from a file that has numeric and > character fields, and I would like to turn it into a true CSV file by > making the character fields quoted. > > I have a 2-line header (column names, and column types) which indicates > which are CHAR fields, but cannot figure out how to capture the information > from the header to apply to the actual data lines. > > For example, I have this in my file: > ITM_ID,DESC,SHORT_DESC,U_M,UNIT_PRICE,ON_HAND,COMMIT,INV_HOLD,DISC_QTY,DISC_PCT,B_O_QTY,ON_ORD,ACT_YR,ACT_MO,ACT_DAY > > CHAR(10) N.N.,CHAR(30) NOT NULL,CHAR(8) N.N.,CHAR(4) N.N.,DEC(7,2) > N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(1) N.N.,DEC(7,0) N.N.,DEC(3,1) > N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(2) N.N.,CHAR(2) N.N.,CHAR(2) N.N. > A1,CARPETED RUBBER > MATS-FRONT-RED,FLOORMAT,PAIR,22.99,135,205,Y,5000,1.5,0,0,87,02,02 > A10001,CARPETED RUBBER > MATS-REAR(RED),FLOORMAT,PAIR,12.99,277,14,N,250,1.5,0,0,86,02,20 > A10002,PERSONALIZED VINYL > MATS(BEIGE),FLOORMAT,PAIR,19.99,296,7,N,250,1.5,0,0,87,02,03 > A10003,4-PIECE CARPET MAT SET (BLUE),MAT > SET,SET,19.99,275,2,N,250,1.5,0,0,87,02,03 > A10004,SPLASH > GUARDS-ALUMINUM,SPLSHGRD,PAIR,8.99,523,55,N,500,1.5,0,0,87,02,03 > A10005,SPLASH > GUARDS-VINYL,SPLSHGRD,PAIR,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 > > and want the output to look like this: > "A1","CARPETED RUBBER > MATS-FRONT-RED","FLOORMAT","PAIR",22.99,135,205,"Y",5000,1.5,0,0,87,02,02 > "A10001","CARPETED RUBBER > MATS-REAR(RED)","FLOORMAT","PAIR",12.99,277,14,"N",250,1.5,0,0,86,02,20 > "A10002","PERSONALIZED VINYL > MATS(BEIGE)","FLOORMAT","PAIR",19.99,296,7,"N",250,1.5,0,0,87,02,03 > "A10003","4-PIECE CARPET MAT SET (BLUE)","MAT > SET","SET",19.99,275,2,"N",250,1.5,0,0,87,02,03 > "A10004","SPLASH > GUARDS-ALUMINUM","SPLSHGRD","PAIR",8.99,523,55,"N",500,1.5,0,0,87,02,03 > > "A10005","SPLASH > GUARDS-VINYL","SPLSHGRD","PAIR",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 column separated -- and then be able to apply quotes to that > particular output field? I am not sure about this, but hope there is an > answer here. > > Thank you for your help! > Don Johnson > Sr. Principal Support Engineer | MSD - Datacom product family > Broadcom Software > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Wayne V. Bickerdike -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Using SORT to add quotes around CHAR fields? (Listserv)
I see this is perhaps from the Datacom ITM table, supplied in the sample database? There is an IBM sample REXX program which reads the attributes of a SQL table and will build a template INSERT statement. If you could use this utility, it will give you the syntax that you need. I have a copy of this, I'll add some context later when I log on. On Thu, Mar 24, 2022 at 1:23 PM Robin Vowels wrote: > The list of attributes are obviously PL/I, and that suggests that > PL/I could be the means of solving the problem. > > On 2022-03-24 08:20, Horacio Luis Villa wrote: > > Hi, > > > > the last 3 columns are CHAR but you don't want them quoted? > > Don't know how to do it using SORT. I'd do it with Rexx. > > > > De: IBM Mainframe Discussion List en nombre > > de Don Johnson <02ee771a0785-dmarc-requ...@listserv.ua.edu> > > Enviado: miércoles, 23 de marzo de 2022 17:46 > > Para: IBM-MAIN@LISTSERV.UA.EDU > > Asunto: [EXTERNAL] Using SORT to add quotes around CHAR fields? > > (Listserv) > > > > This is a post now to the listserv, instead of the Google group. Sorry > > for the duplication! > > > > Hi, I have a comma-delimited extract from a file that has numeric and > > character fields, and I would like to turn it into a true CSV file by > > making the character fields quoted. > > > > I have a 2-line header (column names, and column types) which > > indicates which are CHAR fields, but cannot figure out how to capture > > the information from the header to apply to the actual data lines. > > > > For example, I have this in my file: > > > ITM_ID,DESC,SHORT_DESC,U_M,UNIT_PRICE,ON_HAND,COMMIT,INV_HOLD,DISC_QTY,DISC_PCT,B_O_QTY,ON_ORD,ACT_YR,ACT_MO,ACT_DAY > > CHAR(10) N.N.,CHAR(30) NOT NULL,CHAR(8) N.N.,CHAR(4) N.N.,DEC(7,2) > > N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(1) N.N.,DEC(7,0) N.N.,DEC(3,1) > > N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(2) N.N.,CHAR(2) N.N.,CHAR(2) > > N.N. > > A1,CARPETED RUBBER > > MATS-FRONT-RED,FLOORMAT,PAIR,22.99,135,205,Y,5000,1.5,0,0,87,02,02 > > A10001,CARPETED RUBBER > > MATS-REAR(RED),FLOORMAT,PAIR,12.99,277,14,N,250,1.5,0,0,86,02,20 > > A10002,PERSONALIZED VINYL > > MATS(BEIGE),FLOORMAT,PAIR,19.99,296,7,N,250,1.5,0,0,87,02,03 > > A10003,4-PIECE CARPET MAT SET (BLUE),MAT > > SET,SET,19.99,275,2,N,250,1.5,0,0,87,02,03 > > A10004,SPLASH > > GUARDS-ALUMINUM,SPLSHGRD,PAIR,8.99,523,55,N,500,1.5,0,0,87,02,03 > > A10005,SPLASH > > GUARDS-VINYL,SPLSHGRD,PAIR,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 > > > > and want the output to look like this: > > "A1","CARPETED RUBBER > > MATS-FRONT-RED","FLOORMAT","PAIR",22.99,135,205,"Y",5000,1.5,0,0,87,02,02 > > "A10001","CARPETED RUBBER > > MATS-REAR(RED)","FLOORMAT","PAIR",12.99,277,14,"N",250,1.5,0,0,86,02,20 > > "A10002","PERSONALIZED VINYL > > MATS(BEIGE)","FLOORMAT","PAIR",19.99,296,7,"N",250,1.5,0,0,87,02,03 > > "A10003","4-PIECE CARPET MAT SET (BLUE)","MAT > > SET","SET",19.99,275,2,"N",250,1.5,0,0,87,02,03 > > "A10004","SPLASH > > GUARDS-ALUMINUM","SPLSHGRD","PAIR",8.99,523,55,"N",500,1.5,0,0,87,02,03 > > "A10005","SPLASH > > GUARDS-VINYL","SPLSHGRD","PAIR",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 column separated -- and then be able to apply quotes to that > > particular output field? I am not sure about this, but hope there is > > an answer here. > > > > Thank you for your help! > > Don Johnson > > Sr. Principal Support Engineer | MSD - Datacom product family > > Broadcom Software > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Wayne V. Bickerdike -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Using SORT to add quotes around CHAR fields? (Listserv)
The list of attributes are obviously PL/I, and that suggests that PL/I could be the means of solving the problem. On 2022-03-24 08:20, Horacio Luis Villa wrote: Hi, the last 3 columns are CHAR but you don't want them quoted? Don't know how to do it using SORT. I'd do it with Rexx. De: IBM Mainframe Discussion List en nombre de Don Johnson <02ee771a0785-dmarc-requ...@listserv.ua.edu> Enviado: miércoles, 23 de marzo de 2022 17:46 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: [EXTERNAL] Using SORT to add quotes around CHAR fields? (Listserv) This is a post now to the listserv, instead of the Google group. Sorry for the duplication! Hi, I have a comma-delimited extract from a file that has numeric and character fields, and I would like to turn it into a true CSV file by making the character fields quoted. I have a 2-line header (column names, and column types) which indicates which are CHAR fields, but cannot figure out how to capture the information from the header to apply to the actual data lines. For example, I have this in my file: ITM_ID,DESC,SHORT_DESC,U_M,UNIT_PRICE,ON_HAND,COMMIT,INV_HOLD,DISC_QTY,DISC_PCT,B_O_QTY,ON_ORD,ACT_YR,ACT_MO,ACT_DAY CHAR(10) N.N.,CHAR(30) NOT NULL,CHAR(8) N.N.,CHAR(4) N.N.,DEC(7,2) N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(1) N.N.,DEC(7,0) N.N.,DEC(3,1) N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(2) N.N.,CHAR(2) N.N.,CHAR(2) N.N. A1,CARPETED RUBBER MATS-FRONT-RED,FLOORMAT,PAIR,22.99,135,205,Y,5000,1.5,0,0,87,02,02 A10001,CARPETED RUBBER MATS-REAR(RED),FLOORMAT,PAIR,12.99,277,14,N,250,1.5,0,0,86,02,20 A10002,PERSONALIZED VINYL MATS(BEIGE),FLOORMAT,PAIR,19.99,296,7,N,250,1.5,0,0,87,02,03 A10003,4-PIECE CARPET MAT SET (BLUE),MAT SET,SET,19.99,275,2,N,250,1.5,0,0,87,02,03 A10004,SPLASH GUARDS-ALUMINUM,SPLSHGRD,PAIR,8.99,523,55,N,500,1.5,0,0,87,02,03 A10005,SPLASH GUARDS-VINYL,SPLSHGRD,PAIR,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 and want the output to look like this: "A1","CARPETED RUBBER MATS-FRONT-RED","FLOORMAT","PAIR",22.99,135,205,"Y",5000,1.5,0,0,87,02,02 "A10001","CARPETED RUBBER MATS-REAR(RED)","FLOORMAT","PAIR",12.99,277,14,"N",250,1.5,0,0,86,02,20 "A10002","PERSONALIZED VINYL MATS(BEIGE)","FLOORMAT","PAIR",19.99,296,7,"N",250,1.5,0,0,87,02,03 "A10003","4-PIECE CARPET MAT SET (BLUE)","MAT SET","SET",19.99,275,2,"N",250,1.5,0,0,87,02,03 "A10004","SPLASH GUARDS-ALUMINUM","SPLSHGRD","PAIR",8.99,523,55,"N",500,1.5,0,0,87,02,03 "A10005","SPLASH GUARDS-VINYL","SPLSHGRD","PAIR",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 column separated -- and then be able to apply quotes to that particular output field? I am not sure about this, but hope there is an answer here. Thank you for your help! Don Johnson Sr. Principal Support Engineer | MSD - Datacom product family Broadcom Software -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: zEDC compression on z14 and z15 by using ADRDSSU
Hi Renato, Did you notice this statement at the beginning of the IQPPRM* chapter in the init and tuning reference for z/OS 2.5... Note: The IQPPRMxx will still be valid on IBM zEnterprise z15 and above processors, but the tunable options will no longer be available. Therefore, a message IQP062I REQUEST REJECTED - OPTIONS IGNORED will be displayed. I am not sure what it means exactly, however I'd be inclined to check the log for IQP062I messages. It sounds as though the IQP parms may not even be honored. I have little experience with on-chip zEDC, but did some benchmarking with the first round of PCIe zEDC adapters. For that world the DEFMINREQSIZE and INFMINREQSIZE values you're using seem exceedingly small, and allow for inefficient zEDC processing of smaller data quantities. Of course, on-chip zEDC will be faster than PCIe zEDC, but it is not clear/documented how this would impact settings of the minimums, especially on a z15 which may just give you some sort of parameter toleration mode. If the tiny default inflate and deflate minimums are being used, the overhead associated with Huffman compression/decompression will drive up CPU and provide reduced compaction, assuming the actual amount of in buffer data is also quite small. While not sure if on-chip zEDC versus PCIe zEDC is apples to apples, our limited benchmarks about 5 years ago compared CPU consumption for hardware assisted (CMPSC) compression against zEDC and against no compression. We found that for record sizes of... 512 bytes, zEDC used appx 250% more CPU than CMPSC, and appx 450% more CPU than no compression 1024 bytes, zEDC used appx 20% more CPU than CMPSC, and appx 225% more CPU than no compression 2048 bytes, zEDC used appx 30% less CPU than CMPSC, and appx 60% more CPU than no compression 4096 bytes, zEDC used appx 130% less CPU than CMPSC, and appx same CPU as no compression 8192 bytes, zEDC used appx 300% less CPU than CMPSC, and appx20% less CPU than no compression 16K bytes, same as above Unfortunately I do not know what the IQP minimum values were set at for the above test at this point in time, but guessing in the neighborhood of 4-8K. So at some point, probably below the 4-8K range, the relative inefficiency of software level compression is reflected. Okay, just checked the z/OS 2.5 MVS callable services doc for high level languages, chapter 14, pg 195 and it documents things more clearly... 4. Ensure that adequately sized input buffers are available. If the input buffer size falls below the minimum threshold, data compression occurs using zlib software compression and not zEDC. Note: IBM zEnterprise z15 and above processor thresholds will no longer be tunable through parmlib. The IQPPRMxx will still be allowed in the configuration, but the values will no longer be accepted. The environment variables _HZC_DEFLATE_THRESHOLD and _HZC_INFLATE_THRESHOLD can also be used to control the threshold for going to zEDC. The valid values are in the range 1-999. According to the above, you're IQP parms are being ignored and you will need to use the environment variables they mention. No mention of an equivalent for the MAXSEGMENTS parm. If you end up trying out the above env vars, I'd definitely appreciate an email with your results as this is something I've wondered about. HTH, Mike -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Compagno Renato (Consulente per BCC Sistemi Informatici) Sent: Tuesday, March 22, 2022 11:41 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: R: zEDC compression on z14 and z15 by using ADRDSSU Caution! This message was sent from outside your organization. Hi Chuck, PRDB 2022081 16:09:11.83-D IQP PRDB 2022081 16:09:11.83 IQP066I 16.09.11 DISPLAY IQP 681 zEDC Information DEFMINREQSIZE: 1K (STATIC) INFMINREQSIZE: 1K (STATIC) Feature Enablement:Enabled PRDB 2022081 16:31:19.36-D PROD,STATE,FEATURENAME(ZEDC) PRDB 2022081 16:31:19.37 IFA111I 16.31.19 PROD DISPLAY 195 S OWNERNAME FEATURE VERSION ID E IBM CORP z/OS ZEDC * .* .* 5650-ZOS On joblog we can see: 01.52.58 INTERNAL VAMMSG DATASET DR.DUMP.D220208.T160612.JF2068 ALLOCATE ON VAM STORAGE GROUP 01.52.58 JOB01194 IEF233A M F8A7,PRIVAT,SL,PSDRB112,DUMP021, 269 269 DR.DUMP.D220208.T160612.JF2068 01.52.58 JOB01194 ADR111I-SET PATCH 0D=FF 278 01.52.58 JOB01194 ADR111I-SET PATCH 0E=3C 279 01.52.58 JOB01194 ADR111I-SET PATCH
Re: PL/I question
+1 It was initially called Fortran VI, because it was considered too advanced to be called Fortran V (1962), then NPL (1964, but could not because it was the acronym of the National Physical Laboratory [or similar] in the UK,) and then PL/I - with the '/' from OS/360 and the Roman 'I' to preserve its originally having been called Fortran VI. On 23/03/2022 00:52, Phil Smith III wrote: > Bob Bridges wrote: > >> PL/1 was my first language. > > > Only it's "PL/I". "Programming Language/One", but "PL/I". Just sayin'. > > > > It actually might have been PL/C on that Xerox 530. S long ago. > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > . > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: PL/I question
That's what I thought too... LOL On 3/23/2022 3:28 PM, zMan wrote: Are you asking what PL/I's pronouns are? On Wed, Mar 23, 2022 at 4:15 PM Charles Mills wrote: How does PL/I self-identify? Charles -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: z/PDT
Jay, You have gotten a long way further along the LE process than I have. I have been trying to find out my status in the LE approval process for the last 6 weeks, and my original application submission was in December last year. I would very sincerely hope that they would extend your license since mid-January is 1/6 of a year ago, but once you have everything in your hands I would absolutely make an official request to the LE product manager. Peter -Original Message- From: IBM Mainframe Discussion List On Behalf Of Jay Maynard Sent: Wednesday, March 23, 2022 1:33 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: z/PDT I have completed all of the paperwork and paid my money. The last I heard, the log4j business was indeed soaking up all of the bandwidth they had to devote to such things, but they expected to have something to send out by mid-February, and everything taken care of and ready to go by mid-March. Obviously, they haven't made either date. I haven't gotten my USB dongle, either. The date on my license is mid-January. I'm hoping they extend it. On Tue, Mar 22, 2022 at 11:41 PM Grant Taylor < 023065957af1-dmarc-requ...@listserv.ua.edu> wrote: > On 3/22/22 10:37 PM, Brian Westerman wrote: > > Has anyone heard any news about the lower cost z/PDT lately? I was > > on the list, but everything seems to have been dropped. > > I heard from someone that they had completed the paperwork and were > waiting on the approval as of early this year. From what they were > saying, they were expecting to be in possession of a license by now. > > Sorry, I don't remember who and even if I did, I wouldn't share > without their permission. ;-) > > I also heard through the grape vine that IBM had just about all hands > on deck for the Log4J fiasco, all platforms. As such, people that > were working on the hobbyist / student licensing were re-assigned for > a while. I'm speculating that they are now back on task. -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: PL/I question
Exactly Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of zMan Sent: Wednesday, March 23, 2022 3:28 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: PL/I question Are you asking what PL/I's pronouns are? On Wed, Mar 23, 2022 at 4:15 PM Charles Mills wrote: > How does PL/I self-identify? > > Charles > > > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Steve Smith > Sent: Wednesday, March 23, 2022 12:52 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: PL/I question > > Obviously they are not. As a matter of fact, there *is* one correct way > (and the trademark owner would be happy to say so), and no number of errors > or passage of time changes that. So it will be occasionally mentioned. > > One might complain about IBM's history of lousy names for its products. > The standard for a long time was obviously to form an initialism from a > string of 2-4 vague words. Old story is that if IBM had invented sushi, it > would be called "CDF" (cold dead fish). The fact that not all sushi has > fish of any temperature or vitality can be considered part of the joke. > > sas > > > On Wed, Mar 23, 2022 at 10:00 AM Rupert Reynolds > wrote: > > > I think the days of trying to say there is only one correct way to write > > its name are long gone! > > > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- zMan -- "I've got a mainframe and I'm not afraid to use it" -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: PL/I question
Are you asking what PL/I's pronouns are? On Wed, Mar 23, 2022 at 4:15 PM Charles Mills wrote: > How does PL/I self-identify? > > Charles > > > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Steve Smith > Sent: Wednesday, March 23, 2022 12:52 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: PL/I question > > Obviously they are not. As a matter of fact, there *is* one correct way > (and the trademark owner would be happy to say so), and no number of errors > or passage of time changes that. So it will be occasionally mentioned. > > One might complain about IBM's history of lousy names for its products. > The standard for a long time was obviously to form an initialism from a > string of 2-4 vague words. Old story is that if IBM had invented sushi, it > would be called "CDF" (cold dead fish). The fact that not all sushi has > fish of any temperature or vitality can be considered part of the joke. > > sas > > > On Wed, Mar 23, 2022 at 10:00 AM Rupert Reynolds > wrote: > > > I think the days of trying to say there is only one correct way to write > > its name are long gone! > > > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- zMan -- "I've got a mainframe and I'm not afraid to use it" -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: JES2 Purge Processing
Classification: Confidential Nope. It will just allow more concurrent operations. -Original Message- From: IBM Mainframe Discussion List On Behalf Of Mark Jacobs Sent: Wednesday, March 23, 2022 7:04 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: JES2 Purge Processing [CAUTION: This Email is from outside the Organization. Unless you trust the sender, Don't click links or open attachments as it may be a Phishing email, which can steal your Information and compromise your Computer.] Thanks. I was thinking about PCEDEF too. On this system PURGENUM is set to 2. Would setting a higher number helped speed up purge processing for a single job? Mark Jacobs Sent from ProtonMail, Swiss-based encrypted email. GPG Public Key - https://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapi.protonmail.ch%2Fpks%2Flookup%3Fop%3Dget%26search%3Dmarkjacobs%40protonmail.com&data=04%7C01%7Callan.staller%40HCL.COM%7C31a71f339f0f4a6d5f8008da0cc53b8a%7C189de737c93a4f5a8b686f4ca9941912%7C0%7C0%7C637836338508192141%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=ZaAhXXPT5BAz5hp0VBDb69Z%2F7VlLD%2FD4w8BJdEkwvKw%3D&reserved=0 --- Original Message --- On Wednesday, March 23rd, 2022 at 7:54 AM, Allan Staller <0387911dea17-dmarc-requ...@listserv.ua.edu> wrote: > Classification: Confidential > > I would check your PCEDEF. JES2 allows for up to 10 concurrent processes, and > defaults to 1. > > Your very large output may have been monopolizing the only purge processor > available. > > I do not believe your checkpoint, per se, was the problem, however, > > As of z/OS 2.1 JES2 offers "auto-tuning" of the minhold, maxdorm and other > parameters related to checkpoint processing in the MAS. > > I strongly suggest utilizing this function. Check the fine manuals for > details. BTW, ISTR that there is no initparm for this. It can only be set via > command(?). > > HTH, > > -Original Message- > > From: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU On Behalf > Of Mark Jacobs > > Sent: Tuesday, March 22, 2022 4:25 PM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: JES2 Purge Processing > > [CAUTION: This Email is from outside the Organization. Unless you > trust the sender, Don't click links or open attachments as it may be a > Phishing email, which can steal your Information and compromise your > Computer.] > > Yesterday we had a job with a huge amount of output take about 48 minutes to > complete purge processing. While it was being purged everything else on that > system that required JES2 services, basically spool space, wasn't able to do > so and was waiting for the purge to complete. This is a 3 system MAS, and I > think it's safe to say that any JES2 tuning activities hasn't been done in a > very long time. > > Does anyone have suggestions on what to look at in the system/JES2PARM > configuration that might speed purge processing up if this problem occurs > again? > > Mark Jacobs > > Sent from ProtonMail, Swiss-based encrypted email. > > GPG Public Key - > https://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapi. > protonmail.ch%2Fpks%2Flookup%3Fop%3Dget%26search%3Dmarkjacobs%40proton > mail.com&data=04%7C01%7Callan.staller%40HCL.COM%7C31a71f339f0f4a6d > 5f8008da0cc53b8a%7C189de737c93a4f5a8b686f4ca9941912%7C0%7C0%7C63783633 > 8508192141%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzI > iLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=ZaAhXXPT5BAz5hp0VBDb6 > 9Z%2F7VlLD%2FD4w8BJdEkwvKw%3D&reserved=0 > > -- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > ::DISCLAIMER:: > > > > The contents of this e-mail and any attachment(s) are confidential and > intended for the named recipient(s) only. E-mail transmission is not > guaranteed to be secure or error-free as information could be intercepted, > corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses > in transmission. The e mail and its contents (with or without referred > errors) shall therefore not attach any liability on the originator or HCL or > its affiliates. Views or opinions, if any, presented in this email are solely > those of the author and may not necessarily reflect the views or opinions of > HCL or its affiliates. Any form of reproduction, dissemination, copying, > disclosure, modification, distribution and / or publication of this message > without the prior written consent of authorized representative of HCL is > strictly prohibited. If you have received this email in error please delete > it and notify the sender immediately. Before opening any email and/or > attachments, please check them for viruses and other defects. > > > >
Re: Using SORT to add quotes around CHAR fields? (Listserv)
Hi, the last 3 columns are CHAR but you don't want them quoted? Don't know how to do it using SORT. I'd do it with Rexx. De: IBM Mainframe Discussion List en nombre de Don Johnson <02ee771a0785-dmarc-requ...@listserv.ua.edu> Enviado: miércoles, 23 de marzo de 2022 17:46 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: [EXTERNAL] Using SORT to add quotes around CHAR fields? (Listserv) This is a post now to the listserv, instead of the Google group. Sorry for the duplication! Hi, I have a comma-delimited extract from a file that has numeric and character fields, and I would like to turn it into a true CSV file by making the character fields quoted. I have a 2-line header (column names, and column types) which indicates which are CHAR fields, but cannot figure out how to capture the information from the header to apply to the actual data lines. For example, I have this in my file: ITM_ID,DESC,SHORT_DESC,U_M,UNIT_PRICE,ON_HAND,COMMIT,INV_HOLD,DISC_QTY,DISC_PCT,B_O_QTY,ON_ORD,ACT_YR,ACT_MO,ACT_DAY CHAR(10) N.N.,CHAR(30) NOT NULL,CHAR(8) N.N.,CHAR(4) N.N.,DEC(7,2) N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(1) N.N.,DEC(7,0) N.N.,DEC(3,1) N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(2) N.N.,CHAR(2) N.N.,CHAR(2) N.N. A1,CARPETED RUBBER MATS-FRONT-RED,FLOORMAT,PAIR,22.99,135,205,Y,5000,1.5,0,0,87,02,02 A10001,CARPETED RUBBER MATS-REAR(RED),FLOORMAT,PAIR,12.99,277,14,N,250,1.5,0,0,86,02,20 A10002,PERSONALIZED VINYL MATS(BEIGE),FLOORMAT,PAIR,19.99,296,7,N,250,1.5,0,0,87,02,03 A10003,4-PIECE CARPET MAT SET (BLUE),MAT SET,SET,19.99,275,2,N,250,1.5,0,0,87,02,03 A10004,SPLASH GUARDS-ALUMINUM,SPLSHGRD,PAIR,8.99,523,55,N,500,1.5,0,0,87,02,03 A10005,SPLASH GUARDS-VINYL,SPLSHGRD,PAIR,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 and want the output to look like this: "A1","CARPETED RUBBER MATS-FRONT-RED","FLOORMAT","PAIR",22.99,135,205,"Y",5000,1.5,0,0,87,02,02 "A10001","CARPETED RUBBER MATS-REAR(RED)","FLOORMAT","PAIR",12.99,277,14,"N",250,1.5,0,0,86,02,20 "A10002","PERSONALIZED VINYL MATS(BEIGE)","FLOORMAT","PAIR",19.99,296,7,"N",250,1.5,0,0,87,02,03 "A10003","4-PIECE CARPET MAT SET (BLUE)","MAT SET","SET",19.99,275,2,"N",250,1.5,0,0,87,02,03 "A10004","SPLASH GUARDS-ALUMINUM","SPLSHGRD","PAIR",8.99,523,55,"N",500,1.5,0,0,87,02,03 "A10005","SPLASH GUARDS-VINYL","SPLSHGRD","PAIR",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 column separated -- and then be able to apply quotes to that particular output field? I am not sure about this, but hope there is an answer here. Thank you for your help! Don Johnson Sr. Principal Support Engineer | MSD - Datacom product family Broadcom Software -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Using SORT to add quotes around CHAR fields? (Listserv)
>> I have a 2-line header (column names, and column types) which indicates >> which are CHAR fields, but cannot figure out how to capture the information >> from the header to apply to the actual data lines. >> Is there a way to see which column type contains CHAR( -- each of the types >> is column separated -- and then be able to apply quotes to that particular >> output field? I am not sure about this, but hope there is an answer here. Don, If your intention is to just enclose the character fields with double quotes, It can be done, however need couple of clarifications. 1. What is the LRECL and RECFM of the input dataset? 2. Looking at the data, it seems to comma separated data, however the 2nd header line that has the db2 column attributes has numeric fields which has the precision separated with a comma. Is there anything special to distinguish the attributes? What does N.N mean? Can I use that as separator? Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: PL/I question
>From the Title Page: Enterprise PL/I for z/OS Licensed Program Specifications Version 5 Release 2 I read or heard long long ago that the I in PL/I is a roman numeral. sas On Wed, Mar 23, 2022 at 4:15 PM Charles Mills wrote: > How does PL/I self-identify? > > Charles > > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Using SORT to add quotes around CHAR fields? (Listserv)
This is a post now to the listserv, instead of the Google group. Sorry for the duplication! Hi, I have a comma-delimited extract from a file that has numeric and character fields, and I would like to turn it into a true CSV file by making the character fields quoted. I have a 2-line header (column names, and column types) which indicates which are CHAR fields, but cannot figure out how to capture the information from the header to apply to the actual data lines. For example, I have this in my file: ITM_ID,DESC,SHORT_DESC,U_M,UNIT_PRICE,ON_HAND,COMMIT,INV_HOLD,DISC_QTY,DISC_PCT,B_O_QTY,ON_ORD,ACT_YR,ACT_MO,ACT_DAY CHAR(10) N.N.,CHAR(30) NOT NULL,CHAR(8) N.N.,CHAR(4) N.N.,DEC(7,2) N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(1) N.N.,DEC(7,0) N.N.,DEC(3,1) N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(2) N.N.,CHAR(2) N.N.,CHAR(2) N.N. A1,CARPETED RUBBER MATS-FRONT-RED,FLOORMAT,PAIR,22.99,135,205,Y,5000,1.5,0,0,87,02,02 A10001,CARPETED RUBBER MATS-REAR(RED),FLOORMAT,PAIR,12.99,277,14,N,250,1.5,0,0,86,02,20 A10002,PERSONALIZED VINYL MATS(BEIGE),FLOORMAT,PAIR,19.99,296,7,N,250,1.5,0,0,87,02,03 A10003,4-PIECE CARPET MAT SET (BLUE),MAT SET,SET,19.99,275,2,N,250,1.5,0,0,87,02,03 A10004,SPLASH GUARDS-ALUMINUM,SPLSHGRD,PAIR,8.99,523,55,N,500,1.5,0,0,87,02,03 A10005,SPLASH GUARDS-VINYL,SPLSHGRD,PAIR,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 and want the output to look like this: "A1","CARPETED RUBBER MATS-FRONT-RED","FLOORMAT","PAIR",22.99,135,205,"Y",5000,1.5,0,0,87,02,02 "A10001","CARPETED RUBBER MATS-REAR(RED)","FLOORMAT","PAIR",12.99,277,14,"N",250,1.5,0,0,86,02,20 "A10002","PERSONALIZED VINYL MATS(BEIGE)","FLOORMAT","PAIR",19.99,296,7,"N",250,1.5,0,0,87,02,03 "A10003","4-PIECE CARPET MAT SET (BLUE)","MAT SET","SET",19.99,275,2,"N",250,1.5,0,0,87,02,03 "A10004","SPLASH GUARDS-ALUMINUM","SPLSHGRD","PAIR",8.99,523,55,"N",500,1.5,0,0,87,02,03 "A10005","SPLASH GUARDS-VINYL","SPLSHGRD","PAIR",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 column separated -- and then be able to apply quotes to that particular output field? I am not sure about this, but hope there is an answer here. Thank you for your help! Don Johnson Sr. Principal Support Engineer | MSD - Datacom product family Broadcom Software -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unix Command DIFF
This is what I did and it worked. Thanks //CREATE EXEC PGM=BPXBATCH //STDOUT DD SYSOUT=* //stderr DD SYSOUT=* //* //STDPARM DD * SH diff -r /xxx / Thanks again sc -Original Message- From: IBM Mainframe Discussion List On Behalf Of Paul Gilmartin Sent: Wednesday, March 23, 2022 3:15 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Unix Command DIFF On Wed, 23 Mar 2022 15:05:56 -0500, Shelia wrote: >Does anyone know how to use the unix command diff -r in a batch job, if so can >you send me example of the batch job? > Untested: //STEP EXEC PGM=BPXBATCH, // PARM-'SH diff -r ' //STDOUT DD SYSOUT=(,) Or, use IRXJCL with Rex using BPXWUNIIX -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: PL/I question
How does PL/I self-identify? Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Steve Smith Sent: Wednesday, March 23, 2022 12:52 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: PL/I question Obviously they are not. As a matter of fact, there *is* one correct way (and the trademark owner would be happy to say so), and no number of errors or passage of time changes that. So it will be occasionally mentioned. One might complain about IBM's history of lousy names for its products. The standard for a long time was obviously to form an initialism from a string of 2-4 vague words. Old story is that if IBM had invented sushi, it would be called "CDF" (cold dead fish). The fact that not all sushi has fish of any temperature or vitality can be considered part of the joke. sas On Wed, Mar 23, 2022 at 10:00 AM Rupert Reynolds wrote: > I think the days of trying to say there is only one correct way to write > its name are long gone! > > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unix Command DIFF
On Wed, 23 Mar 2022 15:05:56 -0500, Shelia wrote: >Does anyone know how to use the unix command diff -r in a batch job, if so can >you send me example of the batch job? > Untested: //STEP EXEC PGM=BPXBATCH, // PARM-'SH diff -r ' //STDOUT DD SYSOUT=(,) Or, use IRXJCL with Rex using BPXWUNIIX -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unix Command DIFF
Look up BPXWUNIX. Lionel B Dyck < Sent from my iPad Pro 10.5 Website: www.lbdsoftware.com "Worry more about your character than your reputation. Character is what you are, reputation merely what others think you are." - John Wooden > On Mar 23, 2022, at 3:06 PM, Shelia Chalk > <03d9384cc8f1-dmarc-requ...@listserv.ua.edu> wrote: > > Does anyone know how to use the unix command diff -r in a batch job, if so > can you send me example of the batch job? > > thanks in advance. > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Unix Command DIFF
Does anyone know how to use the unix command diff -r in a batch job, if so can you send me example of the batch job? thanks in advance. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: PL/I question
Obviously they are not. As a matter of fact, there *is* one correct way (and the trademark owner would be happy to say so), and no number of errors or passage of time changes that. So it will be occasionally mentioned. One might complain about IBM's history of lousy names for its products. The standard for a long time was obviously to form an initialism from a string of 2-4 vague words. Old story is that if IBM had invented sushi, it would be called "CDF" (cold dead fish). The fact that not all sushi has fish of any temperature or vitality can be considered part of the joke. sas On Wed, Mar 23, 2022 at 10:00 AM Rupert Reynolds wrote: > I think the days of trying to say there is only one correct way to write > its name are long gone! > > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LOGONID SYSLOGD NOT FOUND
On Wed, 23 Mar 2022 13:26:10 -0500, Dave Jousma wrote: > >On my systems, SYSLOGD is started out of /etc/rc > ># Start the SYSLOGD daemon for logging and tracing >/etc/syslogd.start > > >manually starting SYSLOGD can be accomplished via Superuser >/etc/syslogd.start&. (or whatever command you have set it up as) > > >Here is link from the manual: >https://www.ibm.com/docs/en/zos/2.2.0?topic=daemon-starting-stopping-syslogd > >when started at IPL it runs under the ID that OMVS runs. A manual restart >needs to happen from a UID(0) ID.Starting as a regular S SYSLOGD is >possible, but as you find, your security is not setup for that. > I hate replying to my own posts. I was a bit incomplete. Here is the contents of my syslogd.start shell script. EDIT /DEV1/etc/syslogd.start Command ===> ** *** Top of Dat 01 # Licensed Materials - Property of IBM 02 # 5694-A01 03 # (C) Copyright IBM Corp. 1992, 2002 04 # Status = CSV1R4 05 # 06 ## 07 # 08 # Start the syslog daemon 09 # 10 export _BPX_JOBNAME='SYSLOGD' 11 /usr/sbin/syslogd -f /etc/syslog.conf -c -D 740 -F 644 & 12 DATE='date' 13 echo -- /etc/syslogd.start script executed, $DATE -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LOGONID SYSLOGD NOT FOUND
That's a great point Dave, I never thought about how the OP was starting SYSLOGD 3 hour drive to/from work and an early morning for me clouded my brain Carmen On 3/23/2022 1:26 PM, Dave Jousma wrote: On Wed, 23 Mar 2022 10:54:28 -0500, SUBSCRIBE IBM-MAIN Srinivas Aeturi wrote: Hi Everyone, We are running on z/OS 2.2. And we have configured SYSLOGD and it was running good. But now, The SYSLOGD ID is not existing and task SYSLOGD is not running. And we are getting below error when we try to start it. I see no one deleted SYSLOGD ID. But still, unable to figure out the issue what caused SYSLOGD ID to not present in the system. Did anyone experience this problem earlier. ACF01004 LOGONID SYSLOGD NOT FOUND IEF170I 1 SYSLOGD ACF01004 LOGONID SYSLOGD NOT FOUND IEE296I SYSLOGD FAILED BY SECURITY INTERFACE. RC=0004 RSN= SAFRC=0008 Thanks Srinivas On my systems, SYSLOGD is started out of /etc/rc # Start the SYSLOGD daemon for logging and tracing /etc/syslogd.start manually starting SYSLOGD can be accomplished via Superuser /etc/syslogd.start&. (or whatever command you have set it up as) Here is link from the manual:https://www.ibm.com/docs/en/zos/2.2.0?topic=daemon-starting-stopping-syslogd when started at IPL it runs under the ID that OMVS runs. A manual restart needs to happen from a UID(0) ID.Starting as a regular S SYSLOGD is possible, but as you find, your security is not setup for that. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email tolists...@listserv.ua.edu with the message: INFO IBM-MAIN -- /I am not bound to win, but I am bound to be true. I am not bound to succeed, but I am bound to live by the light that I have. I must stand with anybody that stands right, and stand with him while he is right, and part with him when he goes wrong. *Abraham Lincoln*/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LOGONID SYSLOGD NOT FOUND
On Wed, 23 Mar 2022 10:54:28 -0500, SUBSCRIBE IBM-MAIN Srinivas Aeturi wrote: >Hi Everyone, > >We are running on z/OS 2.2. And we have configured SYSLOGD and it was running >good. >But now, The SYSLOGD ID is not existing and task SYSLOGD is not running. And >we are getting below error when we try to start it. I see no one deleted >SYSLOGD ID. But still, unable to figure out the issue what caused SYSLOGD ID >to not present in the system. Did anyone experience this problem earlier. > >ACF01004 LOGONID SYSLOGD NOT FOUND >IEF170I 1 SYSLOGD ACF01004 LOGONID SYSLOGD NOT FOUND >IEE296I SYSLOGD FAILED BY SECURITY INTERFACE. RC=0004 RSN= >SAFRC=0008 > >Thanks >Srinivas On my systems, SYSLOGD is started out of /etc/rc # Start the SYSLOGD daemon for logging and tracing /etc/syslogd.start manually starting SYSLOGD can be accomplished via Superuser /etc/syslogd.start&. (or whatever command you have set it up as) Here is link from the manual: https://www.ibm.com/docs/en/zos/2.2.0?topic=daemon-starting-stopping-syslogd when started at IPL it runs under the ID that OMVS runs. A manual restart needs to happen from a UID(0) ID.Starting as a regular S SYSLOGD is possible, but as you find, your security is not setup for that. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LOGONID SYSLOGD NOT FOUND
Just another though, you said it was working good, usually if I'm not mistaking those processes start before any security system, if stopped or canceled and now started when ACF2 is UP and never defined to your security package you will get this same error, I've seen the same with processes lien LLA, DLF to mention a few Carmen On 3/23/2022 1:17 PM, Carmen Vitullo wrote: it's been a long time since I've worked with ACF2, so maybe the terminology ACF2 uses is confusing ACF2, TSS and RACF require an ID, not to much a LOGONID but IIRC those OMVS processes should all be running under the OMVS OWNER of BPXOINIT, maybe there's a mis-configuration or someone removed SYSLOGD from the list of processes that run (get initialized) under the OMVS address space - just a thought Carmen On 3/23/2022 10:54 AM, SUBSCRIBE IBM-MAIN Srinivas Aeturi wrote: Hi Everyone, We are running on z/OS 2.2. And we have configured SYSLOGD and it was running good. But now, The SYSLOGD ID is not existing and task SYSLOGD is not running. And we are getting below error when we try to start it. I see no one deleted SYSLOGD ID. But still, unable to figure out the issue what caused SYSLOGD ID to not present in the system. Did anyone experience this problem earlier. ACF01004 LOGONID SYSLOGD NOT FOUND IEF170I 1 SYSLOGD ACF01004 LOGONID SYSLOGD NOT FOUND IEE296I SYSLOGD FAILED BY SECURITY INTERFACE. RC=0004 RSN= SAFRC=0008 Thanks Srinivas -- For IBM-MAIN subscribe / signoff / archive access instructions, send email tolists...@listserv.ua.edu with the message: INFO IBM-MAIN -- /I am not bound to win, but I am bound to be true. I am not bound to succeed, but I am bound to live by the light that I have. I must stand with anybody that stands right, and stand with him while he is right, and part with him when he goes wrong. *Abraham Lincoln*/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LOGONID SYSLOGD NOT FOUND
it's been a long time since I've worked with ACF2, so maybe the terminology ACF2 uses is confusing ACF2, TSS and RACF require an ID, not to much a LOGONID but IIRC those OMVS processes should all be running under the OMVS OWNER of BPXOINIT, maybe there's a mis-configuration or someone removed SYSLOGD from the list of processes that run (get initialized) under the OMVS address space - just a thought Carmen On 3/23/2022 10:54 AM, SUBSCRIBE IBM-MAIN Srinivas Aeturi wrote: Hi Everyone, We are running on z/OS 2.2. And we have configured SYSLOGD and it was running good. But now, The SYSLOGD ID is not existing and task SYSLOGD is not running. And we are getting below error when we try to start it. I see no one deleted SYSLOGD ID. But still, unable to figure out the issue what caused SYSLOGD ID to not present in the system. Did anyone experience this problem earlier. ACF01004 LOGONID SYSLOGD NOT FOUND IEF170I 1 SYSLOGD ACF01004 LOGONID SYSLOGD NOT FOUND IEE296I SYSLOGD FAILED BY SECURITY INTERFACE. RC=0004 RSN= SAFRC=0008 Thanks Srinivas -- For IBM-MAIN subscribe / signoff / archive access instructions, send email tolists...@listserv.ua.edu with the message: INFO IBM-MAIN -- /I am not bound to win, but I am bound to be true. I am not bound to succeed, but I am bound to live by the light that I have. I must stand with anybody that stands right, and stand with him while he is right, and part with him when he goes wrong. *Abraham Lincoln*/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LOGONID SYSLOGD NOT FOUND
Has the (RACF / ACF / TopSecret / other security product) User SYSLOGD been removed? Are the permissions correct? On Wed, Mar 23, 2022 at 4:04 PM SUBSCRIBE IBM-MAIN Srinivas Aeturi wrote: > > Hi Everyone, > > We are running on z/OS 2.2. And we have configured SYSLOGD and it was > running good. > But now, The SYSLOGD ID is not existing and task SYSLOGD is not running. And > we are getting below error when we try to start it. I see no one deleted > SYSLOGD ID. But still, unable to figure out the issue what caused SYSLOGD ID > to not present in the system. Did anyone experience this problem earlier. > > ACF01004 LOGONID SYSLOGD NOT FOUND > IEF170I 1 SYSLOGD ACF01004 LOGONID SYSLOGD NOT FOUND > IEE296I SYSLOGD FAILED BY SECURITY INTERFACE. RC=0004 RSN= > SAFRC=0008 > > Thanks > Srinivas > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Mike A Schwab, Springfield IL USA Where do Forest Rangers go to get away from it all? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
LOGONID SYSLOGD NOT FOUND
Hi Everyone, We are running on z/OS 2.2. And we have configured SYSLOGD and it was running good. But now, The SYSLOGD ID is not existing and task SYSLOGD is not running. And we are getting below error when we try to start it. I see no one deleted SYSLOGD ID. But still, unable to figure out the issue what caused SYSLOGD ID to not present in the system. Did anyone experience this problem earlier. ACF01004 LOGONID SYSLOGD NOT FOUND IEF170I 1 SYSLOGD ACF01004 LOGONID SYSLOGD NOT FOUND IEE296I SYSLOGD FAILED BY SECURITY INTERFACE. RC=0004 RSN= SAFRC=0008 Thanks Srinivas -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: PL/I question
Is anyone still using the old PL1* PROCs? -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Rupert Reynolds [rreyno...@cix.co.uk] Sent: Wednesday, March 23, 2022 10:00 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: PL/I question I think the days of trying to say there is only one correct way to write its name are long gone! On Wed., Mar. 23, 2022, 00:52 Phil Smith III, wrote: > Bob Bridges wrote: > > > PL/1 was my first language. > > > > Only it's "PL/I". "Programming Language/One", but "PL/I". Just sayin'. > > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: PL/I question
May be, but I'm a not-very-secret pedant: I do prefer to select a "right" way to write it and stick to that forever after. "PL/I" it is. --- Bob Bridges, robhbrid...@gmail.com, cell 336 382-7313 /* Nobody realizes that some people expend tremendous energy merely to be normal. -Albert Camus */ -Original Message- From: IBM Mainframe Discussion List On Behalf Of Rupert Reynolds Sent: Wednesday, March 23, 2022 10:01 I think the days of trying to say there is only one correct way to write its name are long gone! --- On Wed., Mar. 23, 2022, 00:52 Phil Smith III, wrote: > Only it's "PL/I". "Programming Language/One", but "PL/I". Just sayin'. > --- Bob Bridges wrote: > > PL/1 was my first language. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: PL/I question
I think the days of trying to say there is only one correct way to write its name are long gone! On Wed., Mar. 23, 2022, 00:52 Phil Smith III, wrote: > Bob Bridges wrote: > > > PL/1 was my first language. > > > > Only it's "PL/I". "Programming Language/One", but "PL/I". Just sayin'. > > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: PL/I question
As long as the code is under your control, you can define a protocol for selecting options via SYSPARM and it works equally well for, e.g., open code, nested include, preprocessor procedures. -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Phil Smith III [li...@akphs.com] Sent: Tuesday, March 22, 2022 8:55 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: PL/I question Shmuel wrote: > There was mention of a possible need for two versions, and I was just pointing out that you can have a single source file that generates two different versions of the object code. Oh. There might be a need for two versions of the *include* file; not sure whether that can be made bimodal, but thanks, that might be something to explore, though that would require more PL/I expertise than I remember, whereas a second include file would not! Thanks. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: z/PDT
I'm told that the z/PDT Learner's Edition is not just the 2.5 AD/CD, but has other goodies on it as well. It also isn't quite the same as the commercial version, thoughI don't know what the differences are - but if you look at the z/PDT web page, you'll see that the latest version update doesn't apply to the LE. On Wed, Mar 23, 2022 at 8:03 AM John Abell < john.ab...@intnlsoftwareproducts.com> wrote: > We have the base configuration z/OS 2.5 ADCD that was released a couple of > weeks back installed and running as a guest under z/VM 7.1 on the latest > zPDT maintenance release without issues so far. > > John T. Abell > Tel:800-295-7608Option 4 > President > International: 1-416-593-5578 Option 4 > E-mail: john.ab...@intnlsoftwareproducts.com > Fax:800-295-7609 > > International: 1-416-593-5579 > > > International Software Products > www.ispinfo.com > > This email may contain confidential and privileged material for the sole > use of the intended recipient(s). Any review, use, retention, distribution > or disclosure by others is strictly prohibited. If you are not the intended > recipient (or authorized to receive on behalf of the named recipient), > please contact the sender by reply email and delete all copies of this > message. Also,email is susceptible to data corruption, interception, > tampering, unauthorized amendment and viruses. We only send and receive > emails on the basis that we are not liable for any such corruption, > interception, tampering, amendment or viruses or any consequence thereof. > > > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Jay Maynard > Sent: Wednesday, March 23, 2022 1:33 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: z/PDT > > I have completed all of the paperwork and paid my money. The last I heard, > the log4j business was indeed soaking up all of the bandwidth they had to > devote to such things, but they expected to have something to send out by > mid-February, and everything taken care of and ready to go by mid-March. > Obviously, they haven't made either date. I haven't gotten my USB dongle, > either. > > The date on my license is mid-January. I'm hoping they extend it. > > On Tue, Mar 22, 2022 at 11:41 PM Grant Taylor < > 023065957af1-dmarc-requ...@listserv.ua.edu> wrote: > > > On 3/22/22 10:37 PM, Brian Westerman wrote: > > > Has anyone heard any news about the lower cost z/PDT lately? I was > > > on the list, but everything seems to have been dropped. > > > > I heard from someone that they had completed the paperwork and were > > waiting on the approval as of early this year. From what they were > > saying, they were expecting to be in possession of a license by now. > > > > Sorry, I don't remember who and even if I did, I wouldn't share > > without their permission. ;-) > > > > I also heard through the grape vine that IBM had just about all hands > > on deck for the Log4J fiasco, all platforms. As such, people that > > were working on the hobbyist / student licensing were re-assigned for > > a while. I'm speculating that they are now back on task. > > > > > > > > -- > > Grant. . . . > > unix || die > > > > -- > > For IBM-MAIN subscribe / signoff / archive access instructions, send > > email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > > > > -- > Jay Maynard > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, send email > to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Jay Maynard -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: z/PDT
Same here. ITschak בתאריך יום ד׳, 23 במרץ 2022 ב-15:03 מאת John Abell < john.ab...@intnlsoftwareproducts.com>: > We have the base configuration z/OS 2.5 ADCD that was released a couple of > weeks back installed and running as a guest under z/VM 7.1 on the latest > zPDT maintenance release without issues so far. > > John T. Abell > Tel:800-295-7608Option 4 > President > International: 1-416-593-5578 Option 4 > E-mail: john.ab...@intnlsoftwareproducts.com > Fax:800-295-7609 > > International: 1-416-593-5579 > > > International Software Products > www.ispinfo.com > > This email may contain confidential and privileged material for the sole > use of the intended recipient(s). Any review, use, retention, distribution > or disclosure by others is strictly prohibited. If you are not the intended > recipient (or authorized to receive on behalf of the named recipient), > please contact the sender by reply email and delete all copies of this > message. Also,email is susceptible to data corruption, interception, > tampering, unauthorized amendment and viruses. We only send and receive > emails on the basis that we are not liable for any such corruption, > interception, tampering, amendment or viruses or any consequence thereof. > > > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Jay Maynard > Sent: Wednesday, March 23, 2022 1:33 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: z/PDT > > I have completed all of the paperwork and paid my money. The last I heard, > the log4j business was indeed soaking up all of the bandwidth they had to > devote to such things, but they expected to have something to send out by > mid-February, and everything taken care of and ready to go by mid-March. > Obviously, they haven't made either date. I haven't gotten my USB dongle, > either. > > The date on my license is mid-January. I'm hoping they extend it. > > On Tue, Mar 22, 2022 at 11:41 PM Grant Taylor < > 023065957af1-dmarc-requ...@listserv.ua.edu> wrote: > > > On 3/22/22 10:37 PM, Brian Westerman wrote: > > > Has anyone heard any news about the lower cost z/PDT lately? I was > > > on the list, but everything seems to have been dropped. > > > > I heard from someone that they had completed the paperwork and were > > waiting on the approval as of early this year. From what they were > > saying, they were expecting to be in possession of a license by now. > > > > Sorry, I don't remember who and even if I did, I wouldn't share > > without their permission. ;-) > > > > I also heard through the grape vine that IBM had just about all hands > > on deck for the Log4J fiasco, all platforms. As such, people that > > were working on the hobbyist / student licensing were re-assigned for > > a while. I'm speculating that they are now back on task. > > > > > > > > -- > > Grant. . . . > > unix || die > > > > -- > > For IBM-MAIN subscribe / signoff / archive access instructions, send > > email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > > > > -- > Jay Maynard > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, send email > to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- ITschak Mugzach *|** IronSphere Platform* *|* *Information Security Continuous Monitoring for z/OS, x/Linux & IBM I **| z/VM coming soon * -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: z/PDT
We have the base configuration z/OS 2.5 ADCD that was released a couple of weeks back installed and running as a guest under z/VM 7.1 on the latest zPDT maintenance release without issues so far. John T. Abell Tel:800-295-7608Option 4 President International: 1-416-593-5578 Option 4 E-mail: john.ab...@intnlsoftwareproducts.com Fax:800-295-7609 International: 1-416-593-5579 International Software Products www.ispinfo.com This email may contain confidential and privileged material for the sole use of the intended recipient(s). Any review, use, retention, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive on behalf of the named recipient), please contact the sender by reply email and delete all copies of this message. Also,email is susceptible to data corruption, interception, tampering, unauthorized amendment and viruses. We only send and receive emails on the basis that we are not liable for any such corruption, interception, tampering, amendment or viruses or any consequence thereof. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Jay Maynard Sent: Wednesday, March 23, 2022 1:33 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: z/PDT I have completed all of the paperwork and paid my money. The last I heard, the log4j business was indeed soaking up all of the bandwidth they had to devote to such things, but they expected to have something to send out by mid-February, and everything taken care of and ready to go by mid-March. Obviously, they haven't made either date. I haven't gotten my USB dongle, either. The date on my license is mid-January. I'm hoping they extend it. On Tue, Mar 22, 2022 at 11:41 PM Grant Taylor < 023065957af1-dmarc-requ...@listserv.ua.edu> wrote: > On 3/22/22 10:37 PM, Brian Westerman wrote: > > Has anyone heard any news about the lower cost z/PDT lately? I was > > on the list, but everything seems to have been dropped. > > I heard from someone that they had completed the paperwork and were > waiting on the approval as of early this year. From what they were > saying, they were expecting to be in possession of a license by now. > > Sorry, I don't remember who and even if I did, I wouldn't share > without their permission. ;-) > > I also heard through the grape vine that IBM had just about all hands > on deck for the Log4J fiasco, all platforms. As such, people that > were working on the hobbyist / student licensing were re-assigned for > a while. I'm speculating that they are now back on task. > > > > -- > Grant. . . . > unix || die > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, send > email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Jay Maynard -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: JES2 Purge Processing
Thanks. I was thinking about PCEDEF too. On this system PURGENUM is set to 2. Would setting a higher number helped speed up purge processing for a single job? Mark Jacobs Sent from ProtonMail, Swiss-based encrypted email. GPG Public Key - https://api.protonmail.ch/pks/lookup?op=get&search=markjac...@protonmail.com --- Original Message --- On Wednesday, March 23rd, 2022 at 7:54 AM, Allan Staller <0387911dea17-dmarc-requ...@listserv.ua.edu> wrote: > Classification: Confidential > > I would check your PCEDEF. JES2 allows for up to 10 concurrent processes, and > defaults to 1. > > Your very large output may have been monopolizing the only purge processor > available. > > I do not believe your checkpoint, per se, was the problem, however, > > As of z/OS 2.1 JES2 offers "auto-tuning" of the minhold, maxdorm and other > parameters related to checkpoint processing in the MAS. > > I strongly suggest utilizing this function. Check the fine manuals for > details. BTW, ISTR that there is no initparm for this. It can only be set via > command(?). > > HTH, > > -Original Message- > > From: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU On Behalf Of > Mark Jacobs > > Sent: Tuesday, March 22, 2022 4:25 PM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: JES2 Purge Processing > > [CAUTION: This Email is from outside the Organization. Unless you trust the > sender, Don't click links or open attachments as it may be a Phishing email, > which can steal your Information and compromise your Computer.] > > Yesterday we had a job with a huge amount of output take about 48 minutes to > complete purge processing. While it was being purged everything else on that > system that required JES2 services, basically spool space, wasn't able to do > so and was waiting for the purge to complete. This is a 3 system MAS, and I > think it's safe to say that any JES2 tuning activities hasn't been done in a > very long time. > > Does anyone have suggestions on what to look at in the system/JES2PARM > configuration that might speed purge processing up if this problem occurs > again? > > Mark Jacobs > > Sent from ProtonMail, Swiss-based encrypted email. > > GPG Public Key - > https://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapi.protonmail.ch%2Fpks%2Flookup%3Fop%3Dget%26search%3Dmarkjacobs%40protonmail.com&data=04|01|allan.staller%40HCL.COM|940b59fc6a9446de16ec08da0c4a884d|189de737c93a4f5a8b686f4ca9941912|0|0|637835811513743578|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|3000&sdata=IFmAY8Ke2hU4C86BTzpw33gntTYJ6IjEwQ%2B67MN0SM4%3D&reserved=0 > > -- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > ::DISCLAIMER:: > > > > The contents of this e-mail and any attachment(s) are confidential and > intended for the named recipient(s) only. E-mail transmission is not > guaranteed to be secure or error-free as information could be intercepted, > corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses > in transmission. The e mail and its contents (with or without referred > errors) shall therefore not attach any liability on the originator or HCL or > its affiliates. Views or opinions, if any, presented in this email are solely > those of the author and may not necessarily reflect the views or opinions of > HCL or its affiliates. Any form of reproduction, dissemination, copying, > disclosure, modification, distribution and / or publication of this message > without the prior written consent of authorized representative of HCL is > strictly prohibited. If you have received this email in error please delete > it and notify the sender immediately. Before opening any email and/or > attachments, please check them for viruses and other defects. > > > > -- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: JES2 Purge Processing
Classification: Confidential I would check your PCEDEF. JES2 allows for up to 10 concurrent processes, and defaults to 1. Your very large output may have been monopolizing the only purge processor available. I do not believe your checkpoint, per se, was the problem, however, As of z/OS 2.1 JES2 offers "auto-tuning" of the minhold, maxdorm and other parameters related to checkpoint processing in the MAS. I strongly suggest utilizing this function. Check the fine manuals for details. BTW, ISTR that there is no initparm for this. It can only be set via command(?). HTH, -Original Message- From: IBM Mainframe Discussion List On Behalf Of Mark Jacobs Sent: Tuesday, March 22, 2022 4:25 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: JES2 Purge Processing [CAUTION: This Email is from outside the Organization. Unless you trust the sender, Don't click links or open attachments as it may be a Phishing email, which can steal your Information and compromise your Computer.] Yesterday we had a job with a huge amount of output take about 48 minutes to complete purge processing. While it was being purged everything else on that system that required JES2 services, basically spool space, wasn't able to do so and was waiting for the purge to complete. This is a 3 system MAS, and I think it's safe to say that any JES2 tuning activities hasn't been done in a very long time. Does anyone have suggestions on what to look at in the system/JES2PARM configuration that might speed purge processing up if this problem occurs again? Mark Jacobs Sent from [ProtonMail](https://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fprotonmail.com%2F&data=04%7C01%7Callan.staller%40HCL.COM%7C940b59fc6a9446de16ec08da0c4a884d%7C189de737c93a4f5a8b686f4ca9941912%7C0%7C0%7C637835811513743578%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=ylKI7xZvsZ61Y8he1LOLAodBtbHqOH%2F5pxElB%2FrXePE%3D&reserved=0), Swiss-based encrypted email. GPG Public Key - https://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapi.protonmail.ch%2Fpks%2Flookup%3Fop%3Dget%26search%3Dmarkjacobs%40protonmail.com&data=04%7C01%7Callan.staller%40HCL.COM%7C940b59fc6a9446de16ec08da0c4a884d%7C189de737c93a4f5a8b686f4ca9941912%7C0%7C0%7C637835811513743578%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=IFmAY8Ke2hU4C86BTzpw33gntTYJ6IjEwQ%2B67MN0SM4%3D&reserved=0 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ::DISCLAIMER:: The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: JES2 Purge Processing [EXTERNAL]
Thanks. I just checked the logs from all three systems for that day. No $HASP263 messages were issued on any system. Mark Jacobs Sent from ProtonMail, Swiss-based encrypted email. GPG Public Key - https://api.protonmail.ch/pks/lookup?op=get&search=markjac...@protonmail.com --- Original Message --- On Tuesday, March 22nd, 2022 at 5:59 PM, Feller, Paul <02fc94e14c43-dmarc-requ...@listserv.ua.edu> wrote: > Mark, I guess I would ask if you saw any $HASP263 messages on the other > lpars? Seeing message $HASP263 would indicate issues with the checkpoint > processing. That could hold up things on the other members in the MAS. > > From the JES2 message manual for z/OS 2.4. > > $HASP263 > > Explanation > > WAITING FOR ACCESS TO JES2 CHECKPOINT VOLUME volser > > LOCK HELD BY MEMBER member_name > > LOCK HELD BY SYSTEM > > SYSTEM MANAGED PROCESS ACTIVE > > When the primary checkpoint data set resides on DASD, JES2 has issued a > RESERVE operation to the CKPT1 or > > CKPT2 data set on volume volser. The number of seconds specified as the time > interval on the LOCKOUT > > parameter on the MASDEF initialization statement or on the $T MASDEF operator > command has elapsed, but the > > RESERVE operation has not completed. Another member in the multi-access spool > configuration might have > > ended while holding the hardware RESERVE on the checkpoint data set. > > This message is informational and displays why the lock cannot be obtained. > Either: > > • The lock is held by another member of the MAS. > > • The lock is in transition and is held by MVS. If this state persists, there > might be an XCF signaling problem or a system might have failed. > > • The lock cannot be obtained because a system managed process is active for > the structure. > > Paul Feller > > GTS Mainframe Technical Support > > -Original Message- > > From: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU On Behalf Of > Mark Jacobs > > Sent: Tuesday, March 22, 2022 4:25 PM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: JES2 Purge Processing [EXTERNAL] > > Yesterday we had a job with a huge amount of output take about 48 minutes to > complete purge processing. While it was being purged everything else on that > system that required JES2 services, basically spool space, wasn't able to do > so and was waiting for the purge to complete. This is a 3 system MAS, and I > think it's safe to say that any JES2 tuning activities hasn't been done in a > very long time. > > Does anyone have suggestions on what to look at in the system/JES2PARM > configuration that might speed purge processing up if this problem occurs > again? > > Mark Jacobs > > Sent from ProtonMail, Swiss-based encrypted email. > > GPG Public Key - > https://urldefense.proofpoint.com/v2/url?u=https-3A__api.protonmail.ch_pks_lookup-3Fop-3Dget-26search-3Dmarkjacobs-40protonmail.com&d=DwIGaQ&c=9g4MJkl2VjLjS6R4ei18BA&r=eUhu3PeeWy6RTndlJVKembFjFsvwCa8eeU_gm45NyOc&m=fxAqxmkYZvk6cRaMRvdn973XKmXJectUWeVC64AT8M4YsiucmroOptanei41wdqL&s=mX7vghlPjDzvU7u_YjjvHEluDHIww2MgJmcgmon4aKg&e= > > -- > > For IBM-MAIN subscribe / signoff / archive access instructions, send email to > lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > -- > > Please note: This message originated outside your organization. Please use > caution when opening links or attachments. > > -- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: JES2 Purge Processing
Perhaps start by looking at the SMF26 records to see the timing and output size, that may give insight into where the elapsed time is going (note that it could be in JES2 user exits). That may suggest what locking is happening if that is relevant to your problem. On Wed, Mar 23, 2022 at 8:25 AM Mark Jacobs < 0224d287a4b1-dmarc-requ...@listserv.ua.edu> wrote: > Yesterday we had a job with a huge amount of output take about 48 minutes > to complete purge processing. While it was being purged everything else on > that system that required JES2 services, basically spool space, wasn't able > to do so and was waiting for the purge to complete. This is a 3 system MAS, > and I think it's safe to say that any JES2 tuning activities hasn't been > done in a very long time. > > Does anyone have suggestions on what to look at in the system/JES2PARM > configuration that might speed purge processing up if this problem occurs > again? > > Mark Jacobs > > Sent from [ProtonMail](https://protonmail.com), Swiss-based encrypted > email. > > GPG Public Key - > https://api.protonmail.ch/pks/lookup?op=get&search=markjac...@protonmail.com > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN