Re: BSFN B000002

NM1234

Active Member
Re: BSFN B000002

Hi Snowpuff,

I think got_to_love_jde's answer was clear.you could use the following code too.As it clears the whole data,I think you may have to use it in the Initialize Section Event.

Get Audit Information
VA rpt_UserId_USER <- szUserName
VA rpt_DateUpdated_UPMJ <- jdDate
VA rpt_TimeLastUpdated_UPMT <- mnTime
VA rpt_WorkStationId_JOBN <- szWorkstation_UserId
Get Input Output Env Handles
SL LoginEnvironment -> szInputEnvironment
VA rpt_InputHandle_F0101 <- idInputEnvHandle
SL LoginEnvironment -> szOutputEnvironment
VA rpt_OutpuHandle_F0101 <- idOutputEnvHandle
SL LoginEnvironment -> szLoginEnvironment
Delete All Rows From Table
"F5648470" -> szTableName
VA rpt_OutpuHandle_F0101 -> idOutputEnvHandle
Free Input Output Env Handles
SL LoginEnvironment -> szInputEnvironment
VA rpt_InputHandle_F0101 -> idInputEnvHandle
SL LoginEnvironment -> szOutputEnvironment
VA rpt_OutpuHandle_F0101 -> idOutputEnvHandle
SL LoginEnvironment -> szLoginEnvironment

Good Luck
Badri
 
Back
Top