Questions regarding error message and citation query
Posted: Tue Jun 16, 2015 6:28 am
Hi
We are currently working on projects, where we are looking for the forward citations.
We got PATSTAT CDs(Autumn version), sample queries, and references.
But, we are not used to the PATSTAT, so we have a problem of using the sample queries on the reference
The problems are that
First:
What does it means of an error message of [SELECT - 0 row(s), 0 secs] [Error Code: 0, SQL State: 0] The statement did not return a result set.
When I execute a simple query that (SELECT appln_id FROM tls201_appln WHERE APPLN_ID =14754), I get an message.
Second : In ‘The sample Queries and tips PATSTA online’ the note says as below
“This query makes use of the pre-computed attribute nb_citations, which is only available in PATSTAT online. With PATSTAT raw data, you would have to combine data from the tables which are tls201_appln, tls211_pat_publn and tls212_citation”, so we combine three tables in varying ways, but we can’t got the same result of nb_citations which is displayed in the PATSTA online.
Please give me a query which is used for making the pre-computed attribute nb_citations.
It would really help me out a lot if anyone is able to help me with some of my problems. Thank you in advance.
We are currently working on projects, where we are looking for the forward citations.
We got PATSTAT CDs(Autumn version), sample queries, and references.
But, we are not used to the PATSTAT, so we have a problem of using the sample queries on the reference
The problems are that
First:
What does it means of an error message of [SELECT - 0 row(s), 0 secs] [Error Code: 0, SQL State: 0] The statement did not return a result set.
When I execute a simple query that (SELECT appln_id FROM tls201_appln WHERE APPLN_ID =14754), I get an message.
Second : In ‘The sample Queries and tips PATSTA online’ the note says as below
“This query makes use of the pre-computed attribute nb_citations, which is only available in PATSTAT online. With PATSTAT raw data, you would have to combine data from the tables which are tls201_appln, tls211_pat_publn and tls212_citation”, so we combine three tables in varying ways, but we can’t got the same result of nb_citations which is displayed in the PATSTA online.
Please give me a query which is used for making the pre-computed attribute nb_citations.
It would really help me out a lot if anyone is able to help me with some of my problems. Thank you in advance.