IBM Support

IT29845: SERVER RETURNS CASE AS A LVARCHAR INSTEAD OF CHAR

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • The return value of a CASE/CONCAT field to be returned as
    LVARCHAR rather than CHAR/VARCHAR.
    
    informix@irk:/tmp$ cat c3.sql
    drop table sources;
    create table sources
    (
    	srcgenidfield varchar(100,1) not null,
    	srcdescrtable varchar(100,1) not null,
    	srcdescrfield varchar(100,1) not null
    );
    
    create view va2(descrsql) as
    select
    	CASE WHEN (srcdescrtable = srcdescrtable) THEN
    		"select " || srcdescrfield || " from " || srcdescrtable || "
    where " || srcgenidfield || " = "
    	ELSE
    		""
    	END
    from sources;
    
    select descrsql from va2;
    informix@irk:/tmp$
    
    informix@irk:/tmp$ dbaccess stores7 c3
    Database selected.
    Table dropped.
    Table created.
    View created.
    No rows found.
    Database closed.
    informix@irk:/tmp$ sqliprint pp_21296  | grep Type
    	Stmt Type...........: 1
    	Stmt Type...........: 15
    	Stmt Type...........: 14
    	Stmt Type...........: 40
    	Stmt Type...........: 2
    	Type....................: CHAR; NULLABLE
    	Stmt Type...........: 31
    informix@irk:/tmp$ cat
    
    Against a 12.10.FC13 or 14.10
    
    informix@irk:/tmp$ dbaccess stores7 c3
    Database selected.
    Table dropped.
    Table created.
    View created.
    No rows found.
    Database closed.
    
    informix@irk:/tmp$ sqliprint pp_21457 | grep Type
    	Stmt Type...........: 1
    	Stmt Type...........: 15
    	Stmt Type...........: 14
    	Stmt Type...........: 40
    	Stmt Type...........: 2
    	Type....................: SQLUDTVAR; NULLABLE
    	Extended Type Name Length: 8
    	Extended Type Name: lvarchar
    	Source Type for Distinct Type: 0
    	Type.....: SQLLVARCHAR; NULLABLE
    	Extended Type Name:  "lvarchar" [8]
    	Stmt Type...........: 31
    informix@irk:/tmp$
    
    This can cause problems with clients who don't support/expect a
    lvarchar type
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of IDS 12.10.xC13.                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The return value of a CASE/CONCAT field is returned as       *
    * LVARCHAR rather than CHAR/VARCHAR.                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • Fixed in IDS 12.10.xC14.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29845

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-07-26

  • Closed date

    2019-09-20

  • Last modified date

    2019-09-20

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
20 September 2019