Last I checked, truncate table does it all only for the table owner.

Quote:

PowerBuilder 11.0 > DataWindow Reference > DataWindow Expression Functions

Chapter 2: DataWindow Expression Functions
Truncate

Description

Truncates a number to the specified number of decimal places.

My favorite archival delete is something like:This ensures minimal target table impact, and nothing deleted is ever noy archived, even if the unattended script has a problem.

Missing the last go & eof linefeed, second ` misplaced, misspelled table name?

Must be a code frag, fi but not if.

You are removing partial days (three days to the runtime microsecond) if your date column is a datetime type:

Quote:

Adaptive Server Enterprise 12.5 > Reference Manual > Transact-SQL Functions

Chapter 2: Transact-SQL Functions
getdate

Description

Returns the current system date and time.

Maybe you want distinct, but I always say, if you think distinct, reconsider as count(*) group by.

I am not a big fan of <<, as the behavior of echo '...' is more predictable and it flows better reading left to right. I haven't quantified if a tmp file create for << is cheaper than a pipe and fork for echo, just cleaner piped stream layout. I found your second ` in the middle, when in needed to be a line below EOF.

Code:

 
#!/bin/ksh
 
echo ' CLEANUPTABLE
' >cleanup.out
 
results=$(
echo "
delete CLEANUPTABLE
where datetime_col < dateadd ('dd',-3, getdate())
go
select datetime_col, count(*) ct
from CLEANUPTABLE
group by datetime_col
go
' | isql -U${dbuid} -P${dbpwd} -S${dbsrv} -w3000 -E vi
)