dbexport fails due to '/' in table name

I am currently running Informix Dynamic Server Version 7.31.FD2X9 on a Sun/Sparc/Solaris 2.8 platform. I am trying to export a 'SAP' database to a local directory. I have used the command 'dbexport <database> -X -c -ss -o /export' successfully many times in the past. Recently some SAP objects have been added to the database, including tables that start with the character '/'. This causes the dbexport to halt when trying to write to an unload file such as: '{ unload file name = /ssf/00100.unl number of rows = 0 }'. I have tried setting different combinations at both startup and runtime the environment varaible 'DELIMIDENT' but I still get the failure. Does anyone have a clue as to how to get the dbexport utility to work with table names such as these? Thanks,

Bug (Feature Request) 153265 applies - DBIMPORT CANNOT IMPORT SOME DATABASES SUCCESSFULLY EXPORTED WITH DBEXPORT. DBEXPORT CANNOT EXPORT SOME DATABASES AT ALL. There are other related bugs, but that's the one I'd recommend using. -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" |---------+----------------------------> | | "RICHARD MOL...."| | | <moldovan@mmsi.co| | | m> | | | Sent by: | | | forum.subscriber@| | | iiug.org | | | | | | | | | 06/24/2003 04:08 | | | PM | | | | |---------+----------------------------> >------------------------------------------------------------------------------- --------------------------------------------------------------| | | | To: ids@iiug.org | | cc: | | Subject: dbexport fails due to '/' in table name [1417] | | | >------------------------------------------------------------------------------- --------------------------------------------------------------| I am currently running Informix Dynamic Server Version 7.31.FD2X9 on a Sun/Sparc/Solaris 2.8 platform. I am trying to export a 'SAP' database to a local directory. I have used the command 'dbexport <database> -X -c -ss -o /export' successfully many times in the past. Recently some SAP objects have been added to the database, including tables that start with the character '/'. This causes the dbexport to halt when trying to write to an unload file such as: '{ unload file name = /ssf/00100.unl number of rows = 0 }'. I have tried setting different combinations at both startup and runtime the environment varaible 'DELIMIDENT' but I still get the failure. Does anyone have a clue as to how to get the dbexport utility to work with table names such as these? Thanks,

Jonathan Leffler answered ..... > > > Bug (Feature Request) 153265 applies - DBIMPORT CANNOT IMPORT SOME > DATABASES SUCCESSFULLY EXPORTED WITH DBEXPORT. DBEXPORT > CANNOT EXPORT SOME > DATABASES AT ALL. > There are other related bugs, but that's the one I'd recommend using. > > -- > I think Jonathon is being polite here. Q what moron would create a table name with a slash in it. A The same sort who create file names with spaces. Please tell me Informix is not stupid enough to accept this .. Colin Bull c.bull@videonetworks.com > > I am currently running Informix Dynamic Server Version 7.31.FD2X9 on a > Sun/Sparc/Solaris 2.8 platform. I am trying to export a > 'SAP' database to > a local directory. I have used the command 'dbexport > <database> -X -c -ss > -o /export' successfully many times in the past. Recently > some SAP objects > have been added to the database, including tables that start with the > character '/'. > This causes the dbexport to halt when trying to write to an > unload file > such as: '{ unload file name = /ssf/00100.unl number of rows > = 0 }'. I > have tried setting different combinations at both startup and > runtime the > environment varaible 'DELIMIDENT' but I still get the failure. > > Does anyone have a clue as to how to get the dbexport utility > to work with > table names such as these? > > Thanks, > > > > > >

Hi, > Q what moron would create a table name with a slash in it. Read the origin-mail from Richard. Read the magic 3-letter-word. (Hint, hint: Such A Pain). Further questions? Walter

