Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am using the following code
ODBC CONNECT TO UCPROD;
V_QV_Table_Size:
Load Run_Date,
Month(Run_Date) AS Month_Name,
DatabaseName as DBname,
Tablename as TblName
Tablesize_Gb;
SQL SELECT
Run_Date,
DatabaseName,
Tablename,
Tablesize_Gb
FROM "D_SYSTEM_LOGS"."V_Table_Size"
WHERE
Run_Date(Date)=Date-1;
store V_QV_Table_Size into V_QV_Table_Size.qvd;
It is given the following error
Can you please help
Arif
Hello Arif,
It seems that you missed a comma after this field:
Tablename as TblName,
Usually those "missing/misplace FROM" errors are because of wrong number of commas as field separators.
Hope that helps.
hi Syed,
I think there is something wrong in WHERE
Run_Date(Date)=Date-1;
As i understand from the script Run_Date is a field name .
Hello Arif,
It seems that you missed a comma after this field:
Tablename as TblName,
Usually those "missing/misplace FROM" errors are because of wrong number of commas as field separators.
Hope that helps.
Hi,
see the below code.i think u missed comma in load statement
V_QV_Table_Size:
Load
Run_Date,
Month(Run_Date) AS Month_Name,
DatabaseName
as DBname,
Tablename
as TblName,
Tablesize_Gb;
SQL
SELECT
Run_Date,
DatabaseName,
Tablename,
Tablesize_Gb
FROM
"D_SYSTEM_LOGS"."V_Table_Size"
Regards,
Chandra