RE: [sqr-users] Why my COMMIT doesn't work??

["Aguirre, Jose" <JAguir@lsuhsc.edu>]

Try getting rid of the empty lines within your code.


José A. Aguirre



-----Original Message-----
From: Manuel_Garcia@hdm.honda.com [mailto:Manuel_Garcia@hdm.honda.com]
Sent: Wednesday, April 30, 2003 4:02 PM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Why my COMMIT doesn't work??


Hello Prasanna, first of all, thanks a lot for your response.

I think no error is happening within my program because it runs well in
another environment, my problem is that I'm not seeing the COMMIT effect

Some part of the program goes as follows:



begin-procedure llenar_tabla_ps_hdm_voucher_tmp

show 'Llenando tabla PS_HDM_VOUCHER_TMP'

BEGIN-SQL

INSERT into ps_hdm_voucher_tmp using
SELECT
A.VOUCHER_ID,
B.INVOICE_ID,
B.VENDOR_ID,
B.INVOICE_DT,
A.ACCOUNTING_DT,
A.FOREIGN_AMOUNT,
A.FOREIGN_CURRENCY,
A.MONETARY_AMOUNT,
B.CLOSE_STATUS,
B.MANUAL_CLOSE_DT
FROM PS_HDM_VCHR_ACCTG A, PS_VOUCHER B
WHERE A.VOUCHER_ID = B.VOUCHER_ID
AND B.VENDOR_ID >= $vndr_fr
AND B.VENDOR_ID <= $vndr_to
;


COMMIT;


END-SQL


show 'Tabla PS_HDM_VOUCHER_TMP Creada.'

end-procedure !llenar_tabla_ps_hdm_voucher_tmp



This procedure is executing well, but after the whole program finishes
(although the process status in PS Process Monitor is never set to Success
in my test environtment), no new data is inserted in my table. I checked
the select statement outside SQR and it works.


Thanks a lot !




Juan Manuel García
Tecnología de Información
Honda de Mexico S.A. de C.V.
Tel: (01 33) 328 40135


























_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users