Colin, I understand your point. Normally a logical person would not create things that Informix does not understand. However some of us are at the mercy of application providers such as SAP. In this case the person (I don't have the original mail) is trying to export an SAP database. My question/comments to the person who originally submitted this .... 1) sending mail to sapmix instead of /in addition to ids might get you a better answer. sapmix is supported by the IIUG. 2) check OSS notes or open an OSS ticket. I suspect, like HPloader, dbexport might not be supported by SAP. Our DB is too big to even try it. Norma Jean -----Original Message----- From: c.bull@videonetworks.com [mailto:c.bull@videonetworks.com] Sent: Wednesday, June 25, 2003 6:42 AM To: ids@iiug.org; forum.subscriber@iiug.org Subject: RE: dbexport fails due to '/' in table name [1419] Jonathan Leffler answered ..... > > Bug (Feature Request) 153265 applies - DBIMPORT CANNOT IMPORT SOME > DATABASES SUCCESSFULLY EXPORTED WITH DBEXPORT. DBEXPORT > CANNOT EXPORT SOME > DATABASES AT ALL. > There are other related bugs, but that's the one I'd recommend using. > -- I think Jonathon is being polite here. Q what moron would create a table name with a slash in it. A The same sort who create file names with spaces. Please tell me Informix is not stupid enough to accept this .. Colin Bull c.bull@videonetworks.com > > I am currently running Informix Dynamic Server Version 7.31.FD2X9 on a > Sun/Sparc/Solaris 2.8 platform. I am trying to export a > 'SAP' database to > a local directory. I have used the command 'dbexport > <database> -X -c -ss > -o /export' successfully many times in the past. Recently > some SAP objects > have been added to the database, including tables that start with the > character '/'. > This causes the dbexport to halt when trying to write to an > unload file > such as: '{ unload file name = /ssf/00100.unl number of rows > = 0 }'. I > have tried setting different combinations at both startup and > runtime the > environment varaible 'DELIMIDENT' but I still get the failure. > > Does anyone have a clue as to how to get the dbexport utility > to work with > table names such as these? > Thanks, --openmail-part-3ebaa1c0-00000002 Content-Type: application/rtf Content-Disposition: attachment; filename="BDY.RTF" ;Creation-Date="Wed, 25 Jun 2003 08:27:38 -0500" Content-Transfer-Encoding: base64 {\\rtf1\\ansi\\ansicpg1252\\fromtext \\deff0{\\fonttbl {\\f0\\fswiss Arial;} {\\f1\\fmodern Courier New;} {\\f2\\fnil\\fcharset2 Symbol;} {\\f3\\fmodern\\fcharset0 Courier New;}} {\\colortbl\\red0\\green0\\blue0;\\red0\\green0\\blue255;} \\uc1\\pard\\plain\\deftab360 \\f0\\fs20 Colin,\\par \\par I understand your point. Normally a logical person would not create things that Informix does not understand.\\par However some of us are at the mercy of application providers such as SAP.\\par In this case the person (I don't have the original mail) is trying to export an SAP database.\\par \\par My question/comments to the person who originally submitted this ....\\par 1) sending mail to sapmix instead of /in addition to ids might get you a better answer. sapmix is supported by the IIUG.\\par 2) check OSS notes or open an OSS ticket. I suspect, like HPloader, dbexport might not be supported by SAP. Our DB is too big to even try it.\\par \\par Norma Jean\\par \\par \\par -----Original Message-----\\par From: c.bull@videonetworks.com [mailto:c.bull@videonetworks.com]\\par Sent: Wednesday, June 25, 2003 6:42 AM\\par To: ids@iiug.org; forum.subscriber@iiug.org\\par Subject: RE: dbexport fails due to '/' in table name [1419]\\par \\par \\par Jonathan Leffler answered .....\\par > \\par > Bug (Feature Request) 153265 applies - DBIMPORT CANNOT IMPORT SOME\\par > DATABASES SUCCESSFULLY EXPORTED WITH DBEXPORT. DBEXPORT \\par > CANNOT EXPORT SOME\\par > DATABASES AT ALL.\\par > There are other related bugs, but that's the one I'd recommend using.\\par > --\\par I think Jonathon is being polite here.\\par Q what moron would create a table name with a slash in it. \\par A The same sort who create file names with spaces. \\par Please tell me Informix is not stupid enough to accept this ..\\par Colin Bull\\par c.bull@videonetworks.com\\par > \\par > I am currently running Informix Dynamic Server Version 7.31.FD2X9 on a\\par > Sun/Sparc/Solaris 2.8 platform. I am trying to export a \\par > 'SAP' database to\\par > a local directory. I have used the command 'dbexport \\par > <database> -X -c -ss\\par > -o /export' successfully many times in the past. Recently \\par > some SAP objects\\par > have been added to the database, including tables that start with the\\par > character '/'.\\par > This causes the dbexport to halt when trying to write to an \\par > unload file\\par > such as: '\\{ unload file name = /ssf/00100.unl number of rows \\par > = 0 \\}'. I\\par > have tried setting different combinations at both startup and \\par > runtime the\\par > environment varaible 'DELIMIDENT' but I still get the failure.\\par > \\par > Does anyone have a clue as to how to get the dbexport utility \\par > to work with\\par > table names such as these?\\par > Thanks,\\par } --openmail-part-3ebaa1c0-00000002--