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
Neil Lewis
IT R&D Manager
Velmore Ltd