I have a table like this: Table A DateTimeIDRef 11021791703A001A1100056 11021791703A001A1100057 11021791703A001A1100058
I am accessing DB2 information on an IBM i (AS400) with PHP. With this code: $query = \"SELECT * FROM QS36F.MYTABLE WHERE MYFIELD=120006\";
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.
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
Does anyone know how one can automatically reply to messages with status MSGW that block a job on an IBM i-series (AS/400)?
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
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):
This question partially related to this one Why my transaction is not rolled back when using the following 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 ?
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.