ibm-midrange
AS400 to Oracle 10g via xml with Informatica Powercenter
Is the following workflow possible with Informatica Powercenter? AS400 -> Xml(in memory) -> Oracle 10g stored procedure (pass xml as param)[详细]
2023-01-13 02:16 分类:问答Finding the actual Job number for a particular JDBC SQL connection to iSeries?
I am using the JTOpen JDBC driver to connect to the iSeries (aka AS/400, IBM System-i, IBMi, WTH?!...).I am having problems with a particular statement and it appears I need to go 开发者_Go百科back to[详细]
2023-01-12 13:02 分类:问答Stored procedure return the primary key after insert?
I want a stored procedure to return the primary key of the new record after it gets executed. I think it will be returned by OUT parameter in the procedure. But how to select the newly inserted row ID[详细]
2023-01-08 07:13 分类:问答Can AS/400 Database Tables Be Hidden?
I was trying to delete a record from a table in AS/400 database. I got an error message saying that there is a referential i开发者_开发百科ntegrity to another table XYZ in the same Schema ABC.[详细]
2023-01-07 21:31 分类:问答What's wrong with this stored procedure?
getting really close to running my first stored procedure. This one compiles but when I run it with call test.fttest5(\'YEAR\'); it throws an error[详细]
2023-01-07 17:13 分类:问答Database: SUBSTRING upto first occurence of character
i have string type abc_01, abcd_01 or开发者_JAVA百科 02 now i want the substring upto _ ie abc_,abcd_ etc. I am using db2 as400 .Please suggest the processing through RIGHT or LEFT functionUse the POS[详细]
2023-01-07 10:33 分类:问答Creating an Entity Data Model from an Empty model
I may be confused here (开发者_运维技巧or over my head). I am trying to connect to an IBM i (aka iSeries) and I want to try to use the Entity Data Model to implement this. The help I have found onlin[详细]
2023-01-04 15:29 分类:问答IBM i (AS400) updates on new Java releases / Java 7
Since Java 7 is comming I was wondering how much time it would take to have the IBM JVM running Java 7 on IBM i systems? (AS400)[详细]
2023-01-03 18:46 分类:问答Changing iSeries Device and PC console password
I am setting up fir开发者_高级运维st console session on iSeries. How do reset console password on PC and iSeries without access to a console?You can use the control panel to reset the password witho[详细]
2023-01-02 12:24 分类:问答SSL Configuration on System i
I have written a delphi application that allows a user to define a query and run it over a DB2 database on an IBM System i using a TADOQuery component with the IBM DB2 OLE DB Provider.[详细]
2023-01-01 22:23 分类:问答