deal with microsoft access data base file from RPG program or clp
hello, I need to made clp or RPG program to open microsoft access data base file from my PC then read and update special table from this file thanks best regards laila elsharkawy
hello, I need to made clp or RPG program to open microsoft access data base file from my PC then read and update special table from this file thanks best regards laila elsharkawy
0 pts.
Synon/Cool:2E - internal/external func performance question
I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external...
I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external...
List of Values in a SP Parameter
I need to pass a List of Values parameter from a Crystal Report to a Store Procedure. 1) How do I define the Parm? and 2) How do I code the WHERE clause? Example: Result Sets 1 Language SQL Begin ...
View Answer
| Feb 2 2006 2:42 PM GMT
Crystal Reports, Application development, DB2 Universal Database
I need to pass a List of Values parameter from a Crystal Report to a Store Procedure. 1) How do I define the Parm? and 2) How do I code the WHERE clause? Example: Result Sets 1 Language SQL Begin ...
View Answer
| Feb 2 2006 2:42 PM GMTCrystal Reports, Application development, DB2 Universal Database
A copy tool??
Hello to all, I am a COBOL programmer working for a life assurance company which uses a life assurance package developed on the iSeries. I have been tasked with looking into whether it is possible for us to copy a 'contract/policy' from our live environment to a development/test environment. This...
Hello to all, I am a COBOL programmer working for a life assurance company which uses a life assurance package developed on the iSeries. I have been tasked with looking into whether it is possible for us to copy a 'contract/policy' from our live environment to a development/test environment. This...
CPYTOPCD
I can successfully copy data from a PF to a PC doc (via CPYTOPCD) and I can successfully e-mail the resultant PC DOC from the AS400 (via SNDDST) However, when I try to e-mail a large PC Doc (2 meg) I receive about 20 e-mails with *.DTF attachments, which are virtually unreadable. Any ideas?
I can successfully copy data from a PF to a PC doc (via CPYTOPCD) and I can successfully e-mail the resultant PC DOC from the AS400 (via SNDDST) However, when I try to e-mail a large PC Doc (2 meg) I receive about 20 e-mails with *.DTF attachments, which are virtually unreadable. Any ideas?
Modules and Program Dependancies
Is there any command or method to find, the Number of Programs that are created with a Specific Module? Using DSPPGM, we can find the modules used to create the Pgm. But is there any command or method to find out the No of Programs , that a specific module is being attached/bound?
Is there any command or method to find, the Number of Programs that are created with a Specific Module? Using DSPPGM, we can find the modules used to create the Pgm. But is there any command or method to find out the No of Programs , that a specific module is being attached/bound?
OVRDBF in JAVA
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
OVRDBF in Java
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
Positioning a field depending on certain conditions
Jana wrote in with this question recently: "Can I position a field depending on certain conditions? For example: If the condition is true, the field will be on (10,10). If false, the condition will be displayed at (15,10). Is that possible? If yes, please let me know how?" -- Debra Tart,...
Jana wrote in with this question recently: "Can I position a field depending on certain conditions? For example: If the condition is true, the field will be on (10,10). If false, the condition will be displayed at (15,10). Is that possible? If yes, please let me know how?" -- Debra Tart,...
New overlay software needed
Nancy wrote in with this question recently: "We are upgrading from iSeries V4R5 to iSeries V5R3. We need to change our overlay software from Forms eXpress (which is no longer made, which means no support) to something else that will also work with the iSeries format. This should also transfer...
Nancy wrote in with this question recently: "We are upgrading from iSeries V4R5 to iSeries V5R3. We need to change our overlay software from Forms eXpress (which is no longer made, which means no support) to something else that will also work with the iSeries format. This should also transfer...
SQL Select
Does anyone know of a way to use SQL (embedded) to select only the 1st occurence of duplicate key records in a file. I have a file where there may be duplicate keys and I need the 1st occurrence of the key as the data following the key is the data that is needed.
Does anyone know of a way to use SQL (embedded) to select only the 1st occurence of duplicate key records in a file. I have a file where there may be duplicate keys and I need the 1st occurrence of the key as the data following the key is the data that is needed.
iSeries and PHP
I am on a i520 running V5R3, I am thinking of using PHP to build some SQL query built web pages. I use PHP at home on Linux with MySQL so I think I have just enough knowledge to be dangerous. I was reading the RedBooks paper ?Bringing PHP to Your IBM eserver iSeries Server?. It appears to be...
I am on a i520 running V5R3, I am thinking of using PHP to build some SQL query built web pages. I use PHP at home on Linux with MySQL so I think I have just enough knowledge to be dangerous. I was reading the RedBooks paper ?Bringing PHP to Your IBM eserver iSeries Server?. It appears to be...
Variable Positioning of a Field in a display file
Is it possible to set the postion of a field in a display file as per the condition without using two record formats? Like, if a said condition is true, the field will be displayed at (10,10), otherwise it will be at (15,10).
Is it possible to set the postion of a field in a display file as per the condition without using two record formats? Like, if a said condition is true, the field will be displayed at (10,10), otherwise it will be at (15,10).
data encryption/decryption
We are in the process of building encryption/decryption applications. We are using the IBM QC3ENCDT AND QC3DECDT API'S. I've starting testing against our database using apprx 3000 records to encrypt and then decrypt. Out of that 3000 records, there are 17 instances of failure to decrypt to clear...
We are in the process of building encryption/decryption applications. We are using the IBM QC3ENCDT AND QC3DECDT API'S. I've starting testing against our database using apprx 3000 records to encrypt and then decrypt. Out of that 3000 records, there are 17 instances of failure to decrypt to clear...
To retrieve data from a remote system
Hi, I have to retrieve data from a remote system (May be of any operating system) and shall put into AS/400. This process should be automated and there can't be any manual intervention. We can not use FTP commands here. Is there any other way this can be achieved. Can?t go for MQ Series...
Hi, I have to retrieve data from a remote system (May be of any operating system) and shall put into AS/400. This process should be automated and there can't be any manual intervention. We can not use FTP commands here. Is there any other way this can be achieved. Can?t go for MQ Series...
Certain countries do not contain ASCII/EBCDIC characters. Now what?
Alan wrote in with this question recently: "We are taking orders, via the internet, from all over the world. It has come to our attention that orders from certain countries (Turkey for example) do not contain ASCII/EBCDIC characters, so that when the order is fed into our system, they are not...
Alan wrote in with this question recently: "We are taking orders, via the internet, from all over the world. It has come to our attention that orders from certain countries (Turkey for example) do not contain ASCII/EBCDIC characters, so that when the order is fed into our system, they are not...
Retrieve file from customer's server to our AS400 via FTP
We have a customer that is placing a file on their FTP server for daily pickup. This file will have a varying name from day to day as the filename contains the date to make it unique. There is the potential that a day could be missed and we would need to retrieve multiple files during the same...
We have a customer that is placing a file on their FTP server for daily pickup. This file will have a varying name from day to day as the filename contains the date to make it unique. There is the potential that a day could be missed and we would need to retrieve multiple files during the same...
how to get the location of the User Options (updated usinf PF18 from PDM)
How can I access the Defaults information from Rexx / CL ? PF18 from PDM. I am looking for the values of Option file/lib/member. thanks Change Defaults ...
How can I access the Defaults information from Rexx / CL ? PF18 from PDM. I am looking for the values of Option file/lib/member. thanks Change Defaults ...
