Archives of the TeradataForum

Message Posted: Wed, 26 Mar 2003 @ 21:26:48 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Has any one used COBOL copy libraries with Teradata SQL cursor?

I am using Host variables for collecting input from the Teradata SQL cursor and also as the output variables for these input variables. These host variables are in copy libraries, one for input var. and another for output variables.

copy library for the output works fine but one with input set of variables does not.If i copy the input variables into the cobol program it works!!, but does not workif it is in a seperate file and called in the program with "COPY ". It does not give any syntax error but just doesnot retrieve any rows from the cursor.

Please let me know if this feaure is not supported with TSQL cursor and if there are any other ways of doing it.

Thanks

VG.

	<Prev	Next>		<<First	<Prev	Next>	Last>>