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.