Re: How to delete last char in string?

> jpowell@cv.hp.com (John Powell) writes: > We need to trim the last character from a variable length parameter > that is passed into an SPL stored procedure. We have tried setting > a variable len as: > let len = length(v_parm_name) - 1; > let v_short_parm_name = v_parm_name[1, len]; > On the second line we get a syntax error on len. I have run into the > same problem with a regular SQL statement such as: > > select col1[1, LENGTH(col2)] from table1; > > Any ideas on how to solve this problem? If you can think of any way to > do, please send your ideas. We could write this in SQL, SPL, 4GL, etc. or > if we had to, call a C program. For some incredible reason you can only have constants in substring selectors in spl so "len" will give you a syntax error. There is also no way of calling a C function in spl (short of a system-call) so that's no option either (very very sad, but true). You can of course do all this in 4GL. Dear Informix, I know it has been asked before, but do you have any plans to extend your SPL language any time soon? We realy need that! Nils.Myklebust@ccmail.telemax.no NM-data, Dalsbergstien 7, N-0170 Oslo, Norway My opinions are those of my company