Trouble Editing Data on iSeries from Web Application
Hello. I'm having a problem editing data in a database file on my AS400. I have an application server set up on the same machine and I've created a data source to access the files in my library. The provider is "DB2 for OS400 V5R1 JDBC Provider", the database name is "*LOCAL" and the library name...
Hello. I'm having a problem editing data in a database file on my AS400. I have an application server set up on the same machine and I've created a data source to access the files in my library. The provider is "DB2 for OS400 V5R1 JDBC Provider", the database name is "*LOCAL" and the library name...
0 pts.
Triggers and commitment control
We are having problems finding a way to get trigger programs included in the needed commitment control boundary. The process starts with a JDBC connection to the 400, and via Java executing processes (SQL) that make changes to the DB files. The files are triggered, and any of the files the...
We are having problems finding a way to get trigger programs included in the needed commitment control boundary. The process starts with a JDBC connection to the 400, and via Java executing processes (SQL) that make changes to the DB files. The files are triggered, and any of the files the...
"map drive" IFS
Hello, We have a ?LAN without any server Windows OS in it? , so everybody is a client (with fixed IP). The only ?server? we have, is our iSeries i5 (V5R3) with iSeries Access(CA) installed (also on the clients). We cannot ?map drive? the IFS f.e. root with \QS6555A8Aroot (or anything else on the...
Hello, We have a ?LAN without any server Windows OS in it? , so everybody is a client (with fixed IP). The only ?server? we have, is our iSeries i5 (V5R3) with iSeries Access(CA) installed (also on the clients). We cannot ?map drive? the IFS f.e. root with \QS6555A8Aroot (or anything else on the...
Error message in window subfile
i have window subfile. Error message is showing behinde the window. It should show within the window. Following is my coding A R SFLMSGW SFL A SFLMSGRCD(15) A MSGKEY ...
i have window subfile. Error message is showing behinde the window. It should show within the window. Following is my coding A R SFLMSGW SFL A SFLMSGRCD(15) A MSGKEY ...
Trigers
Can anyone give me an example of using a trigger when a record is inserted into a file? I am using RPGLE.
Can anyone give me an example of using a trigger when a record is inserted into a file? I am using RPGLE.
Problems with Stored Procedures
Hi, I have written a stored procedure in SQLRPGLE. I used option 15 to create a module, then CREATE PROCEDURE to define it. When I go into SQL to call it, it says External program SVLBR in V64BPCSUSR not found. This is where my module & stored procedure is located. Any ideas on what I missed? ...
Hi, I have written a stored procedure in SQLRPGLE. I used option 15 to create a module, then CREATE PROCEDURE to define it. When I go into SQL to call it, it says External program SVLBR in V64BPCSUSR not found. This is where my module & stored procedure is located. Any ideas on what I missed? ...
Superseded PTFs.
If there are special instructions for a superseded PTF that is not loaded or applied on your system in an ordered PTF cover letter, do you need to order the superseded PTF and follow the instructions for it before loading the PTF that will supersede it? I hope my question makes sense.
If there are special instructions for a superseded PTF that is not loaded or applied on your system in an ordered PTF cover letter, do you need to order the superseded PTF and follow the instructions for it before loading the PTF that will supersede it? I hope my question makes sense.
Microsoft Terminal Services and RPG socket programming
Quick background: We are a software developer of medical billing software and have recently partnered with a document imaging company and have developed an interface between our AS/400 database and their document imaging server using RPG socket programs. Most of our clients are using Client Access...
Quick background: We are a software developer of medical billing software and have recently partnered with a document imaging company and have developed an interface between our AS/400 database and their document imaging server using RPG socket programs. Most of our clients are using Client Access...
Way to speed up first invocation of stored procedure?
Can you help? An iSeries user recently wrote the editors of Search400.com with this question: "One of our stored procedure takes approximately 1 minute for the first invocation when I do a call using RUNSQLSTM. If the same procedure is called repeatedly with different parameters, the results come...
Can you help? An iSeries user recently wrote the editors of Search400.com with this question: "One of our stored procedure takes approximately 1 minute for the first invocation when I do a call using RUNSQLSTM. If the same procedure is called repeatedly with different parameters, the results come...
CHGPF command
I am starting a project where I have to expand a field within a file and also add another field to the end of the same file. My question is this: I've never used the CHGPF command to change the file in the following situation. I've heard that you can use this command to create the new object...
I am starting a project where I have to expand a field within a file and also add another field to the end of the same file. My question is this: I've never used the CHGPF command to change the file in the following situation. I've heard that you can use this command to create the new object...
Use of %Lookup BIF in Free form RPG - V5R3?
Hi, I am having a problem when I try to use the %Lookup BIf in free form RPG. It doesn't seem to be functioning as it is supposed to. Is there something that I am missing (like PTFs) or is there a workaround to this problem if it is a previously known issue? Thanks for your help!!
Hi, I am having a problem when I try to use the %Lookup BIf in free form RPG. It doesn't seem to be functioning as it is supposed to. Is there something that I am missing (like PTFs) or is there a workaround to this problem if it is a previously known issue? Thanks for your help!!
Bad response time for first invocation of stored procedures in DB2400
Platform: V5R3 Problem: A stored procedure takes about 1 to 2 minutes for the first invocation (No difference in this timing for green screen or i-series navigator or Java call through QZDASOINIT jobs). Subsequent invocations are wicked fast with subsecond response times Other info: Procedure...
Platform: V5R3 Problem: A stored procedure takes about 1 to 2 minutes for the first invocation (No difference in this timing for green screen or i-series navigator or Java call through QZDASOINIT jobs). Subsequent invocations are wicked fast with subsecond response times Other info: Procedure...
DB2/400 SQL Sub Query Performance?
Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database. 1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from...
View Answer
| Oct 20 2004 8:40 AM GMT
DB2, UDB for iSeries/i5, Data warehousing/Business intelligence
Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database. 1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from...
View Answer
| Oct 20 2004 8:40 AM GMTDB2, UDB for iSeries/i5, Data warehousing/Business intelligence
XML in UDB Version 8
I am looking for some help in using the UDB XML Extenders. We have a need to store and then recreate some XML. Has anyone used this feature?
I am looking for some help in using the UDB XML Extenders. We have a need to store and then recreate some XML. Has anyone used this feature?
