Hi,

When I try to run a sql query (sql server) from fex, the report hangs. The query runs fine in query analyzer. The master files are working fine. I am not sure, what causes this problem?
I tried to run this using WFServlet and directly in server console.

Any thoughts,

Missed off semi colon or END. Fields too big for wf to receive.

Kamesh, can you post the code?

SQL SQLMSS SET SERVER CONNECTIONNAME
SQL SQLMSS

SELECT TOP 10 * FROM TABLENAME;

TABLE FILE SQLOUT
PRINT *
END
-EXIT

Get rid of spaces and -- sql comments. I have had probs with these before when you try and pretty format!

Try

SQL SQLMSS SET SERVER CONNECTIONNAME
SQL SQLMSS
SELECT TOP 10 * FROM TABLENAME;
TABLE FILE SQLOUT
PRINT *
END
-EXIT

Tried that too. No luck.

quote:

SQL SQLMSS SET SERVER CONNECTIONNAME
SQL SQLMSS
SELECT TOP 10 * FROM TABLENAME;
TABLE FILE SQLOUT
PRINT *
END
-EXIT

Did you put ENGINE?

ENGINE SQL SQLMSS SET SERVER CONNECTIONNAME
SQL SQLMSS
SELECT TOP 10 * FROM TABLENAME;
TABLE FILE SQLOUT
PRINT *
END
-EXIT

quote:

SQL SQLMSS SET SERVER CONNECTIONNAME
SQL SQLMSS
SELECT TOP 10 * FROM TABLENAME;

TABLE
ON TABLE HOLD AS MSS_DATA2 FORMAT ALPHA
END
-RUN

Finally my DBA found the issue. The issue was in the database side.

Thanks guys for all your input.