Please Help to Truncate a table!!!

[vm17737]

I need to truncate, not drop, a Sybase table from a UNIX shell script.
Is there a special sytax for embaded SQL?
Thanks in advance!

 

[pmcmicha]

No, this is pretty easy....

#!/usr/bin/ksh -p

PATH_TO_ISQL

${PATH_TO_ISQL}/isql -SSYBASE -U${ADMINNAME} -P${PASSWORD} <<-EOF
truncate table ${DB_NAME}..${TABLE_NAME}
GO
EOF

Whatever else you need to do here.....

 

[mehrnosh]

Hi
U can use the ISQL command at unix prompt
isql -Sservername -Uusername -Ppasword -iinputfile -ooutputfile
in the inputfile u can specify your sql commands
after each command give a go statement

u can trap the output by using the -o switch