• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

RE: User Reference field URRF

sshepard

Active Member
RE: User Reference field URRF

In response to:

Hi List,
>
> Is there a way that I can obtain all the places
> (tables, forms, UBE's etc) that the field URRF is used
> in. I do know that I could obtain it in the cross
> reference but we don't have one built as yet and there
> doesn't seem to be a plan to build one, anyway. I was
> wondering if someone out there had a plan B to obtain
> the details. We are actually planning on changing the
> size of the field and wanted to find out if it would
> be affecting anything else.
>
> Thank you all for your help
> Yathindra
>
> One World XE SP13.1 ES:AS/400 DS: WINNT

We are on B732.2, SP 11.3. Assuming XE is not too dissimilar ...

Go to GH902
Select P980011 (Cross Reference Facility)
Choose FORMS USING DATA ITEMS, for example
In the "Data Item Name" field, type in the alias - Find
Displayed will be applications using that alias.

Try TABLES USING DATA ITEMS to find tables containing that alias.

Steve Shepard
O'Gara - Hess & Eisenhardt
(513) 881-5477
sshepard@ogara-hess.com
 

DIlchenko

Member
Yathindra,

If you were running Oracle, I would have recommended the query:

select distinct table_name, column_name from dba_tab_columns where column_name like '%URRF%'

I've just ran it myself on my Xe, found the following results (maybe they prove helpful for you)

Hope I'm not posting too much junk ;))

--
F0006Z1,SZURRF
F0018T,TDURRF
F0039,GNURRF
F0039M,GHURRF
F004201,PTURRF
F007101,TAURRF
F007111,TBURRF
F00UI391,GWURRF
F00UI392,GWURRF
F00UI393,GWURRF
F0101,ABURRF
F0101Z1,VOURRF
F0101Z2,SZURRF
F0301,A5URRF
F03012,AIURRF
F03012Z1,VOURRF
F03B01,A5URRF
F03B11,RPURRF
F03B11P,RPURRF
F03B11Z1,VJURRF
F03B11Z2,SYURRF
F03B13,RYURRF
F03B13P,RYURRF
F03B13Z2,SYURRF
F03B14Z2,SZURRF
F03B41Z1,SZURRF
F03B575,RDURRF
F03B672,RDURRF
F0401,A6URRF
F0401Z1,VOURRF
F0411,RPURRF
F0411A,RPURRF
F0411P,RPURRF
F0411Z1,VLURRF
F0411Z3,SZURRF
F0413Z1,SYURRF
F0414Z1,SZURRF
F060116Z,SZURRF
F0911Z4,SZURRF
F1001,GPURRF
F1001Z1,IAURRF
F1002,GQURRF
F1002Z1,SZURRF
F1201Z1,FAURRF
F1217,WRURRF
F1217Z1,WRURRF
F15011B,NKURRF
F15012B,NSURRF
F15013B,NOURRF
F15014B,NPURRF
F15015B,NQURRF
F15016B,NUURRF
F15017,NWURRF
F15019,NLURRF
F1501B,NEURRF
F15020,NNURRF
F1502B,NFURRF
F1502WAB,NFURRF
F1502WB,N4URRF
F1505B,NDURRF
F1505HB,OKURRF
F1510B,OEURRF
F1511B,NJURRF
F1511B1,NWURRF
F1511HB,NCURRF
F1513B,O3URRF
F1514,NWURRF
F1521,NBURRF
F1523,OGURRF
F1525B,NMURRF
F1532B,NTURRF
F1533B,NMURRF
F1538B,NZURRF
F1540B,NRURRF
F15410,N9URRF
F1541B,N8URRF
F1543B,OAURRF
F1544B,OBURRF
F1548B,N1URRF
F15525W,RTURRF
F1565,JFURRF
F159071,NYURRF
F1713,EEURRF
F1720,CHURRF
F1721,CDURRF
F1731,LQURRF
F1755,ZAURRF
F1757,ZAURRF
F1758,ZBURRF
F1760,ZBURRF
F1797,CSURRF
F1811,TKURRF
F30006,IWURRF
F30006Z1,SZURRF
F3002,IXURRF
F3002Z1,SZURRF
F3003,IRURRF
F3003Z1,SZURRF
F3011,IZURRF
F3016,KMURRF
F30161,KDURRF
F30161Z1,SZURRF
F30UI003,IXURRF
F3109,IPURRF
F31091,IQURRF
F3111,WMURRF
F3111S,WMURRF
F3111Z1,SZURRF
F3112,WLURRF
F31122Z1,SZURRF
F3112S,WLURRF
F3112Z1,SZURRF
F3212,RCURRF
F3281,RTURRF
F3282,RKURRF
F32821,RLURRF
F3283,RDURRF
F3291,KWURRF
F3292,KUURRF
F3293,KYURRF
F3294Z,AZURRF
F3460Z1,FTURRF
F34A10,N0URRF
F34A11,N1URRF
F3701,QAURRF
F3702,QSURRF
F37021,QDURRF
F3711,TRURRF
F3711Z1,SZURRF
F37900,TRURRF
F38010,DNURRF
F38011,DFURRF
F38012,DPURRF
F38013,DQURRF
F38014,DRURRF
F38111,DZURRF
F38112,DXURRF
F4001Z,SYURRF
F40051,RDURRF
F40070,PFURRF
F40071,CUURRF
F40072,GIURRF
F40073,HYURRF
F4011Z,SZURRF
F4015,OTURRF
F40300R,PMURRF
F40301,PTURRF
F40301R,PTURRF
F40302,PUURRF
F40302R,PUURRF
F40303,RVURRF
F40303R,RVURRF
F40304,PEURRF
F40304R,PEURRF
F40305,RMURRF
F40305R,RMURRF
F40306,SRURRF
F40307,LAURRF
F40308,GSURRF
F40308R,GSURRF
F40309,DYURRF
F40309R,DYURRF
F40310,LBURRF
F40310R,LBURRF
F40311,P1URRF
F40311R,P1URRF
F40312,P2URRF
F40312R,P2URRF
F40313,P3URRF
F40313R,P3URRF
F40314,PJURRF
F40314R,PJURRF
F40315,PIURRF
F40315R,PIURRF
F40316,OPURRF
F40316R,OPURRF
F40318,QCURRF
F40318R,QCURRF
F40329,DDURRF
F40330,DGURRF
F40331,OEURRF
F40332,CFURRF
F40333,CAURRF
F40334,MTURRF
F40338,PTURRF
F40338R,PTURRF
F40339,LAURRF
F40341,NSURRF
F40341R,NSURRF
F40344,SAURRF
F40344R,SAURRF
F40345,CRURRF
F40345R,CRURRF
F40347,RIURRF
F40347R,RIURRF
F40349,RVURRF
F40349R,RVURRF
F40350,OQURRF
F4070,SNURRF
F4071,ATURRF
F4072,ADURRF
F40UI002,UTURRF
F40UI00T,PNURRF
F4100,LMURRF
F4101,IMURRF
F41011,PKURRF
F4101A,IMURRF
F4101B,IMURRF
F4101W,IMURRF
F4101Z1,SZURRF
F4101Z1A,SZURRF
F4102,IBURRF
F41021,LIURRF
F41021WF,LWURRF
F41021Z1,SZURRF
F41022,PNURRF
F4104,IVURRF
F4105,COURRF
F4105Z1,SZURRF
F4106,BPURRF
F4106NC,SZURRF
F4118,CNURRF
F41181,CMURRF
F41500,PPURRF
F41506,PMURRF
F41509,PGURRF
F41511,PAURRF
F415311,T3URRF
F41UI001,ITURRF
F4201,SHURRF
F42019,SHURRF
F4201Z1,SYURRF
F4211,SDURRF
F42119,SDURRF
F4211AU,AUURRF
F4211DT,DTURRF
F4211Z1,SZURRF
F4213,ORURRF
F4215T,XTURRF
F42199,SLURRF
F42A011,CAURRF
F42A012,OPURRF
F42CSS,CSURRF
F42UI01,ZHURRF
F42UI12,ZDURRF
F42UI520,S8URRF
F42UI521,S9URRF
F4301,PHURRF
F4301Z,PAURRF
F4301Z1,SYURRF
F43090,PCURRF
F43092Z1,SZURRF
F4311,PDURRF
F4311Z,PWURRF
F4311Z1,SZURRF
F43121,PRURRF
F43121Z1,SZURRF
F4314Z,PNURRF
F43199,OLURRF
F4321,PBURRF
F43213,VPURRF
F4340,RDURRF
F43UI50D,PWURRF
F43UI50H,PAURRF
F45715,ABURRF
F4572,XRURRF
F4572Z1,LPURRF
F4572ZP,PGURRF
F4575,AHURRF
F4576,ACURRF
F4576Z1,Z1URRF
F4600,R1URRF
F4600PU,R1URRF
F46010,IPURRF
F46022,LTURRF
F46027,AVURRF
F46029,LPURRF
F4611,R2URRF
F4611PU,R2URRF
F4611Z1,SZURRF
F4620,CDURRF
F47011,SYURRF
F47012,SZURRF
F47016,SYURRF
F47017,SZURRF
F47021,SYURRF
F47022,SZURRF
F47026,SYURRF
F47027,SZURRF
F47031,SYURRF
F47032,SZURRF
F47036,SYURRF
F47037,SZURRF
F470371,SZURRF
F47041,SYURRF
F47042,SZURRF
F47044,SWURRF
F47046,SYURRF
F47047,SZURRF
F47056,D1URRF
F47056W,D1URRF
F47057,D3URRF
F47057W,D3URRF
F47061,MJURRF
F47062,MYURRF
F47066,MJURRF
F47067,MYURRF
F47071,SYURRF
F47072,SZURRF
F47076,SYURRF
F47077,SZURRF
F47091,SYURRF
F47092,SZURRF
F47096,SYURRF
F47097,SZURRF
F47101,SYURRF
F47102,SZURRF
F47106,SYURRF
F47107,SZURRF
F47111,Z1URRF
F47112,Z2URRF
F47113,Z3URRF
F47114,Z4URRF
F47121,M1URRF
F47122,MJURRF
F47126,M1URRF
F47127,MJURRF
F47131,SYURRF
F47132,SZURRF
F47136,SYURRF
F47137,SZURRF
F47141,SYURRF
F47142,SZURRF
F47146,SYURRF
F47147,SZURRF
F47156,SYURRF
F47157,SZURRF
F4780,AXURRF
F47CTL,Z5URRF
F4801,WAURRF
F4801S,WAURRF
F4801Z1,SYURRF
F48161,KCURRF
F48162,KNURRF
F48164,KBURRF
F48UI001,WAURRF
F49003,LTURRF
F49004,CTURRF
F49005,TGURRF
F490051,XGURRF
F490052,YGURRF
F490053,ZGURRF
F49010,VMURRF
F4902,TVURRF
F49020,VLURRF
F49110,BWURRF
F49130,BWURRF
F49140,BWURRF
F49141,PWURRF
F49191,DSURRF
F49198,OQURRF
F49211Z1,S1URRF
F4930,VMURRF
F49302,VEURRF
F4931,VGURRF
F4935,VHURRF
F4936,CWURRF
F49380,SUURRF
F4941,RSURRF
F4942,ISURRF
F4942Z1,SYURRF
F4943,SPURRF
F4944,OEURRF
F4945,SCURRF
F4947,STURRF
F49490,TQURRF
F4950,RTURRF
F49501,RDURRF
F4951,ZNURRF
F4952,REURRF
F4956,IXURRF
F4957,BCURRF
F49591,DBURRF
F49592,DHURRF
F49594,DIURRF
F49595,DKURRF
F4960,TMURRF
F4961,LLURRF
F49611,LDURRF
F49612,TDURRF
F49614,TSURRF
F4962,TEURRF
F49621,TDURRF
F4963,TIURRF
F49631,TOURRF
F49632,LBURRF
F49695,DRURRF
F49696,DJURRF
F49697,DNURRF
F4971,RDURRF
F49711,RVURRF
F4972,RXURRF
F49721,QSURRF
F4977,MRURRF
F4978,CGURRF
F4981,FHURRF
F744102,IBURRF
F74900,RPURRF
F74U0141,ACUKURRF
F760101A,V0URRF
F760411A,B2URRF
F760414A,V1URRF
F764008A,TQURRF
F76A08,CFURRF
F76A09,TTURRF
F76A30,V8URRF
F76A31,V9URRF
F76A33,X4URRF
F76A48,PIURRF
F76A49,PIURRF
F76A60,BYURRF
F76A60Z1,TFURRF
F76A8001,V2URRF
F76A8002,V3URRF
F76A8011,PAURRF
F76A8017,TFURRF
F76A8050,PPURRF
F76A8051,PEURRF
F76A8090,VPURRF
F76AUI04,WCURRF
F76AUI21,DLURRF
F76AUI44,WFURRF
F76AUI46,WFURRF
F80100,KPURRF
F8011,KSURRF
F80111,SDURRF
F80200,AAURRF
F98405,STURRF
F984052,SHURRF
F9843,JSURRF
--

Regards,

Dmitry Ilchenko
 

DHelsle

Active Member
RE: User Reference field URRF

Bite the bullet and build the cross reference. It may run over a weekend but
it's worth the time.


David D. Helsley, Inc.
Independent IT Consultant
(859)466-6746 ddh@consultant.com

The views expressed herein are not my own. They are forced upon me by my
employer.

>
 

DHelsle

Active Member
If you're just looking for references in tables look in the F98711 table. It
defines each column in a OneWorld table. You can use UTB to look at it.

David D. Helsley, Inc.
Independent IT Consultant
(859)466-6746 ddh@consultant.com

The views expressed herein are not my own. They are forced upon me by my
employer.

>
 

Jack_Crouch

Well Known Member
RE: User Reference field URRF

I know, I know. I need to lay off my old Green Screen days... But... I
did a DSPFFD to a file for all of my OW libraries. Works great for a very
quick look at what files a field is in.

Doesn't do you any good on the forms and such.



AS400 V4R4, B733.2, SP11.3, NT-SQL7 for CO
 
Top