Re: ontape -r failed: code -1 errno 2

Marco Schwarz wrote: > Thanks the reason ontape 9.3 ist different ontape 9.4! > > But now I have a other problem since the crash some row of a table give > me the error -1213 > > Have someone an idea? > > Server Env: > ... > set CLIENT_LOCALE=DE_DE.1252 > set DB_LOCALE=DE_DE.1252> set SERVER_LOCALE=EN_US.CP1252 > set DBLANG=EN_US.CP1252 > set DBMONEY=,. > set DBDATE=DMY4/> > Client Env: > the same > > How I can see the value in the table without the error -1213? -1213 is a character to numeric conversion error. You don't specify what front-end tool/development tool is getting the error. You are trying to fetch a character column into an integer or floating point host variable and the string is not convertable to a number. Try fetching it into a string/char host variable. Art S. Kagel

Art S. Kagel schrieb: > Marco Schwarz wrote: >> Thanks the reason ontape 9.3 ist different ontape 9.4! >> >> But now I have a other problem since the crash some row of a table give >> me the error -1213 >> >> Have someone an idea? >> >> Server Env: >> ... >> set CLIENT_LOCALE=DE_DE.1252 >> set DB_LOCALE=DE_DE.1252>> set SERVER_LOCALE=EN_US.CP1252 >> set DBLANG=EN_US.CP1252 >> set DBMONEY=,. >> set DBDATE=DMY4/>> >> Client Env: >> the same >> >> How I can see the value in the table without the error -1213? > > -1213 is a character to numeric conversion error. You don't specify > what front-end tool/development tool is getting the error. You are > trying to fetch a character column into an integer or floating point > host variable and the string is not convertable to a number. Try > fetching it into a string/char host variable. > > Art S. Kagel I understand the error message, but the record are right before Informix crashed. How this is possible? Marco

Marco Schwarz wrote: > Art S. Kagel schrieb: <SNIP> >>>How I can see the value in the table without the error -1213? >> >>-1213 is a character to numeric conversion error. You don't specify >>what front-end tool/development tool is getting the error. You are >>trying to fetch a character column into an integer or floating point >>host variable and the string is not convertable to a number. Try >>fetching it into a string/char host variable. >> >>Art S. Kagel > > I understand the error message, but the record are right before Informix > crashed. How this is possible? Well, the server crashed and your restore also did not succeed. My guess is that the data on this particular page is garbage. You did say this was a new problem. You didn't say you were trying to read the data from the database produced by a failed restore. Or am I misinterpreting? Art S. Kagel