Moving a large number of objects to the transport case

Document ID : KB000088389
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
There are different methods of putting a large number of objects into the Transport Case.
  • If they are in one folder, select all objects and right click them.
0EMb0000001QR4h.png
  • You can also use the search function, if they have e.g. a common name pattern:
0EMb0000001QR4m.png
  • However, the search is limited. What if you e.g. move all Linux jobs to the Transport Case that have -bash as Shell-attribute.
Resolution:
In such a case, you can use SQL-commands:
  • To find the list of objects, create an according select. For the example (Linux jobs that have -bash as Shell-attribute):
SELECT OH.OH_Name
  , JBA.JBA_Rest
FROM JBA, OH
  WHERE OH.OH_Idnr   = JBA.JBA_OH_Idnr
    AND JBA.JBA_Rest LIKE '%M=''-bash''%'
    AND OH.OH_Name   LIKE 'JS.UN%'
    AND OH.OH_Client = 1977;
  • The received list can be used to move the objects to the Transport Case. This is done by setting the value of the export flag (OH_ExpFlag) to 1 for these objects. Using the select as sub-select in the where-clause of the update command looks like in the example below: 
UPDATE OH
  SET OH_ExpFlag = 1
  WHERE OH_Name IN (SELECT OH.OH_Name
      FROM JBA, OH
      WHERE OH.OH_Idnr = JBA.JBA_OH_Idnr
        AND JBA.JBA_Rest LIKE '%M=''''%'
        AND OH.OH_Name LIKE 'JS.UN%'
        AND OH.OH_Client = 1977
        AND OH_Deleteflag = 0
        AND OH_Otype NOT IN ('FOLD', 'CLNT', 'HOST', 'SERV'));
 
Important:
  • OH_Deleteflag = 0 must be in the where-clause or version-objects and objects in the trash bin will also be transported
  • OH_Otype NOT IN ('FOLD', 'CLNT', 'HOST', 'SERV') because these object-types must not be transported
This can be adapted to any kind of search. Please always make backups of your DB before doing such changes and test especially the select-criteria thoroughly.