[TRAFODION-2944] LOB: Allow param specification in stringtolob() and filetolob() functions.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql-exe
• Assignee: Sandhya Sundaresan
• Reporter: Sandhya Sundaresan
• Created: 01/Feb/18 05:58
• Updated: 01/Feb/18 05:58

Description

Today we have to explicitly cast the param for stringtolob. And param spec is not allowed for filetolob().

>>prepare s from insert into tblob values (stringtolob(cast(? as varchar(10)))); 

 --- SQL command prepared.

>> 

 

insert into tlobfile values (1, filetolob(cast(? as varchar(256))));
^ (46 characters from start of SQL statement)

• • • ERROR[8822] The statement was not prepared. 

>>prepare s from update tblob set a = stringtolob(cast(? as varchar(10)), append);

— SQL command prepared.

>> 

 

Fix both to allow syntax like this :

 

 

>>prepare s from insert into tlob values (1, stringtolob);

• • • ERROR[4221] The operand of function LOBINSERT must be CHARACTER.

• • • ERROR[8822] The statement was not prepared.