Hi all, i have a scenario where i have to wait for a file for 5 minutes , if not present then raise an exception . the script i am using is if(wait_for_file( '/cdm_nas_QA/cdr/cdm3/QA/' || $GV_FileName,0,300000)=1) but with this the 5 minutes wait i...

Hi all, I am trying to convert the format of sysdate() to 'YYYY-MM-DD HH:MM:SS' in SAP BODS. sysdate() is coming as :- 2023.09.09 06:41:52.000000 and the conversion function i am using is like below It is not giving me any error but the c...

Can some one tell me how can i convert UTC sysdate() to EST in SAP BODS within script and store it to a global variable? i have tried the below approach sql('LEX_HANA_DS','SELECT current_timestamp AT TIME ZONE \'EST\' "utctolocal" FROM DUMMY'); ...