Re: IRRDBU00 format
In addition, look in SYS1.SAMPLIB at RACDBULD. It is a DB2 load command from which it is easy to figure out the data and the columns it is in. Not at home or I'd have more information. On Tue, Nov 27, 2018, 07:21 Sankaranarayanan, Vignesh < vignesh.v.sankaranaraya...@marks-and-spencer.com wrote: > Hello List, > > Can you please point me to a link for the format of the different record > types in IRRDBU00. > From what I see, I could find only some pictures for some parts of some > record types. > > Thanks in advance. > > - Vignesh > Mainframe Infrastructure > > > MARKSANDSPENCER.COM > > Unless otherwise stated above: > Marks and Spencer plc > Registered Office: > Waterside House > 35 North Wharf Road > London > W2 1NW > > Registered No. 214436 in England and Wales. > > Telephone (020) 7935 4422 > Facsimile (020) 7487 2670 > > www.marksandspencer.com > > Please note that electronic mail may be monitored. > > This e-mail is confidential. If you received it by mistake, please let us > know and then delete it from your system; you should not copy, disclose, or > distribute its contents to anyone nor act in reliance on this e-mail, as > this is prohibited and may be unlawful. > > -- > 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: IRRDBU00 format
Sankaranarayanan, Vignesh wrote: >>"Not really, both Lou and myself referred you to v2.3, your book is v2.1." >Hold on there, let me put on my nerd glasses 😊 Hahaha. We all in IT are fully trained nerds... ;-D I hope you could get what you need. Just ask again if you need something. 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
Re: [EXTERNAL] Re: IRRDBU00 format
Cheers. "Not really, both Lou and myself referred you to v2.3, your book is v2.1." Hold on there, let me put on my nerd glasses 😊 – Vignesh Mainframe Infrastructure -Original Message- From: IBM Mainframe Discussion List On Behalf Of Elardus Engelbrecht Sent: 28 November 2018 06:51 To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: IRRDBU00 format Sankaranarayanan, Vignesh wrote: >Elardus, I was looking at >https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.1.0/com.ibm.zos >.v2r1.icha300/dbutypes.htm >Heh, looks like the answer is within the same book... Not really, both Lou and myself referred you to v2.3, your book is v2.1. Anyways, I see the 'pictures' you're referring, they're useful, because they show the relationship between the different record types. But for myself, I rather use other parts of the books where the exact layout of each record type is described. You have asked for 'format of the different record types', here, for example, is the specific layout of the User Basic data record (0200) which is listed here (for v2.3): https://www.ibm.com/support/knowledgecenter/SSLTBW_2.3.0/com.ibm.zos.v2r3.icha300/usr.htm#rec0200 Just browse around and you will also see other record types. 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 MARKSANDSPENCER.COM Unless otherwise stated above: Marks and Spencer plc Registered Office: Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: IRRDBU00 format
Sankaranarayanan, Vignesh wrote: >Elardus, I was looking at >https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.1.0/com.ibm.zos.v2r1.icha300/dbutypes.htm >Heh, looks like the answer is within the same book... Not really, both Lou and myself referred you to v2.3, your book is v2.1. Anyways, I see the 'pictures' you're referring, they're useful, because they show the relationship between the different record types. But for myself, I rather use other parts of the books where the exact layout of each record type is described. You have asked for 'format of the different record types', here, for example, is the specific layout of the User Basic data record (0200) which is listed here (for v2.3): https://www.ibm.com/support/knowledgecenter/SSLTBW_2.3.0/com.ibm.zos.v2r3.icha300/usr.htm#rec0200 Just browse around and you will also see other record types. 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
Re: [EXTERNAL] Re: IRRDBU00 format
Thanks Lou. Elardus, I was looking at https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.1.0/com.ibm.zos.v2r1.icha300/dbutypes.htm Heh, looks like the answer is within the same book... – Vignesh Mainframe Infrastructure -Original Message- From: IBM Mainframe Discussion List On Behalf Of Elardus Engelbrecht Sent: 27 November 2018 13:40 To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: IRRDBU00 format Sankaranarayanan, Vignesh wrote: >Can you please point me to a link for the format of the different record types >in IRRDBU00. >From what I see, I could find only some pictures for some parts of some record >types. From where? Please post the source of 'pictures for some parts of some record types'. You got a good and useful PDF link from Lou Lousee. Here is the KC version (this one is the TOC entry): https://www.ibm.com/support/knowledgecenter/SSLTBW_2.3.0/com.ibm.zos.v2r3.icha300/toc.htm I think you should just try out to use/navigate the KC and do your own researches. 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 MARKSANDSPENCER.COM Unless otherwise stated above: Marks and Spencer plc Registered Office: Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: IRRDBU00 format
Sankaranarayanan, Vignesh wrote: >Can you please point me to a link for the format of the different record types >in IRRDBU00. >From what I see, I could find only some pictures for some parts of some record >types. From where? Please post the source of 'pictures for some parts of some record types'. You got a good and useful PDF link from Lou Lousee. Here is the KC version (this one is the TOC entry): https://www.ibm.com/support/knowledgecenter/SSLTBW_2.3.0/com.ibm.zos.v2r3.icha300/toc.htm I think you should just try out to use/navigate the KC and do your own researches. 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
Re: IRRDBU00 format
Chapter 9 in this book: https://www-01.ibm.com/servers/resourcelink/svc00100.nsf/pages/zOSV2R3sa232288/$file/icha300_v2r3.pdf RACF MAcros and Interfaces Lou -- Artificial Intelligence is no match for Natural Stupidity - Unknown On Tue, Nov 27, 2018 at 7:21 AM Sankaranarayanan, Vignesh < vignesh.v.sankaranaraya...@marks-and-spencer.com> wrote: > Hello List, > > Can you please point me to a link for the format of the different record > types in IRRDBU00. > From what I see, I could find only some pictures for some parts of some > record types. > > Thanks in advance. > > - Vignesh > Mainframe Infrastructure > > > MARKSANDSPENCER.COM > > Unless otherwise stated above: > Marks and Spencer plc > Registered Office: > Waterside House > 35 North Wharf Road > London > W2 1NW > > Registered No. 214436 in England and Wales. > > Telephone (020) 7935 4422 > Facsimile (020) 7487 2670 > > www.marksandspencer.com > > Please note that electronic mail may be monitored. > > This e-mail is confidential. If you received it by mistake, please let us > know and then delete it from your system; you should not copy, disclose, or > distribute its contents to anyone nor act in reliance on this e-mail, as > this is prohibited and may be unlawful. > > -- > 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
IRRDBU00 format
Hello List, Can you please point me to a link for the format of the different record types in IRRDBU00. >From what I see, I could find only some pictures for some parts of some record >types. Thanks in advance. - Vignesh Mainframe Infrastructure MARKSANDSPENCER.COM Unless otherwise stated above: Marks and Spencer plc Registered Office: Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN