-
I am processing on an i5, 520, V6R1M0. How are the IFS & DLO folders being saved using 21 SAVE? Upgrading to a Power 8 and we want to be sure all information is backed up and properly restored to the new iSeries.
-
Dear All, Friends i want to know how to show all error messeges using AS400. For example criticle messages, other messages. Regards, Tahir
Last updated: -
Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB
I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done this?
Last updated: -
Receiving CPP630C error message when trying to restore tape
We are using 3592-J1A to restore client's back up tape. But when we are trying to restore the tape, we got CPP630C error ID and SRC63A09355 System reference code. What to do now? Thanks
Last updated: -
MKS implementer is not able to compile RPG program
Before compile the RPG program need to create the temp file using CRTDUPOBJ. I created the Object and try to compile the PGM but the spool file showing error. Temp files not found. The program compiled in WRKMBRPDM but the same is not able to compile in MKS Implementer. Please help to sort out the...
Last updated: -
I was trying to promote a form over AS/400 turnover and my session got disconnected meanwhile. Its approved but not run yet. Due to the disconnection, I am not able to run the form now because the form is IN-USE status. What am I supposed to do now?
Last updated: -
My company is using AS/400 Micro Focus Rumba 8.2.0 SP0. Every time we want to run a report we must spool file the query and send it to our email, then we import it into excel. but I wanted to know if we can directly connect Excel to Rumba.
Last updated: -
Hi I have one query Which is a join of table A and Table B. select store,sum(amt) from table A and table B where A.fld1 = B.fld1 A.fld2 = B.fld2 A.fld3 = b.fld3 AND A.fld3 between date range group by Store order by store. I need to run this query in a batch mode,just by changing the date range.how...
Last updated: -
I need to know the specific steps required to remove my MIMIX environments. We have 6 MIMIX pairs, currently remote journaling to another system and are moving into a flash scenario. Eliminating MIMIX entirely. Thank you.
-
Hello, Can someone help me here? I'm trying to import data into a physical file using cpyfrmimpf and I keep getting error code 2 - The field A in the Field Definition File is not a field in the TOFILE. I've created the FDF from the physical file so the fields should be exactly the same. I'm trying...
Last updated: -
Determine if secondary language is installed correctly on iSeries (AS/400)
After much searching, I have determined that the simple answer is no where to be found. I'm trying to determine how to trouble shoot when adding QSYS2924 to the library list doesn't work, what might be the problem. I have a client that has at least attempted to install English as the secondary...
-
Clearing Message Queue in AS400?
Hi All, Is there a way to clear the Messages from Message Queue datewise, consider i have messages for a 30 days and i want to delete the messages for first 20 leaving messages for Last 10 days Kindly let me the is there a possible
Last updated: -
Is there any default performance variations between Scheduled Job & Manually submitted job?
I have a job. The job will be run everyday as a scheduled job. The job is taking just 3 to 7 minutes to complete it's run. If I submit the same job manually, it is taking more than 2 hours. I want to know the reason. Can any one help me on this? Note: Both jobs are having run priority as 50 &...
Last updated: -
OS/400 Logical file and object
In OS/400, does a logical file has an object?
Last updated: -
RPG9032 file &5 contains a record not in sequence
We get the message: RPG9032 file &5 contains a record not in sequence. What do we do?
Last updated: -
How to create PF without member
Is it possible to create physical file without a member? If possible, please let me know method of creating PF.
Last updated: -
When I check the Summary on my Mimix VSP everything is green and looks good except the Application group, this is blue and when I hover over it I get the message, "Resource Group has not been built". If everything appears to be working fine, what hasn't been built?
-
I am reading data lines and the fields are 60 characters long. The first line has 1234567890 the second line has ABCDEFGHIJK and the third has 9876543210. I need to reach line and extract each fields data and put into one field where it would look like this '1234567890 ABCDEFGHIJK 9876543210'. The...
Last updated: -
What is AP00-207 on AS/400? How can I resolve it?
Last updated: -
I am trying to use a SQL statement in an RPGLE program to select a group of records. I have verified that all of the files used in my SQL statement is in the file. I keep getting the errorsSQLCOD=-000000206 SQLSTATE = 42703. Here is my statement:C/EXEC SQL + DECLARE C1 CURSOR FOR C + SELECT WOCSCD,...
Last updated: