Displaying 1 result from an estimated 1 matches for "sqlparts".
Did you mean:
shl_parts
2011 Dec 12
2
Automated Regressions
...this
as an txt-file. So I can define the SQL-Codes as an object (SQL_Code <-
load.table("...txt, header = FALSE).
In the next step I can build a loop, which tells R to go through the object
SQL_Code line for line, using the text for the SQL Query.
The code is as follows:
SQL Code in the sqlparts.txt. file: "SELECT table.* FROM table WHERE
((table.part) = '2929AAD766')" (2000 lines for all parts, each part has a
distinct code)
SQL_Code <- load.table("sqlparts.txt", header = FALSE)
Loop:
for (c in a(1:2000)) {
Dataset <- sqlQuery(Database, SQL_Code[a,1])...