Advertisement
Guest User

Untitled

a guest
Sep 6th, 2012
602
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. var dbs = _step_.getTransMeta().getDatabases();
  2. var numDBs = dbs.size();
  3. for(var i=0;i<numDBs;i++) {
  4.  
  5.     newRow = createRowCopy(getOutputRowMeta().size());
  6.     var rowIndex = getInputRowMeta().size();
  7.     var db = _step_.getTransMeta().getDatabase(i);
  8.     if(!db.getURL().equals("undefined")) {
  9.         var database = new Packages.org.pentaho.di.core.database.Database(db); 
  10.         newRow[rowIndex++] = db.environmentSubstitute(db.getName());
  11.         newRow[rowIndex++] = db.environmentSubstitute(db.getDatabaseName());
  12.         newRow[rowIndex++] = db.environmentSubstitute(db.getHostname());
  13.         newRow[rowIndex++] = db.environmentSubstitute(db.getDatabasePortNumberString());
  14.         newRow[rowIndex++] = db.getURL();
  15.         putRow(newRow);
  16.     }
  17. }
  18.  
  19. // Skip input rows
  20. trans_Status = SKIP_TRANSFORMATION;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement