Skip to Content
0
Apr 24, 2013 at 12:06 PM

Assign fixed values to a field

32 Views

Hi,

in my example I am using a ´"compute" shape where I have attached an input adapter to take over some fields. However, I also want to add one more field and assign it with a fixed value. But my current approach causes an compile error. What am I doing wrong?

Here my current CCL extract:

/**@SIMPLEQUERY=COMPUTE*/

CREATE LOCAL STREAM StopLog AS SELECT to_string ( "completed" ) EVENT_NAME , InputStream.CASE_ID CASE_ID,InputStream.END_DATE "DATE" FROM InputStream ;

Is it in general possible to assign fixed values to fields e.g. with the built-in function "to_string(string)"? Is is possible to add further fields that are not derived from an input stream, but will be used later on for the output adapter?

Thanks and Best Regards.
Markus