Copy Records from a table having 47 fields into a file

rsm_deepak · Posted: Tue Jul 18, 2006 7:44 pm

Here i just want to copy the records of a table having 47 fields into a new file.
My problem is that when i am declaring a cursor whether i have to declare all the 47 fields in the cursor or there is any other easy method.

anamikak · New User Joined: 10 May 2006 Posts: 64 Location: Singapore

try out unload utility

red_roses · New User Joined: 31 Oct 2005 Posts: 27

anamikak has a good suggestion, if u only want the recs on a file and no processing for it then its a safer way to ues the unload utiliy,

search the forumn for the exact jcl, someone had posted it jsut a few days ago

ravi17s · New User Joined: 15 Aug 2003 Posts: 57

Yes u can use UNLOAD utility.

But if you want to go for a cursor,Just declare it as

EXEC SQL DECLARE C1 CURSOR FOR SELECT * FROM TABLE NAME:

Thanks,
Ravi....

guptae · Posted: Fri Jul 21, 2006 4:46 pm

Yeap Ravi is right but while fetchin the row from the cursor u have to give all 47 variable i.e

fetch cursor1 into :table1.field1,
:table1.field2,
:table1.field3,
....................................................
....................................................
....................................................
....................................................
:table1.field47