Insert data in a PF by using a CL program

65 pts.
Tags:
AS/400
CL Program
How do I insert the data in PF by using a CL program?


Software/Hardware used:
software
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Can be done using SQL and INSERT command or by CPYF with an *ADD.

There may be others but why add records via a CLP ???

Discuss This Question: 9  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    Use the RUNSQL command with an INSERT statement. There are multiple ways to do it, but the RUNSQL command is easiest (if you have a currently supported version of the OS).
    35,630 pointsBadges:
    report
  • philpl1jb
    You've provided us with a strange list of questions, all in the same day. Interview? Homework?
    54,090 pointsBadges:
    report
  • Splat
    philpl1jb, I'm thinking interview.
    12,895 pointsBadges:
    report
  • venki1259
    Interview

    65 pointsBadges:
    report
  • Splat
    venki1259, Do you realise that you're misleading your interviewer by trolling for answers to the questions you've been asked?  You may also be setting yourself up for a very unpleasant time, if hired, when you fail to perform to the level you've mislead others to expect.  While I can't speak for others (let alone your interviewer) I have to say I would much rather work with someone of integrity than someone who deceived and dissembled ab initio.
    12,895 pointsBadges:
    report
  • azohawk

    I have to agree with Splat on this. These questions could be to gauge how much you do/don't know so that they can determine training required, early expectations, initial salary; not necessarily hiring (look at hiring information and you will see that hiring is based less on technical knowledge and more on personality fit in most cases.)  If this is a large IT department, they will care more that you can learn, smaller shops (i.e. where you will be the only AS/400 expert) you would be frustrated.

    As part of a recent interview process, I was asked to take a technical test. I was told that I wasn't expected to (and I didn't) get 100% (after 20 years).  Rather it was to determine that I did know something and still had an openness to learn and grow.

     

    In the case of the forum, I think others would agree, we would prefere you to be up front about it.  "I am going to an interview and have been told that this question will be asked ... I have researched and think I can answer it this way... Am I on the right track?

    4,055 pointsBadges:
    report
  • Splat
    venki1259, One further note.  My comments aren't intended to drive you away from this forum.  I believe I can say without contradiction that we all learn from the questions and responses posted here and I wouldn't want you to think that you aren't welcome.
    12,895 pointsBadges:
    report
  • venki1259
    sorry i don't want anything ......i never post questions or else bye
    i am asking jest  few questions but u r saying like this 
    65 pointsBadges:
    report
  • philpl1jb

    venki

    our purpose is to help technical users of the AS/400. We will be happy to help you with your technical use. We don't feel that feeding you answers to interview questions is a help to you or your future employer.

    54,090 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: