You can use SELECT statement to do that.

SEELCT * ;
  FROM mytable ;
  WHERE 1=2 ;
  INTO CURSOR crsMycursor READWRITE

>Is there a fast way to create a new cursor by copying the table structure field name and character type. I have a temporary table that has 157 fields, and I now want to use a temporary cursor. However, I have so many fields to define for cursor and was wondering the quickest way to create cursor definition from existing table stucture.
>
>Thanks
>Nick Patel