QlikView Script: Выгрузить из базы данных все таблицы в QVD
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
ODBC CONNECT TO DB_NAME (XUserId is ****************, XPassword is ****************); tables: sql SELECT table_name FROM information_schema.tables; FOR i=1 to NoOfRows('tables') LET vTableName = Peek('table_name',$(i)-1,'tables'); [$(vTableName)]: SQL SELECT * FROM $(vTableName) WITH (NOLOCK); ; IF NoOfRows('$(vTableName)')>1 then STORE [$(vTableName)] into 'C:\qlikview\qvd\$(vTableName).qvd' (qvd); ENDIF DROP Table [$(vTableName)]; NEXT i DROP Table tables; |