Currently i have a stored procedure in my company system which work like this:
VBPGM ------> PROC_DATE -----> UPDDTEC ------> UPDDTE
(VB.Net Program) (Stored Procedure) (CL Program) (RPG Program)
A Visual Basic .Net program will call the stored procedure and pass in some parameter. The RPG program will retrieve the system date and write into a PF.
Before this, there is no problem with it. But this few days, it keeps on getting the same date (2007/02/07) instead of the actual date. When i check the system date from the AS/400 system, it shows the correct date. When i call the CL program from AS/400 system, the date retrieved is also correct. Can i know what is the causes please?
For your information, the system have not been power down since 2007/02/07. Previously. the system is power down every day. Is it this will affect the system date retrieved?
Your help is really appreciated. Thank you.
VBPGM ------> PROC_DATE -----> UPDDTEC ------> UPDDTE
(VB.Net Program) (Stored Procedure) (CL Program) (RPG Program)
A Visual Basic .Net program will call the stored procedure and pass in some parameter. The RPG program will retrieve the system date and write into a PF.
Before this, there is no problem with it. But this few days, it keeps on getting the same date (2007/02/07) instead of the actual date. When i check the system date from the AS/400 system, it shows the correct date. When i call the CL program from AS/400 system, the date retrieved is also correct. Can i know what is the causes please?
For your information, the system have not been power down since 2007/02/07. Previously. the system is power down every day. Is it this will affect the system date retrieved?
Your help is really appreciated. Thank you.
Comment