Hi,
I have a cobol Db2 program.I have an input file which contains a record "GOLD".The file is read and this value is passed as input to SQL cursor .The records are fetched and written to a output file.My requirement is that i have another record(second) as "SILVER".So,i need to pass this input into SQL query and generate the output in the same file followed by output of first record.I tried with perform 1000-cursor thru 1000-exit until end-of-input-file and it does not work.I have even tried with cobol tables(internal) .I am not sure of the syntax.Please advise how this requirement can be achieved.