GO DISKTASKS on iSeries

I am trying to get disk information on a V6R1M0 iSeries utilizing GO DISKTASKS. When I try to run it using *CURRENT date & time, nothing happens. I set it up to get submitted weekly and nothing happens either. The existing information collected shows from Feb 2016. I have used this command for...

NormS316920 pointsBadges:

Log occasions when QSECOFR logs in

I have been asked to create a log of occasions when QSECOFR signs in - I can't find it in QAUDJRN - nor does it pick it up in the history log under CPF1124.

bingles15 pointsBadges:

Refresh data from one AS/400 to another

We have a production AS400 for our users and a test AS400 for our developers and we would like the data to match. Is there a way to refresh the data from the production box to the test box?

Jean43370 pointsBadges:

Overlay and ‘print’ as pdf. Overlay not included !

This statement OVRPRTF   FILE(MYPRTF)  DEVTYPE(*AFPDS) TOSTMF('/myapp/mypdfs')  WSCST(*PDF) beatifully generates a .pdf file and places it in the IFS-folder '/myapp/mypdfs'. ( ref:  http://www-01.ibm.com/support/docview.wss?uid=nas12bd8020c496ae912862575f400640da6  ) I have an overlay which I...

DanTheDane2,555 pointsBadges:

DDS in TPG logical file definition

In spool severity 20 -keyword specified at incorrect level severity 30 number of join specifications not valid joining 2 files.

pedlat5 pointsBadges:

Get full data dictionary of DSPUSRPRF OUTFILE

Where can I get a full "dictionary" of everything provided in the DSPUSERPRF OUTFILE for example fields such as UPPWEX, UPOBJA and UPINMN for example. I cannot find a data dictionary anywhere. Thanks!!!!

surfettekw20 pointsBadges:

FTP from IFS to iSeries database line: Line break not recognized

I am trying to FTP from IFS to a iSeries database file. The file gets transferred but the end of line is not getting recognized so only one record is created in the receiving file.

ptrabe5 pointsBadges:

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: