Hey,
I'm trying to create a simple query to insert new rows to a table, which contain GUID (stored as string) in the first column.
In SQL it look like this:

INSERT INTO TARGET_TABLE (REC_ID, COL1, COL2)
SELECT NEWID(), COL_A, COL_B FROM SOURCE_TABLE

I want try to create an equivalent query to progress data base.
I assume that I need to use the function GUID(GENERATE-UUID) instead of NEWID(). But I did not succeeded.

Any suggestions?

Regards,
Moshe.