I have a cursor generated from an SQL statement named FABLIN with 4 fields namely mainkey, group, element and weight. I need to create a new cursor and copy those records to the new cursor named DRSRISK. Here is my syntax:

CREATE CURSOR crsrisk ;
 (Mainkey c(30), Group C(30), Element C(30), Weight C(10))

select fablin
APPEND FROM fablin FIELDS mainkey, group, element, weight

Is this correct, I cannot get this to work for some reason. Any help would be much appreciated?
Many Thansk