ibm-midrange

相关标签：javascript jquery android 多少钱 iPhone

How to extract the latest rows

I have a table like this: Table A DateTimeIDRef 11021791703A001A1100056 11021791703A001A1100057 11021791703A001A1100058[详细]

2023-02-12 02:43 分类：问答
Why am I getting "Data conversion or data mapping error. SQLCODE=-802" on a simple DB2 select statement?

I am accessing DB2 information on an IBM i (AS400) with PHP. With this code: $query = \"SELECT * FROM QS36F.MYTABLE WHERE MYFIELD=120006\";[详细]

2023-02-11 19:45 分类：问答
(Multiple datasources) Mirror data using hibernate+spring

Using hibernate+spring+AS400 database in a web application: There are 3 datasources (one per region), DS for Australia, DS for UK and DS for USA. Schemas are the same in all the datasources.[详细]

2023-02-11 16:59 分类：问答
Calling i-series program from Java yields invalid output

I\'m using the jtopen/jt400 toolkit to call programs on an IBM i-series r5v4 (aka AS/400) from Java (actually: JRuby, but I\'ve seen the same problem in pure Java). This works just fine for some progr[详细]

2023-02-11 04:42 分类：问答
Monitor and handle MSGW messages on a job on an IBM i-series (AS/400) from Java

Does anyone know how one can automatically reply to messages with status MSGW that block a job on an IBM i-series (AS/400)?[详细]

2023-02-10 16:18 分类：问答
What's the best way to find out the constraints on a IBMi DB2400 table from a java program?

I need a way for my java layer to inspect what constraints exist for all files/tables within a particular library (on an 开发者_如何学GoIBMi/iSeries/System-i/AS400 system).I know that I can query the[详细]

2023-02-09 16:28 分类：问答
Select one row per index value with max column value

With a table setup with the following fields: SKU, EVENTSTARTDATE, EVENTENDDATE, PRICE, (...etc...) and housing thousands of rows here is example data (dates are YYMMDD, century code excluded):[详细]

2023-02-09 13:46 分类：问答
Is rollback can work without savepoints in DB2?

This question partially related to this one Why my transaction is not rolled back when using the following SQL:[详细]

2023-02-09 06:38 分类：问答
Can i create "logical files" in AS400 using sql?

I need to create as400 \"logical files\". my app connects to the db with jdbc. I开发者_运维知识库s it possible to create \"logical files\" with sql statements ?[详细]

2023-02-07 17:51 分类：问答
Calling stored procedure on i Series using IBM DB2 Connect driver

I have a C# application, from where I am trying to call an ISeries Stored Procedure (wrapping an RPGLE program). This RPGLE program returns a result set back to my C# application.[详细]

2023-02-07 14:26 分类：问答