[U2] Universe ODC field association
I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe ODC field association
I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe ODC field association
You will need to create I-Descriptors that call subroutines to return single values. We have created a separate account that has VOC entries pointing back to the production data, and the dictionaries are just the fields we need for our ODBC application. One of those applications is the UPS WorldShip ODBC connection to our UV data. Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Katz Sent: Tuesday, July 29, 2008 7:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe ODC field association I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe ODC field association
I was able to see (through an ODBC connection) an I-descriptor that displays only the first value of a multi-valued field without using a subroutine call. Here is the DICT entry: I FIELD(SitusStreetNbr,@VM,1):' ':FIELD(SitusStreetName,@VM,1) Situs Address 50L S I could also use a standard I-descriptor to return the COUNT of values in a multi-value field - through an ODBC connection: I DCOUNT(SitusStreetName,@VM) + 0 MD0 SITUS COUNT S I concur with Garry Smith on the creation of a separate account with VOC entries pointing to production data, but maintaining a local DICT that is used solely for ODBC connections (minimize the work by choosing only the fields you need, and rename the DICT entries with names appropriate to the outside world). Garry Smith [EMAIL PROTECTED] 7/29/2008 8:57 AM You will need to create I-Descriptors that call subroutines to return single values. We have created a separate account that has VOC entries pointing back to the production data, and the dictionaries are just the fields we need for our ODBC application. One of those applications is the UPS WorldShip ODBC connection to our UV data. Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Katz Sent: Tuesday, July 29, 2008 7:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe ODC field association I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe ODC field association
I have ODBC connections to our Universe 10.x files with multi-values working fine. I am not certain what you mean by setting up the association between the MV fields and regular fields in the file. The Universe scrubber takes care of providing a connection to the multi-values as a separate file which you can join to the master file. David Katz [EMAIL PROTECTED] 7/29/2008 7:50 AM I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe ODC field association
If you create association fields in the dictionary for any associated multivalued fields they will appear as separate subtables via ODBC. You can also create association fields for individual (ie. not associated with any other) MV fields and they will appear as subtables. Garry Smith wrote: You will need to create I-Descriptors that call subroutines to return single values. We have created a separate account that has VOC entries pointing back to the production data, and the dictionaries are just the fields we need for our ODBC application. One of those applications is the UPS WorldShip ODBC connection to our UV data. Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Katz Sent: Tuesday, July 29, 2008 7:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe ODC field association I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/