source $1/get_redshift_creds.sh $2
rsql -h $HOST -U $USER -d $DB << EOF



\echo ' ------------------------------- '

\echo `date`
\echo Start Time - $(date +"%T.%N")

\echo '\n ******************* MAIN EXECUTION LOG STARTS FROM HERE ********************* \n'
\echo 'rsql_blog_script_6.sh job started'


begin ;

/* SET QUERY Group */
SET query_group to 'rsql_blog_querygroup';

\echo '\n ----Inserting data into blog table--------- \n'

INSERT INTO "rsql_blog"."blog_table" VALUES 
(
	4,
    'rsql_blog_script_6.sh',
	CURRENT_TIMESTAMP(0)
);

\if :ERROR <> 0
 \echo 'Insert Statement Failed with Below Details'
 \echo 'Error Code -'
 \echo :ERRORCODE
 \remark :LAST_ERROR_MESSAGE
 \exit 11
\else
 \echo :ACTIVITYCOUNT
 \remark '\n **** Statement Executed Successfully **** \n'
\endif

commit ;

\echo '\n ********** JOB COMPLETED SUCCESSFULLY *********** \n'
\echo '*******************MAIN EXECUTION LOG ENDS IN HERE ********************* \n'
\exit 0


EOF

rsqlexitcode=$?
echo $(date -u)
echo Completion Time - $(date +"%T.%N")

echo "rsql_blog_script_6.sh job exited with error code $rsqlexitcode"
exit $rsqlexitcode