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!
Announcement
Collapse
No announcement yet.
Deletion and updation on different environments(LPARs)
Collapse
X
-
Re: Deletion and updation on different environments(LPARs)
Originally posted by jamief View PostHey Pete -- post a picture of that Illinois snow....Please
Not much snow there, maybe 2"-3", but still cold and wet. Another dark miserable day.
Wish you were here!
Pete
Leave a comment:
-
Re: Deletion and updation on different environments(LPARs)
Hey Pete -- post a picture of that Illinois snow....Please
Leave a comment:
-
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:
-
Re: Deletion and updation on different environments(LPARs)
Originally posted by techas400Is it possible to compute a file member removal in a rpgle program from a development lpar.
You never ever ever ever ever want to touch prod data/objects from the dev system.
Leave a comment:
-
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:
-
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.
Leave a comment: