21 SAVE IFS & DLO

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.

NormS316920 pointsBadges:

Error Messages on AS/400

Dear All, Friends i want to know how to show all error messeges using AS400. For example criticle messages, other messages. Regards, Tahir

tahirliaqat1150 pointsBadges:

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?

Minidach15 pointsBadges:

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

excellentrandy1,330 pointsBadges:

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...

Progrmmer45 pointsBadges:

Turnover form IN-USE Status

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?

yaazhisai260 pointsBadges:

Connect Excel to Rumba 8.2.0

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.

hoomansd5 pointsBadges:

AS400 – Queries

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...

iiiiiiiiiiiii335 pointsBadges:

Uninstall MIMIX from iSeries

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.

maroche15 pointsBadges:

CPYFRMIMPF Error Code 2

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...

bp01442105 pointsBadges:

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...

cooldht50 pointsBadges:

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

Msharbudeen50 pointsBadges:

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 &...

Kirubaharan8915 pointsBadges:

OS/400 Logical file and object

In OS/400, does a logical file has an object?

rajat01195 pointsBadges:

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?

HansVerloop5 pointsBadges:

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.

Sonis1212175 pointsBadges:

Mimix VSP application group

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?

dazkeyte55 pointsBadges:

Extracting data in AS/400

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...

UARTJ235 pointsBadges:

AS/400 error: AP00-207

What is AP00-207 on AS/400? How can I resolve it?

aroberts15 pointsBadges:

Error with SQL

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,...

lrgronewold25 pointsBadges: