ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Deletion and updation on different environments(LPARs)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Deletion and updation on different environments(LPARs)

    Is it possible to compute a file member removal in a rpgle program from a development lpar.

    eg: RMVM FILE(LIB/FILE1) MBR(PAR1981181)
    and performing updation on a different file in a different lpar altogether?

    UPDATE "SCDTA.CORP"/AR#RMTPRL9
    SET SENTFLAG = ' ', DATESENT = '0001-01-01', TIMESENT = '00:00:00', XMITT# = 0, LOCATION = 'PACI175A', ARBATCH# = ' '
    WHERE LOCATION = 'PACI173A' AND ARBATCH# = 'PAR1981181'

    How exactly can one perform setting of lpars in one single program?Is this possible. Please guide.

  • #2
    Re: Deletion and updation on different environments(LPARs)

    You can not perform an update to table XX on system YY from system AA, unless you are using JDBC (well easiest way). A cheesy work around could be to ftp to get the table XX from YY to AA, then update XX, then ftp XX back to YY from AA. Or you could build a bunch of "quote" commands to have in your FTP script. In this case all you would do is connect with FTP and have the quote commands run.

    That being said, Your update using a member is wrong. SQL does not care about members. You first have to override the table to a member. The RMVM can be issued using the quote command in FTP.
    Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply

    Comment


    • #3
      Re: Deletion and updation on different environments(LPARs)

      Originally posted by techas400
      Is it possible to compute a file member removal in a rpgle program from a development lpar.
      Not if security is set up correctly.

      You never ever ever ever ever want to touch prod data/objects from the dev system.
      Michael Catalani
      IS Director, eCommerce & Web Development
      Acceptance Insurance Corporation
      www.AcceptanceInsurance.com
      www.ProvatoSys.com

      Comment


      • #4
        Re: Deletion and updation on different environments(LPARs)

        You could use DDM tables:

        http://publib.boulder.ibm.com/html/a...rbal1mst81.htm

        or use the DISCONNECT and CONNECT statement in SQL to connect to remote IBM databases once they have been properly set up on your system.

        Pete

        Comment


        • #5
          Re: Deletion and updation on different environments(LPARs)

          Hey Pete -- post a picture of that Illinois snow....Please
          All my answers were extracted from the "Big Dummy's Guide to the As400"
          and I take no responsibility for any of them.

          www.code400.com

          Comment


          • #6
            Re: Deletion and updation on different environments(LPARs)

            Originally posted by jamief View Post
            Hey Pete -- post a picture of that Illinois snow....Please
            Here you go, you traitor. Cell phone out my tinted glass, makes it look even more gloomy than it actually is:

            Click image for larger version

Name:	IMAG0008A.jpg
Views:	1
Size:	119.9 KB
ID:	126608

            Not much snow there, maybe 2"-3", but still cold and wet. Another dark miserable day.

            Wish you were here!

            Pete

            Comment


            • #7
              Re: Deletion and updation on different environments(LPARs)

              I'm sorry I didn't here that last part..The windows opened and an ice cream truck just went by!

              Stay warm Pete!
              All my answers were extracted from the "Big Dummy's Guide to the As400"
              and I take no responsibility for any of them.

              www.code400.com

              Comment

              Working...
              X