Sri h Kolusu wrote: >You just need to define a symbol for the current date and you can use it in >FINDREP. You do not code OPTION COPY when you use COPY verb of ICETOOL.
>Here is a sample >//SYMNAMES DD * >CURRDATE,S'&LYR4.&LMON.&LDAY' >//SORTCNTL DD * > OUTREC FINDREP=(IN=C'YYYYMMDD',OUT=CURRDATE) Yes! Yes! Yes! That worked! Wow! I totaly forgot about that symbols things inside ICETOOL! Many thanks! I must humbly say thank you for your kind help! I really appreciate it much. >btw is there a reason as to why you chose ICETOOL? We standardised on that, because it is easy to build up reports from raw SMF, IRRADU00, IRRDBU00, zSecure and custom reports as produced from different products. We need to place columns in certain order. For some client it is easy to specify sort order. Some clients want it sorted by id, but another clients want to it by date/time. Some clients dont want headers, so I had to drop them. ICETOOL language is neatly understandable and teachable to dummies. ;-) Things like this made us decide on ICETOOL: DATE(4MD/) - TIME(24:) - BREAK(23,8,CH) BTITLE('IDS') - WIDTH(<number>) - With above we can standardize on date / time format and breakup of reports by ids or whatever criteria. What is more, I use Automation and CPPUPDTE to pre-fill in some data or just insert dynamic sort input. Then it is off to ICETOOL, then IEBGENER to SMTP. Oh, I use ICETOOL when I just grab some raw SMF data in a hurry to produce some reports. Nothing else beat these ICETOOL statements to translate date/time in SMF into readable format: HEADER('SMFTYP') ON(6,1,BI) - HEADER('DATE') ON(11,4,DT1,E'9999/99/99') - HEADER('TIME') ON(7,4,TM1,E'99:99:99') - You can always write Assembler or other language programs to directly translate those fields into something readable, but why re-invent the wheel? ;-) But the most important reason why we use ICETOOL is - Instead having our clients writing own COBOL programs to do reporting, they can do some ICETOOL reporting with some of the summarization commands to produce totals. Paul Gilmartin wrote: >You could consider: //SYSUT1 DD *,SYMBOLS= instead of ICETOOL and >substitute the dynamic system symbols for &YYMMDD and &HHMMSS, however: Thanks. I have tried that out, but as you said the format is not pretty. Richard Pinion wrote: >While not directly related to your question, but are you family with XMITIP >from Lionel B. Dyck? Real handy stuff for emailing and attachments from the >mainframe. I know about that and have played years ago with that when a colleague gave me a copy from a SHARE session on a CD. Yep, CD. That is ancient computing... ;-) But we need to send out attachments in text format unlike XMITIP which can use PDF/ZIP/RTF/HTML formats. Simply because more than half of our clients (due to regulations) can only accept txt format. Whats more, IBM Communication Server SMTP can simply blank out the TO field of the e-mails. The clients really don't need who else are also receiving our audit e-mails. >That should be "FAMILIAR" not "FAMILAR"! Hahaha. I forgive you. I always read your and other's e-mail because I want to learn! Many thanks to all. My problem is solved! And I have been SORTed out ! ;-) Groete / Greetings Elardus Engelbrecht ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN