Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Rows limit with IBM Db2 connexion

Hi, I had a report with an ODBC connexion and everything was OK but we had to change the connexion type to a IBM Db2 connexion When I use this type, I don't have all the rows I should have Do you ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    FinallyI found the error, it was because of a LEFT JOIN

    I don't understand why a left join delete rows of the first table but I could fix it

     

    Thanks for your help

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

I thought about a timeout issue. Do you know if we can change this setting ?

I will send my M code later maybe, I don't have it today

 

Thanks

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
2 years ago

Often you can change it in the original connection to the database in the Advanced Properties. If not, you could talk to your DBA about increasing the timeout on their end. You might also have them run a query trace and see why it is truncating the extract. They will be able  to see exactly what is happening on the server.