home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT42601 Status: Closed

INSERT WITH A REMOTE SELECT PART USING A DATE/DATETIME SPL VARIABLE
RETURNS -201 FROM THE REMOTE SERVER

product:
INFORMIX SERVER / 5725A3900 / E10 - 
Problem description:
When I use a insert statement with a select from a remote table
and in the
select a local SPL variable is used with a certain datatype, the
insert returns
an error -201.

The SP has the following logic

create procedure mp () returning char (12);
  define v_col3 char (12);
  define v_col4 datetime year to fraction (3);

-- if v_col4  is used with a varchar or a char datatype the
error will not appear
  --define v_col4  char(30);

  let v_col3 = "A00000000001";
  let v_col4 = current;

-- error is produced here
  insert into tab2 (col3, col4) select v_col3, v_col4 from
rem@holgerk_p:tab1;

  return v_col3;
end procedure;
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC16 and 14.10.FC10. *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC16 (if available) or      *
* 14.10.FC10.                                                  *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC16 and 14.10.FC10. *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC16 (if available) or      *
* 14.10.FC10.                                                  *
****************************************************************
Comment
Fixed in Informix Server 12.10.xC16 and 14.10.FC10.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
01.12.2022
22.02.2023
22.02.2023
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)