Thanks Jeff -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jeff Schasny Sent: Friday, August 27, 2010 6:51 PM To: U2 Users List Subject: Re: [U2] ODBC @ID Alias
Your basic VOC file pointer Unix world: 001:F 002:/someplace/other/than/here/FILENAME 003:D_FILENAME or Windows: 001:F 002:C:\someplace\else\FILENAME 003:D_FILENAME I like the separate directory thing because then all of your ODBCized stuff is in the same place and you are not cluttering up your production dictionaries. I'm pretty sure I have an "A" type to "D" type conversion program which which cleans up ODBC unfriendly stuff and writes to a second dictionary, somewhere. I'll look for it Monday and send you a copy. Bill Brutzman wrote: > Jeff: > > I like this separate idea. > > What would an example pointer thing look like? > > --Bill > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Jeff > Schasny > Sent: Friday, August 27, 2010 6:04 PM > To: U2 Users List > Subject: Re: [U2] ODBC @ID Alias > > I'll second the recommendation for ODBC only dictionaries. I would even > suggest you create a separate account with pointers to the data and keep all > your ODBC dictionaries there. > > Wols Lists wrote: > >> On 27/08/10 21:55, Bill Brutzman wrote: >> >> >>> 1. Thanks Wol... That worked. >>> >>> 2. Now a new related problem. The data dictionaries have tons of items >>> with dots... like... HK.PART.NBR. The ColdFusion source code seems to want >>> to use the dots for object notation. Do I have to go into field <8> of all >>> of the dictionary items and replace the dot there with say an underscore? >>> >>> >> What sort of dict items have you got? To me field 8 is sql data type >> (PI-style D or I). But standard advice when using ODBC is to create >> separate dictionaries specifically for ODBC, where you can use IDs >> without dots. The other thing you can do (which is also a big pain, >> but should be easy to automate...) is >> >> ED DICT FILE HK.PART.NBR >> FILE HK_PART_NBR >> >> boring, but if the dots break ColdFusion, necessary. ime UV can cope, >> but as you say, other stuff isn't expecting it ... it just clutters >> your dictionary :-( >> >> Cheers, >> Wol >> >> >>> --Bill >>> >>> -----Original Message----- >>> From: [email protected] >>> [mailto:[email protected]] On Behalf Of Wols >>> Lists >>> Sent: Friday, August 27, 2010 2:23 PM >>> To: [email protected] >>> Subject: Re: [U2] ODBC @ID Alias >>> >>> On 27/08/10 18:35, Bill Brutzman wrote: >>> >>> >>>> Is there a way to create an ODBC synonym for "@ID" ( like just "ID")... >>>> dropping the "@" character ? Thus, an external an ODBC SELECT statement >>>> would show the column heading as "ID" instead of "@ID". >>>> >>>> The wizard .cfc code generator with the new ColdFusion Builder for ORM >>>> gags on the "@" character. >>>> >>>> Suggestions would be appreciated. >>>> >>>> >>>> >>> ED DICT FILE @ID >>> SAVE ID >>> >>> (then add it to the relevant @list) >>> >>> Cheers, >>> Wol >>> _______________________________________________ >>> U2-Users mailing list >>> [email protected] >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >>> _______________________________________________ >>> U2-Users mailing list >>> [email protected] >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >>> >>> >>> >> _______________________________________________ >> U2-Users mailing list >> [email protected] >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> >> >> > > -- > ---------------------------------------------------------------------- > -- > Jeff Schasny - Denver, Co, USA > jschasny at gmail dot com > ---------------------------------------------------------------------- > -- _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > > -- ------------------------------------------------------------------------ Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ------------------------------------------------------------------------ _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
