TAble Level Restore

IDS 10.0 HP-UX 11.11 I am trying to do a table level restore. The backup I am restoring from is from last night... taken from the same machine I am restoring to. I get this error... ERROR: "PUT CURSOR" failed ERROR: -1263: A field in a datetime or interval value is incorrect or an illegal operation There are several date fields in the table... but shouldn't they insert the same way they were backed up? Any help is appreciated. :) Laurie Laurie Gustin IT Programmer Analyst Department of Public Safety lgustin@utah.gov 801-965-4410

Laurie: I would suggest that you check the schema command file for both the source and target schema. This generally means that interrupting the rows from the source data was not done correctly. Also check to see if these tables have any hidden columns from ER or other features. Hope it helps, John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 02/16/2011 12:04:03 PM: > [image removed] > > TAble Level Restore [22806] > > Laurie Gustin > > to: > > ids > > 02/16/2011 12:05 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > IDS 10.0 > HP-UX 11.11 > > I am trying to do a table level restore. The backup I am restoring from is > from last night... taken from the same machine I am restoring to. I get this > error... > > ERROR: "PUT CURSOR" failed > ERROR: -1263: A field in a datetime or interval value is incorrect or an > illegal operation > > There are several date fields in the table... but shouldn't they insert the > same way they were backed up? > > Any help is appreciated. > > :) > > Laurie > > Laurie Gustin > IT Programmer Analyst > Department of Public Safety > lgustin@utah.gov > 801-965-4410 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Laurie, if your table has cdrcols, you may have to set up your arc command file like this: database stores_demo; create table rocket (cdrserver int, cdrtime int, rocket_id int, rocket_name char(20), rocket_cost money(10,2), launch_date datetime year to second, primary key (rocket_id,rocket_name) ) in dbs1; create table rocket2 ( rocket_id int, rocket_name char(20), rocket_cost money(10,2), launch_date datetime year to second, primary key (rocket_id,rocket_name) ) with crcols; insert into rocket2 select rocket_id, rocket_name, rocket_cost,launch_date from rocket;restore to current with no log; -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie Gustin Sent: Wednesday, February 16, 2011 2:04 PM To: ids@iiug.org Subject: TAble Level Restore [22806] IDS 10.0 HP-UX 11.11 I am trying to do a table level restore. The backup I am restoring from is from last night... taken from the same machine I am restoring to. I get this error... ERROR: "PUT CURSOR" failed ERROR: -1263: A field in a datetime or interval value is incorrect or an illegal operation There are several date fields in the table... but shouldn't they insert the same way they were backed up? Any help is appreciated. :) Laurie Laurie Gustin IT Programmer Analyst Department of Public Safety lgustin@utah.gov 801-965-4410 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Joe - Thanks!! that did the trick (dang hidden columns!!) :) Laurie >>> "Plugge, Joe R." <JRPlugge@west.com> 2/16/2011 1:22 PM >>> Laurie, if your table has cdrcols, you may have to set up your arc command file like this: database stores_demo; create table rocket (cdrserver int, cdrtime int, rocket_id int, rocket_name char(20), rocket_cost money(10,2), launch_date datetime year to second, primary key (rocket_id,rocket_name) ) in dbs1; create table rocket2 ( rocket_id int, rocket_name char(20), rocket_cost money(10,2), launch_date datetime year to second, primary key (rocket_id,rocket_name) ) with crcols; insert into rocket2 select rocket_id, rocket_name, rocket_cost,launch_date from rocket;restore to current with no log; -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie Gustin Sent: Wednesday, February 16, 2011 2:04 PM To: ids@iiug.org Subject: TAble Level Restore [22806] IDS 10.0 HP-UX 11.11 I am trying to do a table level restore. The backup I am restoring from is from last night... taken from the same machine I am restoring to. I get this error... ERROR: "PUT CURSOR" failed ERROR: -1263: A field in a datetime or interval value is incorrect or an illegal operation There are several date fields in the table... but shouldn't they insert the same way they were backed up? Any help is appreciated. :) Laurie Laurie Gustin IT Programmer Analyst Department of Public Safety lgustin@utah.gov 801-965-4410 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Laurie, Some versions of Informix have that bug corrected, however, I have gotten into the habit of just always setting the command file up that way to be safe. I know that this applies to the new replcheck column named ifx_replcheck as well. Joe -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie Gustin Sent: Wednesday, February 16, 2011 2:57 PM To: ids@iiug.org Subject: RE: TAble Level Restore [22809] Joe - Thanks!! that did the trick (dang hidden columns!!) :) Laurie >>> "Plugge, Joe R." <JRPlugge@west.com> 2/16/2011 1:22 PM >>> Laurie, if your table has cdrcols, you may have to set up your arc command file like this: database stores_demo; create table rocket (cdrserver int, cdrtime int, rocket_id int, rocket_name char(20), rocket_cost money(10,2), launch_date datetime year to second, primary key (rocket_id,rocket_name) ) in dbs1; create table rocket2 ( rocket_id int, rocket_name char(20), rocket_cost money(10,2), launch_date datetime year to second, primary key (rocket_id,rocket_name) ) with crcols; insert into rocket2 select rocket_id, rocket_name, rocket_cost,launch_date from rocket; restore to current with no log; -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie Gustin Sent: Wednesday, February 16, 2011 2:04 PM To: ids@iiug.org Subject: TAble Level Restore [22806] IDS 10.0 HP-UX 11.11 I am trying to do a table level restore. The backup I am restoring from is from last night... taken from the same machine I am restoring to. I get this error... ERROR: "PUT CURSOR" failed ERROR: -1263: A field in a datetime or interval value is incorrect or an illegal operation There are several date fields in the table... but shouldn't they insert the same way they were backed up? Any help is appreciated. :) Laurie Laurie Gustin IT Programmer Analyst Department of Public Safety lgustin@utah.gov 801-965-4410 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.