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