MQSeries.net :: View topic - Identifier Cannot be Resolved in Select Stmt in WBIMB5.0

pbravic

We are in the process testing Migrating from WMQI2.1 to WBIMB5.0, After Migration The select statement is giving errors.

We are using
IF EXISTS(SELECT * FROM Database.Company.Test AS T WHERE T.SID = sID THEN (Assignment Statments).

We are getting warning Identifier T Cannot be Resolved.

When we try changing Select * to Select T.* or T gives String expected , expected value *;

Where as in the assignment statements we are not getting any errors
eg of Assignment statement

SET OutputDestinationList.Var.TEMPVAR = THE (SELECT T.* FROM Database.Company.TEST AS T WHERE T.SOURCE = sID)

Pls let us know what part we are missing on.

Thanks and Regards
P.B.Ravichandran