Page 1 of 1

countrow for PATSTAT Global

Posted: Mon Dec 09, 2019 11:36 am
by pattystat
Hi, I cannot find data or sql-file to evaluate my PATSTAT Global (autumn 2019) installation. Is there any?

regards, patty

Re: countrow for PATSTAT Global

Posted: Tue Dec 10, 2019 9:27 am
by EPO / PATSTAT Support
Hello Patty,
the easiest check is to do a record count on all of the tables.
In the attached file you will find the SQL query and the results is should show for PATSTAT Autumn 2019 - with the understanding that you loaded all tables and files.
TestScripts.zip
(1.29 KiB) Downloaded 183 times