>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