Re: IRRDBU00 format

2018-11-28 Thread John McKown
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

2018-11-28 Thread Elardus Engelbrecht
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

2018-11-27 Thread Sankaranarayanan, Vignesh
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

2018-11-27 Thread Elardus Engelbrecht
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

2018-11-27 Thread Sankaranarayanan, Vignesh
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

2018-11-27 Thread Elardus Engelbrecht
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

2018-11-27 Thread Lou Losee
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

2018-11-27 Thread Sankaranarayanan, Vignesh
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