Assuming the follo开发者_如何学Cwing query: SELECT ID, COUNT(1) AS NumRecords, SUM(Quantity) AS TotalQty
I have been having a problem with an iSeries Function whereby it is not connverting data properly becuase my default user profile is using CCSID 65535.I can change the job to CCSID 37 and everything w
I need to find and clean up line breaks, carriage returns, tabs and \"SUB\"-characters 开发者_JS百科in a set of 400k+ string records, but this DB2 environment is taking a toll on me.
i\'m using select sql (DB2 on IBM i) to read a record from database and show it into a form where an user can modify and update it!
I\'m building a query against a DB2 database, connecting through the IBM Client Access ODBC driver. I want to pull fields that are less than 6 days old, based on the field \'a.ofbkddt\'... the problem
We would be in near future implementing a solution to modernize our iSeries applications开发者_Python百科
Is there a way for an RPG开发者_JS百科 program to call a web service? I would prefer an ASP.Net web service but would be fine with a winform app or a web page.
wrkmsg - How can I sort messages alphabetically? Is there any possible way to sort those messages in a way that I like to have开发者_如何学C them?I\'m assuming you mean that you want to sort the mess
I have an as400 system that stores all information about our articles, like price, availability, code, description and so on. The availability use to change more often as things get sold, but all this
Subject says i开发者_StackOverflow中文版t all. Looking to capture sql submitted to DB2.Take a look at the Iseries SQL Exit Points which will allow you to log any submitted SQL.The only problem is you