Returning SQL results without ansi color coding

[Rune-Christensen]

We are using the Zowe DB2 plugin in our own VS Code extension for making changes to DDL, and in our pipeline that deploys and executes these changes to DDL on DB2.

The result we receive from Zowe DB2 contains ansi encoding. This makes it difficult to parse the result from a SQL, and requires a complex regex, that we would like to avoid maintaining.

We would like an option for Zowe DB2 SQL to return the result in plain text, thus making a parsing of the content easier.

[github-actions[bot]]

Thank you for raising this enhancement request. The community has 90 days to vote on it. If the enhancement receives at least 5 upvotes, it is added to our development backlog. If it receives fewer votes, the issue is closed.

[t1m0thyj]

We could add a flag to our DB2 API methods that if set will use the strip-ansi package to strip our ANSI color/escape codes.

For CLI commands in the DB2 plugin, we could automatically set this flag based on the value of FORCE_COLOR environment variable.

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.

[github-actions[bot]]

This issue has been automatically closed due to lack of activity. In an effort to reduce noise, please do not comment any further.