ibm-midrange
How can I convert the division of two integer values to a decimal using T-SQL against a iSeries AS/400 Database?
Assuming the follo开发者_如何学Cwing query: SELECT ID, COUNT(1) AS NumRecords, SUM(Quantity) AS TotalQty[详细]
2023-04-11 07:15 分类:问答SQL User Defined Java Function (Character conversion between CCSID 65535 and CCSID 1200 not valid)
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[详细]
2023-04-10 19:24 分类:问答DB2/iSeries SQL clean up CR/LF, tabs etc
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.[详细]
2023-04-09 07:34 分类:问答how to alloc records to avoid an update at the same time with another user
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![详细]
2023-04-08 18:00 分类:问答Date arithmetic in SQL on DB2/ODBC
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[详细]
2023-04-07 00:30 分类:问答RPG (iSeries) Modernization using JTOpen - What is possible?
We would be in near future implementing a solution to modernize our iSeries applications开发者_Python百科[详细]
2023-04-05 05:29 分类:问答Can an RPG program call something external, ie: a webservice?
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.[详细]
2023-04-04 08:43 分类:问答How to sort messages alphabetical
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[详细]
2023-04-02 10:17 分类:问答What is the best way to make an almost e-commerce site with a current system in as400 database?
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[详细]
2023-04-01 17:42 分类:问答Is there an IBM Iseries/DB2 equivalent to SQL Profiler?
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[详细]
2023-04-01 05:33 分类:问答