countrow for PATSTAT Global

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

pattystat
Posts: 2
Joined: Mon Dec 09, 2019 11:30 am

countrow for PATSTAT Global

Post by pattystat » Mon Dec 09, 2019 11:36 am

Hi, I cannot find data or sql-file to evaluate my PATSTAT Global (autumn 2019) installation. Is there any?

regards, patty


EPO / PATSTAT Support
Posts: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: countrow for PATSTAT Global

Post by EPO / PATSTAT Support » Tue Dec 10, 2019 9:27 am

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 182 times
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply