Dynamic query

[Anonymous]

Hi Team,

I am trying to write a query which run everyday at morning.

like "Select * from Table_name where date =last_time_batch end_date_time"

here i need the date and time  when it last time ran successfully.

example: batch run time: 10/06/10 4.00 am and it ran till 4.23am. then my batch end date is 10/06/10 4.23am

note : i don't have to store date in DB.

please guide me .

Thanks,

Teja

[manodwhb]

@Tejeswar2020 , you need to maintain a table or a file to read the date which you stored in the previous run.

[Anonymous]

Thanks for your reply @manodwhb .

yes i can manage a file . i know how to take value from a file using tcontext but how can i update again same file with latest date.

Thanks,

Teja

[manodwhb]

@Tejeswar2020 , if you do not select append check box it will always override last file with new file.

[Anonymous]

yeah  @manodwhb i am not appending but once contextload is success then i am trying to update the file but its not updating. in tmap i am modifing dates. i have attached the screenshot. please help me.

input file contains:   date;20200610

Thanks,

Teja

[manodwhb]

@Tejeswar2020 , you were not getting any rows from tfileinputdelimitted_2,with out any rows how will it populate the data to outputfile?