>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

Thank for replying back Sergey, actually your solution works well, but I am trying to get rid of my temporary table, and I need to dynamically create a cursor as follows:

CREATE CURSOR download_table1 (t1_ipin c(10), t1_ccdn1 c(10), t1_ccdn2 c(10), t1_ds d, t1_ts c(4), ;
					t1_sn c(3), t1_aft c(1), t1_df d, t1_tf c(4), t1_cen c(9), ...

is there way I can assembly my cursor (this is a one time thing) without writing out eaching individual field name and type. The field names are a little bit wierd and there a about 157 of them.

Thanks
Nick