ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Deletion and updation on different environments(LPARs)

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

  • jamief
    replied
    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!

    Leave a comment:


  • Pete
    replied
    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

    Leave a comment:


  • jamief
    replied
    Re: Deletion and updation on different environments(LPARs)

    Hey Pete -- post a picture of that Illinois snow....Please

    Leave a comment:


  • Pete
    replied
    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

    Leave a comment:


  • MichaelCatalani
    replied
    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.

    Leave a comment:


  • DeadManWalks
    replied
    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.

    Leave a comment:


  • techas400
    started a topic Deletion and updation on different environments(LPARs)

    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.
Working...
X