Shaun,
Instead of table name try using datastore name in the beginning.
sql('datastorename','...............');
Thanks,
Arun
thanks for the suggestion, unfortunately I'm still getting this error. Could it be the count(*) not being allowed in the SQL() function?
error message:
VAL-030159 3/26/2012 2:26:59 PM Found erroneous expression <sql('SAP_TST','select count(*) from TABLE where TABLE.STATUS = \'U\'')>. Check its syntax and fix
Count can be used in the SQL, no problem with that. Have you used semi colon (;) after SQL syntax? Whats the desired output?
I'm not using a semi-colon anywhere, the formatting is the same as what i typed above except the table name is different.
What I'm trying to do is execute a while loop until the record count = 0. So I'm trying to include the sql statement in my while loop condition so that I can check the record count of a table.
So something like
while( sql( select count(*) from table)) != 0 )
Perform data flow tasks
Ok. To check the record count of the table the sql syntax should be select count(*) from tablename.
sql ('datastorename','select count(*) from tablename').
Arun
Just FYI.
One more thing. If sql doesn't work, you can use total_rows() function to get the count of rows in the table.
I think you need number of values in the specified column called 'STATUS'. In that case your SQL function should be select count(STATUS) as xyz from tablename where STATUS = \'U\'
Is that what you are looking at?
