Changing the CCSID value on the client side is not a good practice. In many cases it results in the wrong data being displayed. This article explains why you should change the user's CCSID on the IBM i in the user's profile.
Careless database connection handling in your Visual RPG for .NET code can lead to spurious jobs on your IBM i. Especially for Visual RPG Web ASP.NET Web apps, the presence of these jobs are a symptom of a performance-sucking issue.
ASNA wishes you and your family the very best this holiday season. We greatly appreciate your business and look forward to working with you on your IBM i projects in 2020. Thank you very much for being an ASNA customer!