How to log an sql statement
This is a multipart mime message --Next_1091709735---0-202.54.124.179-30968 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline <P>=0ADear All,<BR>=0A<BR>=0AI am testing on migration from one database to= other. I have a file which contains all the database changes (insert/updat= e/delete) that need to be run. Is there anyway i can log all these st= atements in to a file. When i run this file and if any of these statement f= ails can i come to know where the error occured. Thanks in advance.<BR>=0A<= BR>=0ARegards,<BR>=0A<BR>=0Alloyd=0A</P>=0A=0A=0A<br><br>=0A<A target=3D"_b= lank" HREF=3D"http://clients.rediff.com/signature/track_sig.asp"><IMG SRC= =3D"http://ads.rediff.com/RealMedia/ads/adstream_nx.cgi/www.rediffmail.com/= inbox.htm@Bottom" BORDER=3D0 VSPACE=3D0 HSPACE=3D0></a>=0A --Next_1091709735---0-202.54.124.179-30968 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Dear All,=0A=0AI am testing on migration from one database to other. I have= a file which contains all the database changes (insert/update/delete) that= need to be run. Is there anyway i can log all these statements in to a fi= le. When i run this file and if any of these statement fails can i come to = know where the error occured. Thanks in advance.=0A=0ARegards,=0A=0Alloyd= =0A=0A --Next_1091709735---0-202.54.124.179-30968--
you may use the "errorlog()" funciton in c4gl. But in first using startlog();