troubleshooting Question

DB2 SQL syntax

Avatar of Allen Pitts
Allen PittsFlag for United States of America asked on
DB2
6 Comments1 Solution680 ViewsLast Modified:
Good moruing expert,

I have several years with T-SQL (MS SQL Server) and some time with PL/SQL (Oracle).
Today is my first day with DB2. Is there a knowledged domain that is equivalent to DB2
that is the same as T-SQL is equivalent to MS SQL Server? If, so what is called?

This query will work in MS SQL Server
SELECT "CASE".CASE_ID,
       "CASE".CLIENT_CD,
       "CASE".CONTEXT_CD,
       "CASE".STATUS,
       "CASE".PROGRAM,
       "CASE".CASE_NUM
  FROM PIER."CASE"
  where CLIENT_CONTEXT like 'PIERHIPPMA'
 But in DB2 it returns 'DB2 Datasbase Error [42703]'.
What is the problem?

Thanks.

Allen in Dallas
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros