Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
3 votes
Accepted

db2 cross platform function/variable?

It's a very open-ended question, as there is no sure-fire method to determine the server version and platform. You'll need to apply some heuristics. In Db2 for LUW (and only LUW) since v 10.1 there's ...
mustaccio's user avatar
  • 26k
1 vote

How to identify row change timestamp columns in Db2 Table

In Db2 for z/OS this information is in the DEFAULT column of the SYSIBM.SYSCOLUMNS catalog table. In your case the value you'll be looking for is 'E'.
mustaccio's user avatar
  • 26k
1 vote
Accepted

DB2 multiple rows with the same value

CTE part returns stores and dates that have not sold this products '001,002,003', the second part returns only those that have not sold any of them. NOTE: COUNT(*) = 3 because you're looking for 3 ...
McNets's user avatar
  • 23.8k
1 vote
Accepted

DB2: Why does translate function also replace spaces?

The "to-string" in your TRANSLATE is a single "X", so only the first character found in "from-string" (X'00' in your case) will be translated to "X". All other characters found in "from-string" will ...
phunsoft's user avatar
  • 126
1 vote

Possible to have duplicate fully qualified schema names with separate data in DB2 for z/OS?

If the application is hard-coded with the qualifier, then it can only use that qualifier and SCHEMA.table-name is unique. The best approach is rewrite the application to use unqualified table names. ...
Patrick Bossman's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible