Shouldn't the script from Database Explorer result in the same data as Database Explorer direct import?
1 view (last 30 days)
Show older comments
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
0 Comments
Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!