[U2] ODBC text field
I am having trouble importing a multivalued field into SQL via odbc. I would like to remove all control characters (including value marks) from the string. I have tried using an I-Type with OCONV but this failed. I would be grateful if anyone could share how they have done this. Thanks Graham --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC text field
If you're using ODBC won't the multivalue be normalised into a separate table? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 27 April 2005 10:24 To: u2-users@listserver.u2ug.org Subject: [U2] ODBC text field I am having trouble importing a multivalued field into SQL via odbc. I would like to remove all control characters (including value marks) from the string. I have tried using an I-Type with OCONV but this failed. I would be grateful if anyone could share how they have done this. Thanks Graham --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC text field
Graham, From memory... have you set it up with M in attribute 6 and an association phrase name in 7. ED DICT MY.FILE MY.MV.FIELD 1 I an mv i-type field ... 6 M 7 MY.MV.PHRASE ED DICT MY.FILE MY.MV.PHRASE 1 PH Asssociated MV set phrase 2 MY.MV.FIELD [MY.ASSOCIATED.MV.FIELD ...] I think the UVODBC driver should just expand out the phrase as a separate table... But maybe you then need to run the HS.UPDATE.FILEINFO command. Stuart -Original Message- I am having trouble importing a multivalued field into SQL via odbc. I would like to remove all control characters (including value marks) from the string. I have tried using an I-Type with OCONV but this failed. I would be grateful if anyone could share how they have done this. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC text field
Graham I'm assuming that you mean to return the multivalued field as a single valued text field. If your are on UniVerse (you don't say) try the following ITYPE expression: CONVERT(@VM:@SVM, , OCONV(@RECORDn,MCP)) Where 'n' is the field number of the field to return. Also make sure field 6 is set to S Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 27 April 2005 10:24 To: u2-users@listserver.u2ug.org Subject: [U2] ODBC text field I am having trouble importing a multivalued field into SQL via odbc. I would like to remove all control characters (including value marks) from the string. I have tried using an I-Type with OCONV but this failed. I would be grateful if anyone could share how they have done this. Thanks Graham --- 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] ODBC text field
Sorry, I am on Unidata and I am trying to return as a single value text field rather than normalise. Thanks Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Wednesday, April 27, 2005 1:08 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC text field Graham I'm assuming that you mean to return the multivalued field as a single valued text field. If your are on UniVerse (you don't say) try the following ITYPE expression: CONVERT(@VM:@SVM, , OCONV(@RECORDn,MCP)) Where 'n' is the field number of the field to return. Also make sure field 6 is set to S Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 27 April 2005 10:24 To: u2-users@listserver.u2ug.org Subject: [U2] ODBC text field I am having trouble importing a multivalued field into SQL via odbc. I would like to remove all control characters (including value marks) from the string. I have tried using an I-Type with OCONV but this failed. I would be grateful if anyone could share how they have done this. Thanks Graham --- 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/