When attempting to rewrite a record after moving/changing one of the components of the key, it hits a error - ie. duplicate key. But after investigation using sql, there is no such existing key value in the database. Why is this happening ?

This is so simple and yet I still need to ask.... If I have my PTFs in my image catalog...And I have my CUME CD's loaded along with my other PTF CD's. When I do a selection 8 off of the GO PTF menu, What do I use for prompt for media? Again, the Cume package is loaded first in the image...

Displaying a user profile on the iSeries will show the timestamp of the 'Previous sign-on'. Right under that is 'Sign-on attempts not valid' without any timestamps. I know how to find that info in the history log, but we purge old history logs every week. Does the system keep a timestamp of the...

I am preparing i5/OS system for a upgrade to Version 6.1 and reviewing the latest V5.4 group hipers and never in the past have applied SF99347 Print and SF99538 Security hipers PTF's. I cannot find any detail information on SF99538 except for " system intergrity problems" and SF99347 " Infoprint...

Hi, While Job monitoring if any job goes in MSGW status ... then is there any CL command which retrieves the status (exactly MSGW not *ACTIVE) and display it on the screen. Rather than doing manually job monitoring (Pressing F5 for a long time to look into the status of the job) if a CL can run...

Sorry if this shows up more than once, first time poster and I'm a tad confused about how to get my question to appear under a specific category. I'm trying to use the iSeries QYKMIMPK api to import a certificate into the *SYSTEM certificate store and encountering error CFPB006, which appears to be...

Would it be better to use SQL or RPG, to update one field in the file with a value from another field in the same file? I am not that familiar with SQL, only a beginner. My RPG skills are rusty as I've not written anything in the last 4 years.

I have a new user that needs the file transfer function. I have it configured correctly because I can login as myself but with her ID I am not able to. I copied a profile from another user that is using File Transfer so I would think that would be fine but it seems to be something with the profile....

When you go to BRMS Menu --> Policy Administration --> System Policy --> Change Network Group, you can see all the Boxes connected each other. There are 13 LPARS in total But two of these Lpars cannot see them against each other. It shows Network Status INACTIVE while the others shows...

I am a buyer and we are looking for a way to run AS/400 data reports to a PC. The AS/400 is located in Guinea and connects to our network through a server in an office across the street. What are your suggestions to accomplish this? Thanks.

We have an application in which we need to expand the size of several fields within the record, ie the Amount field need to be larger. In the past I would create DDS for the new expanded file, create the file, then write an RPG or Cobol program to copy the data from the old file to the new expanded...

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy