Shouldn't the script from Database Explorer result in the same data as Database Explorer direct import?

1 view (last 30 days)
Hello,
I'm experiencing discrepency between pulling data into the Matlab workspace via Database Explorer and the matlab script created from Database Explorer.
In Database Explorer I create a SQL prompt statement that merges three database tables together into a single table. The data preveiw says that it should return 3063059 rows of data that I can successfully import into matlab workspace with no errors or warnings.
I then click the down arrow below "Import" and select "Generate Script". When I run the resulting script I get the following warning:
"Warning: Number of columns in each record are not equal. Potential data error.
> In cursor.fetch at 314
In Pull_Device_Details_For_The_Population at 94"
and I only get around 70 to 700 rows of the data. Also the next time I run it, no warning is received and it only pulls 1 record.
Why is this descrepency happening? Shouldn't the script from Database Explorer result in the same data as Database Explorer direct import?
Thank You

Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!