Re: Unloading data with embedded backslash characters in CHAR columns
--0__=08BBE429DFF950418f9e8a93df938690918c08BBE429DFF95041 Content-type: multipart/alternative; Boundary="1__=08BBE429DFF950418f9e8a93df938690918c08BBE429DFF95041" --1__=08BBE429DFF950418f9e8a93df938690918c08BBE429DFF95041 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Hi Matt, Why do you want the original backslash not come in the unload file? Is there any special reason for it because you will not be able to load= it back using IBM Informix utilities in default mode. Still in IDS you can write HPL custom functions to do the data manupula= tion while loading/unloading. Also depending on your need, I can suggest you better solutions using H= PL. In HPL you can change the control character to NULL instead of backslas= h etc. Thanks, Pravin. = "Matt" = <nospam@nospam.ne = t> = To Sent by: informix-list@iiug.org = owner-informix-li = cc st@iiug.org = Subj= ect Unloading data with embedded = 06/21/2004 11:11 backslash characters in CHAR = AM columns = = = Please respond to = "Matt" = = = If a CHAR column has an embedded backslash character then an additional= backslash character is inserted immeditaely before the original backsla= sh character in the output produced when using an UNLOAD statement or the = High Performance Loader. Is there any way of preventing this additional backslash character from= being inserted into the output file ?. Thanks = --1__=08BBE429DFF950418f9e8a93df938690918c08BBE429DFF95041 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>Hi Matt,<br> <br> Why do you want the original backslash not come in the unload file?<br>= Is there any special reason for it because you will not be able to load= it back using IBM Informix utilities in default mode.<br> Still in IDS you can write HPL custom functions to do the data manupula= tion while loading/unloading.<br> Also depending on your need, I can suggest you better solutions using H= PL. In HPL you can change the control character to NULL instead of back= slash etc.<br> <br> Thanks,<br> Pravin.<br> <img src=3D"cid:10__=3D08BBE429DFF950418f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "Matt" &l= t;nospam@nospam.net>">"Matt" <nospam@nospam.net><br>= <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE42= 9DFF950418f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">"Matt" <nospam@nospam.net></fon= t></b><font size=3D"2"> </font><br> <font size=3D"2">Sent by: owner-informix-list@iiug.org</font> <p><font size=3D"2">06/21/2004 11:11 AM</font> <table border=3D"1"> <tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"= center"><font size=3D"2">Please respond to<br> "Matt"</font></div></td></tr> </table> </ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE429DFF950418f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE429DFF950418f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">informix-list@iiug.org</font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE429DFF950418f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE429DFF950418f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE429DFF950418f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D08BBE429DFF950418f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">Unloading data with embedded backslash characters in C= HAR columns</font></td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D08BBE429DFF9= 50418f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D08BBE429DFF950418f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <tt>If a CHAR column has an embedded backslash character then an additi= onal<br> backslash character is inserted immeditaely before the original backsla= sh<br> character in the output produced when using an UNLOAD statement or the = High<br>