Desktop productivity for business analysts and programmers

Length statement for computed column

Reply
N/A
Posts: 0

Length statement for computed column

Hi,

How can I define a length for a computed column derived from an excisting variable ??

The computed column: substr(nrrelat,1,9)
the variable nrrelat has a length of 12
the length I need for the computed column should be 9
Super Contributor
Posts: 260

Re: Length statement for computed column

I don't think that you can change the length in the click and point interface. But you can surely do so in the generated code : just look for the SQL procedure, then in the select statement, you have

substr(nrrelat,1,9) AS computedVarName FORMAT=...

Add between the new column name and the FORMAT option the following code :
LENGTH=9
and re-run the code.

That was not really what you were looking for, I think, but I can't think of any non-coding way to do that.
Regards

Olivier
Ask a Question
Discussion stats
  • 1 reply
  • 98 views
  • 0 likes
  • 2 in conversation