Bill, SQL doesn't understand multi-values, so you have to un-nest (normalize) them first. UniSQL contains the NEST and UNNEST keywords, so your SQL sentences have to be executed on the U2 server itself. There are actually commands in U2 that will do most of the work for you (convert files into sql tables for instance). I haven't done this manually for quite a while and haven't got a manual handy but out of the top of my head I think it is something like CONVERT.TABLE. I use SB+ and Avante at work and therefore have processes that do all this for me. There are 4 manuals for different releases of UD and UV about SQL, BCI, VSG and Schema API as well as UniOLEDB you can download from the Rocket website. You should find all the information you need in there. You also may want to install the appropriate U2 ODBC driver on the other end and use that when setting up the DSN in your data sources.
Mecki On 28/08/2010 00:23, Bill Brutzman wrote: > Thanks Jerry... > > I have not tried it yet to see how ODBC, JDBC, SQL handles VM. Advance info > would be appreciated. > > --Bill > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Jerry > Sent: Friday, August 27, 2010 5:54 PM > To: U2 Users List > Subject: Re: [U2] ODBC @ID Alias > > To use the dictionary in any of the SQL environments you should use a clean > dictionary that doesn't have any characters that would break SQL. > This can be done by creating a separate field just used for SQL with no > characters that will break SQL or if you currently don't use the dictionary > much, to change all of your items to conform. That includes using "D" and "I" > types instead of "A" and "S" types. Another way is to have a separate > dictionary and use the "USING" option when using a select or sort. > > Jerry > > On 8/27/2010 3:55 PM, 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? >> >> --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 > _______________________________________________ > 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
