Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DB2 z/OS support - lack of OLD TABLE and NEW TABLE support #175

Open
memmertoIBM opened this issue Dec 1, 2020 · 2 comments
Open

DB2 z/OS support - lack of OLD TABLE and NEW TABLE support #175

memmertoIBM opened this issue Dec 1, 2020 · 2 comments
Assignees
Labels
database Database specific workload

Comments

@memmertoIBM
Copy link
Contributor

The TPC-C implementation makes use of OLD TABLE and NEW TABLE support.
DB2 z/OS only supports FINAL TABLE (which is the same as NEW TABLE) and does not support OLD TABLE at all.

Investigate how to rewrite queries given the lack of OLD TABLE support.
Change NEW TABLE to FINAL TABLE, which is equivalent in the absence of triggers or RI constraints.

@danluksetich
Copy link

Db2 for z/OS does indeed support OLD TABLE in a data-change-table-reference. It is NEW TABLE that is not supported.

@sm-shaw
Copy link
Contributor

sm-shaw commented Nov 15, 2023

@memmertoIBM this issue is currently self-assigned to you.
As discussed at TPC-OSS meeting on 14th Nov we have decided to close existing stale issues.
If this issue is not likely to receive a PR please close as stale.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
database Database specific workload
Projects
None yet
Development

No branches or pull requests

3 participants