Get answers.  Share knowledge.  Collaborate with peers.




CPYF alternative

Why would you do a CHGPF? That would only be if the file layout is changing. Then it would need to be done on both sides, the from and to files. I assume you are not adding or removing fields from a record definition. They could impact other software/programs if the formats no longer match.



View Discussion   |  May 13, 2013  5:51 PM
AS/400, AS/400 jobs, CPYF
discussed by:
ToddN2000
3,915 pts.

Location of ‘My Documents’

Whats the issue you are facing ..



View Discussion   |  May 13, 2013  5:49 PM
My Documents, Visual Basic
discussed by:
Anu143
525 pts.

AS/400 beginner

Go foe ibm iseries public libraryntoo.will help you



View Discussion   |  May 13, 2013  5:46 PM
AS/400, AS/400 careers
discussed by:
Anu143
525 pts.

User ID disabled

DSPUSRPRF XXXXXXXXXX and check Password expiration interval if set to *SYSVAL then check SYSTEM VALUE QPWDEXPITV which will show number of days when password expires if ignored, then after specific number of attempts if setup will disable profile



View Discussion   |  May 13, 2013  5:44 PM
AS/400, AS/400 user administration
discussed by:
Rickmcd
1,480 pts.

What are your pros and cons of BYOD?

Am I right



View Discussion   |  May 13, 2013  5:44 PM
BYOD, Consumerization, Mobile
discussed by:
Anu143
525 pts.

Do you think Facebook knows too much about you?

I really think so…what does everyone else think?



View Discussion   |  May 13, 2013  5:42 PM
Mobile, Security
discussed by:
Anu143
525 pts.

AS/400 batch commands – make changes to user profiles

Please check CHGRP command.



View Discussion   |  May 13, 2013  5:39 PM
AS/400, AS/400 batch job, OS/400
discussed by:
Anu143
525 pts.

CPYF alternative

Thank you all! I will check it. I hope the file is not added a delete trigger but I’m not sure.

Thank you all for your valuable support.



View Discussion   |  May 13, 2013  5:30 PM
AS/400, AS/400 jobs, CPYF
discussed by:
Anu143
525 pts.

Why there is a partial library backup?

Hope you are using IHA ..for taking the backup..use f1 in the joblog and you will get the job details



View Discussion   |  May 13, 2013  5:22 PM
AS/400 administration, AS/400 backup, iSeries administration
discussed by:
Anu143
525 pts.

CPYF alternative

when you do this SQL delete, you are going to fire the trigger for EVERY record in the file. Depending on how many records there are and how complex the trigger is, this could add up to a significant amount of time



View Discussion   |  May 13, 2013  5:16 PM
AS/400, AS/400 jobs, CPYF
discussed by:
BigKat
7,185 pts.

How can we add monitoring of messages in SDMC and send emails to particular group?

Google for the Api I had given..you will get the code for the same … anu



View Discussion   |  May 13, 2013  5:15 PM
AS/400 administration, iSeries administration
discussed by:
Anu143
525 pts.

How can we add monitoring of messages in SDMC and send emails to particular group?

Create a user space with module “CrtUsrSpc” (source has been included below).

Run API “QUSLJOB” to return information of iSeries job. use any format name “JOBL0200″ to retrieve “job status” and “subsystem”. Job status has “key of field = 0101″ and subsystem “key of field = 1906″.

Run API “QUSRTVUS” to get user space attribute

- starting position of information
- number of entries (number of jobs)
Run a loop to retrieve information on all jobs that have been loaded in the user space — one loop for one job.

First, run API “QUSRTVUS” to retrieve information about one job. This information has been retrieved in data area “.

Second, retrieve “key fields” in and loop.
Key field 0101 = job status
Key field 1906 = subsystem

Third, if the job has status *MSGW and e-mail is sent to an Administrator.
crtrpgmod module(yourlib/crtusrspc) = create user space (source included in prior mail)
crtrpgmod module(yourlib/nkvr4292) = mail program
crtpgm pgm(yourlib/nkvr4292) module(yourlib/nkvr4292 yourlib/crtusrspc) actgrp(nkv)



View Discussion   |  May 13, 2013  5:12 PM
AS/400 administration, iSeries administration
discussed by:
Anu143
525 pts.

CPYF alternative

No problem asking the questions.
Yes, you will need to wait untile the subsystem is down to make the changed.
But depending on the size of this file, you could start the other process of using SQL DELETE and then CPYF wiht *ADD, right now.
You would need watch disk space and then in addition to do the CHGPF command later, you would also want to do a CLRPFM or RGZPFM command because you have a largeer number of deleted records in the fiel.



View Discussion   |  May 13, 2013  4:22 PM
AS/400, AS/400 jobs, CPYF
discussed by:
CharlieBrowne
32,935 pts.

Why there is a partial library backup?

When that happens it is because 1 or more of the objects in that library was locked.
If you look throught the joblog, you will be able to find out what object(s) did not get saved.



View Discussion   |  May 13, 2013  4:18 PM
AS/400 administration, AS/400 backup, iSeries administration
discussed by:
CharlieBrowne
32,935 pts.

Does anybody use FORMPLUS/400…kindly help me

Hi Tom,

We have logged a call with IBM, They helped us to resolve this printer issues.
We updated our form plus firmware, Then our problem got resolved.

Thanks for your help.

With Regards,
Venkata Krishna



View Discussion   |  May 13, 2013  4:13 PM
AS/400, AS/400 print errors
discussed by:
venkatktata
275 pts.

discussed by:
bvining
6,055 pts.

CPYF alternative

Else we need to wait until..the subsystem is down



View Discussion   |  May 13, 2013  3:23 PM
AS/400, AS/400 jobs, CPYF
discussed by:
Anu143
525 pts.

CPYF alternative

Charlie.. The thing is that we cant bring down the other job..as it is a highly critical job. Do we have any other way..to do this..
Sorry if I’m asking too much..



View Discussion   |  May 13, 2013  3:20 PM
AS/400, AS/400 jobs, CPYF
discussed by:
Anu143
525 pts.

CPYF alternative

No, you cannot do a CHGPF on a locked object.
You would have to end the other job and and any other jobs using the file, then make the change and start the other job again.



View Discussion   |  May 13, 2013  3:02 PM
AS/400, AS/400 jobs, CPYF
discussed by:
CharlieBrowne
32,935 pts.

CPYF alternative

And is it possible to do a CHGPF on a locked file …this file is locked 24×7!!!



View Discussion   |  May 13, 2013  1:13 PM
AS/400, AS/400 jobs, CPYF
discussed by:
Anu143
525 pts.