Error -1261

Hi, I'm a bit lost with this one but I'm new to Informix so hopefully this isn't something that comes up all the time. I'm getting: ODBC Data Source Error: S1000 -- Message: [Informix][Odbc Informix Driver][Informix]Unspecified System Error = -1261. in debug for an application but when I look at the "finderr" for this code it seems to be saying that either the date format is wrong or an interval format is wrong. I've put in a record at the end of this posting that was producing the error and there are no intervals and all the dates seem okay. Can anyone explain what is going wrong here or even some pointers as to where I might find more information on the problem. Thanks Paul user_id PHILBABB batch_no 4 instruction_no 13 instruction_type 1 date_time_created 2000-06-22 09:26:54 created_by PHILBABB date_time_auth 2000-06-22 09:27:14 date_time_accepted 2000-06-22 09:27:14 accepted_by fontissm date_time_proc 2000-06-22 09:27:17 processed_by fontissm date_time_amended 1900-01-01 00:00:00 amended_by instruction_status 3 no_processes 1 no_rt_transmits 0 rt_status 5 date_rt_status 2000-06-22 09:27:14 del_flag Y print_sequence 0 defined_col1 SwiftNumber-0003 defined_col2 SwiftNumber-0002 defined_col3 2000-06-22 defined_col4 IEP defined_col5 60.00 defined_col6 IEP defined_col7 0 defined_col8 0 defined_col9 defined_col10 optimistic_control 3

Can you post a schema of the table as well? 'dbschema -d <database name> -t <table name> <table name>.sql'. My _GUESS_ is that defined_col3 is of type DATE, rather than DATETIME YEAR TO ... If that is true, the proper format for a DATE type is MM/DD/YYYY, not YYYY-MM-DD. By the way, have you looked into the key value CURRENT or TODAY? You can put CURRENT into a datetime field and let the database figure out exactly what's supposed to be there... In article <8427475C51D5D211A0DC00062B000D8F2DA6B3@tampa.credo.ie>, "Durkin, Paul" <pauldu@credo.ie> wrote: > Hi, I'm a bit lost with this one but I'm new to Informix so hopefully > this isn't something that comes up all the time. I'm getting: > > ODBC Data Source Error: S1000 -- Message: [Informix][Odbc Informix > Driver][Informix]Unspecified System Error = -1261. > > in debug for an application but when I look at the "finderr" for this > code it seems to be saying that either the date format is wrong or an > interval format is wrong. I've put in a record at the end of this > posting that was producing the error and there are no intervals and all > the dates seem okay. Can anyone explain what is going wrong here or > even some pointers as to where I might find more information on the > problem. Thanks > > Paul > > user_id PHILBABB > batch_no 4 > instruction_no 13 > instruction_type 1 > date_time_created 2000-06-22 09:26:54 > created_by PHILBABB > date_time_auth 2000-06-22 09:27:14 > date_time_accepted 2000-06-22 09:27:14 > accepted_by fontissm > date_time_proc 2000-06-22 09:27:17 > processed_by fontissm > date_time_amended 1900-01-01 00:00:00 > amended_by > instruction_status 3 > no_processes 1 > no_rt_transmits 0 > rt_status 5 > date_rt_status 2000-06-22 09:27:14 > del_flag Y > print_sequence 0 > defined_col1 SwiftNumber-0003 > defined_col2 SwiftNumber-0002 > defined_col3 2000-06-22 > defined_col4 IEP > defined_col5 60.00 > defined_col6 IEP > defined_col7 0 > defined_col8 0 > defined_col9 > defined_col10 > optimistic_control 3 > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.