FTP session
During an FTP session, prior to issue the GET command to receive files from a remote site to my local server, I need to clear my local directory. Is it possible to delete files from the local server ?? kind of a DEL or MDEL command that would be executed locally instead of the remote side..
During an FTP session, prior to issue the GET command to receive files from a remote site to my local server, I need to clear my local directory. Is it possible to delete files from the local server ?? kind of a DEL or MDEL command that would be executed locally instead of the remote side..
20 pts.
Laser Check printing of MICR codes
We are wanting to generate laser checks. Where can I find the DDS specs required to generate the MICR codes (fonts & special characters) that print at the bottom of the checks? We do not want to purchase any additional software for printing of MICR information.
We are wanting to generate laser checks. Where can I find the DDS specs required to generate the MICR codes (fonts & special characters) that print at the bottom of the checks? We do not want to purchase any additional software for printing of MICR information.
Data migration strategies-2
Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel...
Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel...
Data migration strategies
Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel...
Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel...
Use SysReq to get WRKJOB
I use to create a library - MYQSYS and load it with CRTDUPOBJ OBJ(WRKJOB) FROMLIB(QSYS) OBJTYPE(*CMD) TOLIB(MYQSYS) NEWOBJ(DSPJOB). I was then able to use the cmd CHGSYSLIBL LIB(MYQSYS)To put this library ahead of QSYS and when I used SYSREQ option 3 I got a WRKJOB instead of DSPJOB (and a cmd...
I use to create a library - MYQSYS and load it with CRTDUPOBJ OBJ(WRKJOB) FROMLIB(QSYS) OBJTYPE(*CMD) TOLIB(MYQSYS) NEWOBJ(DSPJOB). I was then able to use the cmd CHGSYSLIBL LIB(MYQSYS)To put this library ahead of QSYS and when I used SYSREQ option 3 I got a WRKJOB instead of DSPJOB (and a cmd...
OS Version
How can I determine what OS Version is installed on my system from a program? The OS version is not in the system values, RTVJOBA, or RTVNETA.
How can I determine what OS Version is installed on my system from a program? The OS version is not in the system values, RTVJOBA, or RTVNETA.
scheduling a job
I have a job that needs to run the 5th of each month. I've looked into JOBSCDE but I haven't see where I could schedule the job thru that. Do you know of an easy way to make that occur??
I have a job that needs to run the 5th of each month. I've looked into JOBSCDE but I haven't see where I could schedule the job thru that. Do you know of an easy way to make that occur??
When doing a chain the (HI) indicator return with '1'. But if I do a query on the same file I can see that the record is in the file.
I have a program in RPGIII. In the production environment the users are getting the following error message: RPG1221: (Issued update or delete in SDFBOBS0 without prior READ or CHAIN). I thought i shall put this program in my test environment and try to do the same as what the users have done in...
I have a program in RPGIII. In the production environment the users are getting the following error message: RPG1221: (Issued update or delete in SDFBOBS0 without prior READ or CHAIN). I thought i shall put this program in my test environment and try to do the same as what the users have done in...
AS400 Development/Testing
Hi, To minimise our laboratory costs, I'm looking at a solution, which will allow me to test our products with an AS400 using the latest OS400 versions, without having to purchase an iSeries. Crazy? Maybe! SAP provide MiniSap (Windows based), which is a basic version of their system, but can be...
Hi, To minimise our laboratory costs, I'm looking at a solution, which will allow me to test our products with an AS400 using the latest OS400 versions, without having to purchase an iSeries. Crazy? Maybe! SAP provide MiniSap (Windows based), which is a basic version of their system, but can be...
Override the file name during batch FTP
We use ftp to send iseries files to our server. We use a script in a member in QTXTSRC. This script contains the library/file name to PUT. We would like change the file name in the CL to contain a date stamp and then use this file name to sent to the server. How can i override the file name on...
We use ftp to send iseries files to our server. We use a script in a member in QTXTSRC. This script contains the library/file name to PUT. We would like change the file name in the CL to contain a date stamp and then use this file name to sent to the server. How can i override the file name on...
CPF5152
Hello, I am experiencing a strange problem that is driving me crazy. First what I am attempting to accomplish is to read a DSPF file looking for specific output records and then write to a source file lines of RPG III code to output to those fields. What is happening is that after the 44th line...
Hello, I am experiencing a strange problem that is driving me crazy. First what I am attempting to accomplish is to read a DSPF file looking for specific output records and then write to a source file lines of RPG III code to output to those fields. What is happening is that after the 44th line...
cpyfrmimpf
We would like to automate a file transfer, and I thought to use the cpyfrmimpf cl command. The problem is that the .CSV file we wish to copy to our DB2 database has a header row that does not match the column data...some data must appear to the transfer as numeric. When I remove the header row,...
We would like to automate a file transfer, and I thought to use the cpyfrmimpf cl command. The problem is that the .CSV file we wish to copy to our DB2 database has a header row that does not match the column data...some data must appear to the transfer as numeric. When I remove the header row,...
Access Oracle/Sybase/Informix from RPG
Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse - my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should:...
Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse - my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should:...
SETLL and READE or CHAIN? Performance Issues
HI, I have a batch RPG programs used to do some updataions and reporting, currently the job takes around 1 sec to process a record. We want to further reduce this time. Changing the run Priorty may make the job run a bit faster, are there any other parameters that can be used? also am...
HI, I have a batch RPG programs used to do some updataions and reporting, currently the job takes around 1 sec to process a record. We want to further reduce this time. Changing the run Priorty may make the job run a bit faster, are there any other parameters that can be used? also am...
How to make a batch job run faster (excpet for the run priorty), Code changes?
HI, I have a batch RPG programs used to do some updataions and reporting, currently the job takes around 1 sec to process a record. We want to further reduce this time. Changing the run Priorty may make the job run a bit faster, are there any other parameters that can be used? also am looking...
HI, I have a batch RPG programs used to do some updataions and reporting, currently the job takes around 1 sec to process a record. We want to further reduce this time. Changing the run Priorty may make the job run a bit faster, are there any other parameters that can be used? also am looking...
Read Screen Data w/o Enter Key Being Pressed
I have both simple (non-subfile) and subfile dds-created screens. Would like the users to be able to press F10=Save to save screen data, without needing to press the Enter key to capture the data first. (Edits automatically run immediately after control returned to pgm.) Is this even possible? ...
I have both simple (non-subfile) and subfile dds-created screens. Would like the users to be able to press F10=Save to save screen data, without needing to press the Enter key to capture the data first. (Edits automatically run immediately after control returned to pgm.) Is this even possible? ...
Stored Procedures on AS/400
Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? ...
Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? ...
Source highlighting using NetManage Rumba
Has anyone developed a keyboard macro, VB Script or WSCST object that will let you enter the hex values necessary to highlight source code in SEU while using Rumba? I found a few examples for CA/400, but not for Rumba. TIA...Chuck
Has anyone developed a keyboard macro, VB Script or WSCST object that will let you enter the hex values necessary to highlight source code in SEU while using Rumba? I found a few examples for CA/400, but not for Rumba. TIA...Chuck
Job Schedule Entries Migration
Hi All, We are migrating from an 820 to a new 550 i5 this weekend. Does anyone know how we can migrate the current Job Schedule Entries on the 820 to the 550? Is there an API to the database that holds the Job Schedule Entry details that we can use to extract the info and then push it into the...
Hi All, We are migrating from an 820 to a new 550 i5 this weekend. Does anyone know how we can migrate the current Job Schedule Entries on the 820 to the 550? Is there an API to the database that holds the Job Schedule Entry details that we can use to extract the info and then push it into the...
Implementing RUP in Retail business which runs on i-Series
A retail company is planning to implement IBM Rational Unified Process for its business which runs on i-Series. Please let me know how well RUP can be implemented here. How well RUP works for i-Series software development? What are the tailoring to be done to this process for i-Series? Also, please...
A retail company is planning to implement IBM Rational Unified Process for its business which runs on i-Series. Please let me know how well RUP can be implemented here. How well RUP works for i-Series software development? What are the tailoring to be done to this process for i-Series? Also, please...
