World Writer

BDAMBROSIO

Member
I am working in World Writer, and I would like to know if there is a way to bring in information from a UDC. I need to bring in reason code text that are stored in a UDC so that the users know what the actual reason is rather than just listing the code itself from a file.
 

davidbryant

Active Member
I have successfully done this with a udc - it involves using substrings
within a new field created in WW. I'd be happy to send you screen prints
of how I do it if you haven't already gotten an answer. I don't think I
can post screen prints to this list and I don't want to type it out (pretty
cumbersome plus I'm not a very good typist!)

Let me know

David Bryant
Maxco Supply, Inc.




BDAMBROSIO <RDAMBROSIO@MWWINDOWS.COM>@jdelist.com on 10/17/2001 02:58:24 PM
 

setuthill

Active Member
Usually World will automatically link any UDC fields to the UDC file
(F0005).. The description fields will follow the code field in the output
field specifications in world writer. They are designated by XXXX01 where
XXXX = Code Field, e.g., if using the F0101 file, Address Book, Category
code 2 field will be ABAC02, the first description for the field will be
ABAC0201, the second description will be ABAC0202 (if used).. hope this
helps... s.e.t.

Seth E. Tuthill
A7.3 C11 V4R3
 

dale_draper

Well Known Member
Hey David!, that sound like a good thing to upload to the jdelist resources
actually. Then it would be available to all of us, and future users.
And you won't have to respond to 40 "send to me too!" messages. Like, from
say, myself. :)
 

SLANDRUM

Member
When a field in JDE is backed by a UDC table, the description from that
table is included in the field list of the file. The field called
description that immediately follows the code field you want to print is
right there to be selected to print. I usually print both.

Hope this helps.

Sharon Landrum
Avado Brands, Inc.


I am working in World Writer, and I would like to know if there is a
way to bring in information from a UDC. I need to bring in reason code
text that are stored in a UDC so that the users know what the actual
reason is rather than just listing the code itself from a file.


--------------------------
 

davidbryant

Active Member
This is very interesting - I posted earlier offering my cumbersome and
apparently unnecessary method of using substrings to achieve this. I
remember several years ago when I first started trying to print the UDC
value - I know about the implicit joins in WW but can't recall why I would
have gone to all the trouble to use substrings if there was a simple direct
way available. (I have a very good memory for technical issues, it's just
really short.) In fact, I'm pretty sure that JDE gave me the substring
method - is there a set of circumstances when this doesn't work?

Very confusing - however, I think the substring thing also works in
Query/400 as well, when obviously there are no implicit joins to help out.

David Bryant






stuthill <stuthill@writ.com>@jdelist.com on 10/18/2001 06:37:52 AM
 

ssolberg

VIP Member
Re: RE: World Writer

Having seen your many posts, David, I knew you must have missed something along the way to forget the simple implicit joins in WW. (I usually blame my brains ability to purge random data at will) On the other hand... I am well aware of what you are talking about having to use substrings to get things out of the UDC tables. I have had to use this method with queries as well has home grown RPG reports. I always thought it was kinda weird the way they decided to store stuff in F0005 when it comes to the UDC codes. Sometimes they are left justified, sometimes right, sometimes in the "middle". Any way, glad David refreshed his memory banks!

Programmer/Developer/Anything-They-Give-Me
World A7.3 11 (quite stable and usually happy)
Attempting CO with Xe, AS/400, SP14.2 V4R5 (not happy)
 

KENNEY

Well Known Member
David
I believe there are some limitations with the fields brought
in with an implied join, for example I don't beleive you can sort on them .


Michael Kenney
IT Services
University of Windsor



davidbryant
<davidbryant@mx2 To: Kenney@uwindsor.ca
co.com> cc:
Sent by: Subject: RE: World Writer
owner-jdeworld@j
delist.com


10/18/2001 11:53
AM
Please respond
to jdeworld







This is very interesting - I posted earlier offering my cumbersome and
apparently unnecessary method of using substrings to achieve this. I
remember several years ago when I first started trying to print the UDC
value - I know about the implicit joins in WW but can't recall why I would
have gone to all the trouble to use substrings if there was a simple direct
way available. (I have a very good memory for technical issues, it's just
really short.) In fact, I'm pretty sure that JDE gave me the substring
method - is there a set of circumstances when this doesn't work?

Very confusing - however, I think the substring thing also works in
Query/400 as well, when obviously there are no implicit joins to help out.

David Bryant






stuthill <stuthill@writ.com>@jdelist.com on 10/18/2001 06:37:52 AM




--------------------------
 

davidbryant

Active Member
Michael - Thank you. I just looked at a few of the first ww's I built
with the substrings and I was sorting on the alpha contents of the UDC
table. That's why I had to use substrings. I'm pretty sure now I didn't
go brain dead back then. My wife will be happy to know this, although
she's not real certain about now. <g>

David




KENNEY <Kenney@uwindsor.ca>@jdelist.com on 10/18/2001 09:43:09 AM
 
Top