Problem using SQL 'except' command in Matlab Datbase Toolbox

Here is the Follwing code I use after i sucessfully connect to a database:

if true
  % codes
end
sqlquery=['select *'...                 %line 17
' FROM test.dbo.chem '...
' where substring(type,1,1) in  ''B'''...
' and substring(num,1,6) in( ''800'', ''801'', ''802'',''803'')'
'except'...
'select *'...
'FROM test.dbo.chem'...
'where substring(type,1,1) in  ''B'''...
'and substring(num,1,6) in  ''800'''...
' order by heatno desc' ];...
curs = exec(conn,sqlquery)'...
curs = fetch(curs)'...
close(curs)

WHEN I RUN THE CODE INBETWEEN THE PARENTHESES BY ITSELF I CAN SUCESSFULLY QUERY THE DATABSE IN A SCRIPT FILE.

HOWEVER WHEN I RUN THE QUERY WITH THE SECTION OF CODE INBETWEEN THE @ SYMBOLS IN CONJUNCTION WITH EVERYTHIGN ELSE (USING AN EXCEPT COMMAND) I GET THE FOLLOWING ERROR:

Error using Collect_tischem_QUAL (line 17) Error using vertcat Dimensions of matrices being concatenated are not consistent.

when done in microsoft sql server management studio the sql part of the code works

when querying just the specific numbers in matlab the code works (using database toolbox)

when querying the specific numbers in matlab with the except command it does not work

any suggestions?

-Pat

Answer 1

[Piyush Kumar]

Hi,

The error message suggests that there is a problem with the dimensions of the matrices being concatenated. This can happen if the two queries in the EXCEPT statement return different numbers of columns or if there are differences in the data types of the columns.

Try the following troubleshooting steps -

1. Check Column Consistency: Ensure that both parts of the EXCEPT query return the same number of columns with the same data types.
2. Simplify the Query: Test each part of the query separately in MATLAB to ensure they return the expected results.
3. Combine the Queries: If both parts work separately, combine them and ensure the EXCEPT statement is correctly formatted.