MATLAB: Can I not use truncate with the Database Toolbox

Why does executing an SQL truncate query generate an error in MATALB R2009b?

Best Answer

Connecting to SQL Server 2005 database and executing a truncate SQL query generates an error.

??? Error using ==> database.exec at 51 
The statement did not return a result set.
Error in ==> test at 4
curs = exec(conn,sql_cmd)

This is a known limitation of the Database Toolbox in MATLAB R2009b and prior. The truncate operation is supported as of R2010a.

Related Solutions

MATLAB: Truncating fractions

Ar = round(A*100)/100
.

EDIT

Raviteja, the above command does store your values as you want. The problem is not with the values, but with how the values are displayed in MATLAB. You cannot make MATLAB display the values in just any way you want. The closest you can get is:

format bank
Ar = round(A*100)/100
Ab = abs(A)  %This looks like what you want, but the full value is there.

MATLAB: Truncated cone plot

It is not perfectly clear to me what you want, but here is a parameterization that sounds close to what I think you mean:

t = 30:0.1:100;
az = 0.1;
z = az*t;
r0 = 10000;
ar = -1;
r = r0 + r0*t;
at = 0.05;
theta = at*t;
x = r .* cos(t);
y = r .* sin(t);
figure
plot3(x,y,z,'.-')

Best Answer

Related Solutions

MATLAB: Truncating fractions

MATLAB: Truncated cone plot

Related Question