public String generate(Object argument) {
    final StringBuffer stringBuffer = new StringBuffer();
    stringBuffer.append(TEXT_1);

    CodeGeneratorArgument codeGenArgument = (CodeGeneratorArgument) argument;
    INode node = (INode) codeGenArgument.getArgument();

    String cid = node.getUniqueName();

    String dbtable = null;
    String dbschema = ElementParameterParser.getValue(node, "__ELT_SCHEMA_NAME__");
    String uniqueNameConnection = null;
    INode previousNode = null;

    String differenttable = ElementParameterParser.getValue(node, "__DIFFERENT_TABLE_NAME__");
    boolean useDifferentTable =
        "true".equals(ElementParameterParser.getValue(node, "__USE_DIFFERENT_TABLE__"));

    stringBuffer.append(TEXT_2);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_3);

    List<IConnection> connections = (List<IConnection>) node.getIncomingConnections();
    if (connections != null && connections.size() > 0 && connections.get(0) != null) {
      IConnection connection = connections.get(0);
      previousNode = connection.getSource();
      String previousComponentName = previousNode.getUniqueName();
      dbtable = connection.getName();
      uniqueNameConnection = connection.getUniqueName();

      stringBuffer.append(TEXT_4);
      stringBuffer.append(previousComponentName);
      stringBuffer.append(TEXT_5);
      stringBuffer.append(uniqueNameConnection);
      stringBuffer.append(TEXT_6);
    }

    if ((dbschema != null) && (!"\"\"".equals(dbschema.replaceAll(" ", "").trim()))) {

      stringBuffer.append(TEXT_7);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_8);
      stringBuffer.append(dbschema);
      stringBuffer.append(TEXT_9);
      stringBuffer.append(useDifferentTable ? differenttable : "\"" + dbtable + "\"");
      stringBuffer.append(TEXT_10);

    } else {

      stringBuffer.append(TEXT_11);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_12);
      stringBuffer.append(useDifferentTable ? differenttable : "\"" + dbtable + "\"");
      stringBuffer.append(TEXT_13);
    }

    String dbtypeDefinition = ElementParameterParser.getValue(node, "__TYPE__");

    String tableName = ElementParameterParser.getValue(node, "__TABLE__");

    String dataAction = ElementParameterParser.getValue(node, "__DATA_ACTION__");

    String dbhost = null;
    String dbport = null;
    String dbname = null;
    String dbuser = null;
    String dbpwd = null;
    String connectionType = null;
    boolean useExistingConn = false;
    String dbproperties = null;
    if (previousNode != null) {
      dbhost = ElementParameterParser.getValue(previousNode, "__HOST__");
      dbport = ElementParameterParser.getValue(previousNode, "__PORT__");
      dbname = ElementParameterParser.getValue(previousNode, "__DBNAME__");
      dbuser = ElementParameterParser.getValue(previousNode, "__USER__");
      dbpwd = ElementParameterParser.getValue(previousNode, "__PASS__");
      connectionType = ElementParameterParser.getValue(previousNode, "__CONNECTION_TYPE__");
      useExistingConn =
          ("true")
              .equals(ElementParameterParser.getValue(previousNode, "__USE_EXISTING_CONNECTION__"));
      dbproperties = ElementParameterParser.getValue(previousNode, "__PROPERTIES__");
    }

    //        String tableAction = ElementParameterParser.getValue(
    //            node,
    //            "__TABLE_ACTION__"
    //        );

    String whereClause = ElementParameterParser.getValue(node, "__WHERE_CLAUSE__");

    stringBuffer.append(TEXT_14);

    if (useExistingConn) {
      String connection = ElementParameterParser.getValue(previousNode, "__CONNECTION__");
      String conn = "conn_" + connection;

      stringBuffer.append(TEXT_15);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_16);
      stringBuffer.append(conn);
      stringBuffer.append(TEXT_17);

    } else {

      stringBuffer.append(TEXT_18);

      if (connectionType == null || ("ORACLE_SID").equals(connectionType)) {

        stringBuffer.append(TEXT_19);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_20);
        stringBuffer.append(dbhost);
        stringBuffer.append(TEXT_21);
        stringBuffer.append(dbport);
        stringBuffer.append(TEXT_22);
        stringBuffer.append(dbname);
        stringBuffer.append(TEXT_23);

      } else if (("ORACLE_SERVICE_NAME").equals(connectionType)) {

        stringBuffer.append(TEXT_24);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_25);
        stringBuffer.append(dbhost);
        stringBuffer.append(TEXT_26);
        stringBuffer.append(dbport);
        stringBuffer.append(TEXT_27);
        stringBuffer.append(dbname);
        stringBuffer.append(TEXT_28);

      } else if ("ORACLE_RAC".equals(connectionType)) {
        String rac_url = ElementParameterParser.getValue(previousNode, "__RAC_URL__");

        stringBuffer.append(TEXT_29);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_30);
        stringBuffer.append(rac_url);
        stringBuffer.append(TEXT_31);
      }

      stringBuffer.append(TEXT_32);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_33);
      stringBuffer.append(dbuser);
      stringBuffer.append(TEXT_34);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_35);
      stringBuffer.append(dbpwd);
      stringBuffer.append(TEXT_36);

      if (dbproperties == null || ("\"\"").equals(dbproperties) || ("").equals(dbproperties)) {

        stringBuffer.append(TEXT_37);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_38);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_39);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_40);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_41);

      } else {

        stringBuffer.append(TEXT_42);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_43);
        stringBuffer.append(dbproperties);
        stringBuffer.append(TEXT_44);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_45);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_46);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_47);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_48);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_49);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_50);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_51);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_52);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_53);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_54);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_55);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_56);
      }

      stringBuffer.append(TEXT_57);
    }

    stringBuffer.append(TEXT_58);

    List<IMetadataColumn> columnList = null;

    List<IMetadataTable> metadatas = node.getMetadataList();
    if (metadatas != null && metadatas.size() > 0) {
      IMetadataTable metadata = metadatas.get(0);
      if (metadata != null) {
        columnList = metadata.getListColumns();
      }
    }

    stringBuffer.append(TEXT_59);
    if (("INSERT_OR_UPDATE").equals(dataAction) || ("UPDATE_OR_INSERT").equals(dataAction)) {
      stringBuffer.append(TEXT_60);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_61);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_62);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_63);
    } else {
      stringBuffer.append(TEXT_64);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_65);
    }

    if (columnList != null && columnList.size() > 0) {

      class Column {

        IMetadataColumn column;

        String name;

        String sqlStmt;

        String value;

        String validateName;

        boolean addCol;

        List<Column> replacement = new ArrayList<Column>();

        public Column(String colName, String sqlStmt, boolean addCol) {
          this.column = null;
          this.name = colName;
          this.sqlStmt = sqlStmt;
          this.value = "?";
          this.addCol = addCol;
          this.validateName = MetadataToolHelper.validateValue(colName);
        }

        public Column(IMetadataColumn column) {
          this.column = column;
          this.name = column.getLabel();
          this.sqlStmt = "=?";
          this.value = "?";
          this.addCol = false;
          this.validateName = MetadataToolHelper.validateValue(column.getLabel());
        }

        public boolean isReplaced() {
          return replacement.size() > 0;
        }

        public void replace(Column column) {
          this.replacement.add(column);
        }

        public List<Column> getReplacement() {
          return this.replacement;
        }

        public void setColumn(IMetadataColumn column) {
          this.column = column;
        }

        public IMetadataColumn getColumn() {
          return this.column;
        }

        public void setName(String name) {
          this.name = name;
        }

        public String getName() {
          return this.name;
        }

        public void setIsAddCol(boolean isadd) {
          this.addCol = isadd;
        }

        public boolean isAddCol() {
          return this.addCol;
        }

        public void setSqlStmt(String sql) {
          this.sqlStmt = sql;
        }

        public String getSqlStmt() {
          return this.sqlStmt;
        }

        public void setValue(String value) {
          this.value = value;
        }

        public String getValue() {
          return this.value;
        }

        public String getValidateName() {
          return this.validateName;
        }
      }

      StringBuilder insertColName = new StringBuilder();

      StringBuilder insertValueStmt = new StringBuilder();

      StringBuilder updateSetStmt = new StringBuilder();

      StringBuilder updateWhereStmt = new StringBuilder();

      StringBuilder mergeCondition = new StringBuilder();

      List<Column> stmtStructure = new LinkedList<Column>();

      for (IMetadataColumn column : columnList) {

        stmtStructure.add(new Column(column));
      }

      int counterOuter = 0;
      boolean firstKey = true;
      boolean firstNoneKey = true;
      boolean isfirstKey = true;
      for (Column colStmt : stmtStructure) {
        String colName = colStmt.getName();
        if (!colName.equals(colStmt.getValidateName())) {
          colStmt.setName("\\\"" + colName + "\\\"");
        }
        String suffix = ",";

        if (colStmt.getColumn().isKey()) {
          if (isfirstKey) {
            isfirstKey = false;
          } else {
            mergeCondition.append(" AND ");
          }
          mergeCondition.append(
              "target."
                  + colStmt.getColumn().getLabel()
                  + "=source."
                  + colStmt.getColumn().getLabel());
        }
        if (colStmt.isReplaced()) {
          List<Column> replacedColumns = colStmt.getReplacement();
          int counterReplace = 0;
          if (counterOuter == (stmtStructure.size() - 1)
              && counterReplace == (replacedColumns.size() - 1)) {
            suffix = "";
          }
          for (Column replacement : replacedColumns) {
            insertColName.append(replacement.getName() + suffix);
            insertValueStmt.append(replacement.getSqlStmt() + suffix);
            if (!colStmt.getColumn().isKey()) {
              if (!firstNoneKey) {
                updateSetStmt.append(",");
              } else {
                firstNoneKey = false;
              }
              updateSetStmt.append(replacement.getName());
              updateSetStmt.append(replacement.getSqlStmt());
            } else {
              if (!firstKey) {
                updateWhereStmt.append(" AND ");
              } else {
                firstKey = false;
              }
              updateWhereStmt.append(replacement.getName());
              updateWhereStmt.append(replacement.getSqlStmt());
            }
            counterReplace++;
          }
        } else {
          if (counterOuter == (stmtStructure.size() - 1)) {
            suffix = "";
          }
          if (colStmt.isAddCol()) {
            insertColName.append(colStmt.getName() + suffix);
            insertValueStmt.append(colStmt.getSqlStmt() + suffix);
            updateSetStmt.append(colStmt.getName());
            updateSetStmt.append(colStmt.getSqlStmt() + suffix);
          } else {
            insertColName.append(colStmt.getName() + suffix);
            insertValueStmt.append(colStmt.getValue() + suffix);
            if (!colStmt.getColumn().isKey()) {
              if (!firstNoneKey) {
                updateSetStmt.append(",");
              } else {
                firstNoneKey = false;
              }
              updateSetStmt.append(colStmt.getName());
              updateSetStmt.append(colStmt.getSqlStmt());
            } else {
              if (!firstKey) {
                updateWhereStmt.append(" AND ");
              } else {
                firstKey = false;
              }
              updateWhereStmt.append(colStmt.getName());
              updateWhereStmt.append(colStmt.getSqlStmt());
            }
          }
        }
        counterOuter++;
      }

      ///// hint options/////
      boolean useHintOptions =
          ("true").equals(ElementParameterParser.getValue(node, "__USE_HINT_OPTIONS__"));
      Map<String, String> hintsValues = null;
      if (useHintOptions) {
        List<Map<String, String>> hintOptions =
            (List<Map<String, String>>)
                ElementParameterParser.getObjectValue(node, "__HINT_OPTIONS__");
        hintsValues = new HashMap<String, String>();
        String hintValue = null;
        boolean firstInsert = true;
        boolean firstUpdate = true;
        boolean firstDelete = true;
        boolean firstTableName = true;
        for (java.util.Map<String, String> option : hintOptions) {
          // get
          if (option.get("HINT").matches("\"/\\*NORMALIZED_HINT\\*/\"")) {
            String id = cid.replace(node.getComponent().getName() + "_", "");
            hintValue =
                "\"/*\"+"
                    + dbtable
                    + "+\".\" + "
                    + "\""
                    + option.get("SQL_STMT")
                    + ".\""
                    + "+"
                    + id
                    + "+\"*/\" ";
          } else if (option.get("HINT").matches("\"/\\*+.*\\*/\"")) {
            hintValue = option.get("HINT");
          }
          // set
          if ("INSERT".equalsIgnoreCase(option.get("SQL_STMT"))) {
            if (firstInsert) {
              hintsValues.put("INSERT", hintValue);
              firstInsert = false;
            } else {
              hintsValues.put("INSERT", hintsValues.get("INSERT") + "+" + hintValue);
            }
          } else if ("UPDATE".equalsIgnoreCase(option.get("SQL_STMT"))) {
            if (firstUpdate) {
              hintsValues.put("UPDATE", hintValue);
              firstUpdate = false;
            } else {
              hintsValues.put("UPDATE", hintsValues.get("UPDATE") + "+" + hintValue);
            }
          } else if ("DELETE".equalsIgnoreCase(option.get("SQL_STMT"))) {
            if (firstDelete) {
              hintsValues.put("DELETE", hintValue);
              firstDelete = false;
            } else {
              hintsValues.put("DELETE", hintsValues.get("DELETE") + "+" + hintValue);
            }
          } else if ("TABLE_NAME".equalsIgnoreCase(option.get("SQL_STMT"))) {
            if (firstTableName) {
              hintsValues.put("TABLE_NAME", hintValue);
              firstTableName = false;
            } else {
              hintsValues.put("TABLE_NAME", hintsValues.get("TABLE_NAME") + "+" + hintValue);
            }
          }
        }
      }
      //// hint options end ////

      if (("INSERT").equals(dataAction)) {

        stringBuffer.append(TEXT_66);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_67);
        stringBuffer.append(insertColName.toString());
        stringBuffer.append(TEXT_68);

        if (useHintOptions && hintsValues.get("INSERT") != null) {

          stringBuffer.append(TEXT_69);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_70);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_71);
          stringBuffer.append(hintsValues.get("INSERT"));
          stringBuffer.append(TEXT_72);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_73);
        }

        stringBuffer.append(TEXT_74);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_75);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_76);

      } else if (("UPDATE").equals(dataAction)) {

        stringBuffer.append(TEXT_77);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_78);
        stringBuffer.append(insertColName.toString());
        stringBuffer.append(TEXT_79);

        if (CodeGenerationUtils.hasAlphaNumericCharacter(whereClause)) {

          stringBuffer.append(TEXT_80);
          stringBuffer.append(CodeGenerationUtils.replaceAllCrBySpace(whereClause));
        }

        stringBuffer.append(TEXT_81);
        if (useHintOptions && hintsValues.get("UPDATE") != null) {

          stringBuffer.append(TEXT_82);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_83);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_84);
          stringBuffer.append(hintsValues.get("UPDATE"));
          stringBuffer.append(TEXT_85);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_86);
        }

        stringBuffer.append(TEXT_87);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_88);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_89);

      } else if (("INSERT_OR_UPDATE").equals(dataAction)) {

        stringBuffer.append(TEXT_90);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_91);
        stringBuffer.append(insertColName.toString());
        stringBuffer.append(TEXT_92);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_93);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_94);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_95);
        stringBuffer.append(insertColName.toString());
        stringBuffer.append(TEXT_96);
        if (CodeGenerationUtils.hasAlphaNumericCharacter(whereClause)) {
          stringBuffer.append(TEXT_97);
          stringBuffer.append(CodeGenerationUtils.replaceAllCrBySpace(whereClause));
        }
        stringBuffer.append(TEXT_98);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_99);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_100);

      } else if (("UPDATE_OR_INSERT").equals(dataAction)) {

        stringBuffer.append(TEXT_101);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_102);
        stringBuffer.append(insertColName.toString());
        stringBuffer.append(TEXT_103);
        if (CodeGenerationUtils.hasAlphaNumericCharacter(whereClause)) {
          stringBuffer.append(TEXT_104);
          stringBuffer.append(CodeGenerationUtils.replaceAllCrBySpace(whereClause));
        }
        stringBuffer.append(TEXT_105);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_106);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_107);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_108);
        stringBuffer.append(insertColName.toString());
        stringBuffer.append(TEXT_109);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_110);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_111);

      } else if (("DELETE").equals(dataAction)) {

        stringBuffer.append(TEXT_112);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_113);
        if (CodeGenerationUtils.hasAlphaNumericCharacter(whereClause)) {
          stringBuffer.append(TEXT_114);
          stringBuffer.append(CodeGenerationUtils.replaceAllCrBySpace(whereClause));
        }
        stringBuffer.append(TEXT_115);

        if (useHintOptions && hintsValues.get("DELETE") != null) {

          stringBuffer.append(TEXT_116);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_117);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_118);
          stringBuffer.append(hintsValues.get("DELETE"));
          stringBuffer.append(TEXT_119);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_120);
        }
        stringBuffer.append(TEXT_121);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_122);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_123);

      } else if ("MERGE".equals(dataAction)) {
        // get parameter
        boolean useMergeUpdate =
            "true".equalsIgnoreCase(ElementParameterParser.getValue(node, "__USE_MERGE_UPDATE__"));
        boolean useMergeInsert =
            "true".equalsIgnoreCase(ElementParameterParser.getValue(node, "__USE_MERGE_INSERT__"));

        boolean useUpdateWhere =
            "true"
                .equalsIgnoreCase(
                    ElementParameterParser.getValue(node, "__USE_MERGE_UPDATE_WHERE__"));
        boolean useUpdateDeleteWhere =
            "true"
                .equalsIgnoreCase(
                    ElementParameterParser.getValue(node, "__USE_MERGE_UPDATE_DELETE_WHERE__"));
        boolean useInsertWhere =
            "true"
                .equalsIgnoreCase(
                    ElementParameterParser.getValue(node, "__USE_MERGE_INSERT_WHERE__"));

        List<Map<String, String>> updateColumns =
            (List<Map<String, String>>)
                ElementParameterParser.getObjectValue(node, "__SCHEMA_UPDATE__");
        List<Map<String, String>> insertColumns =
            (List<Map<String, String>>)
                ElementParameterParser.getObjectValue(node, "__SCHEMA_INSERT__");

        StringBuilder mergeUpdate = new StringBuilder();
        StringBuilder mergeInsertName = new StringBuilder();
        StringBuilder mergeInsertValue = new StringBuilder();

        stringBuffer.append(TEXT_124);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_125);
        stringBuffer.append(mergeCondition);
        stringBuffer.append(TEXT_126);

        if (!useMergeUpdate) useUpdateWhere = false;
        if (useMergeUpdate) {
          boolean isfirstUpdateSet = true;
          String keyColumnName = null;
          for (Map<String, String> keyColumn : updateColumns) {
            if (keyColumn.get("UPDATE").equals("true")) {
              if (isfirstUpdateSet) {
                isfirstUpdateSet = false;
              } else {
                mergeUpdate.append(",");
              }
              keyColumnName = keyColumn.get("SCHEMA_COLUMN");
              if (!(keyColumnName != null
                  && keyColumnName.equals(MetadataToolHelper.validateValue(keyColumnName)))) {
                keyColumnName = "\\\"" + keyColumnName + "\\\"";
              }
              mergeUpdate.append("target." + keyColumnName + "=source." + keyColumnName);
            }
          }

          stringBuffer.append(TEXT_127);
          stringBuffer.append(mergeUpdate);
          stringBuffer.append(TEXT_128);
          if (useUpdateWhere) {
            String useUpdateWhereString =
                ElementParameterParser.getValue(node, "__MERGE_UPDATE_WHERE_STRING__");
            if (useUpdateWhereString == null || useUpdateWhereString.length() == 0) {

              stringBuffer.append(TEXT_129);

            } else {
              stringBuffer.append(TEXT_130);
              stringBuffer.append(useUpdateWhereString);
              stringBuffer.append(TEXT_131);
            }
          }
          stringBuffer.append(TEXT_132);
          if (useUpdateDeleteWhere) {
            String useUpdateDeleteWhereString =
                ElementParameterParser.getValue(node, "__MERGE_UPDATE_DELETE_WHERE_STRING__");
            if (useUpdateDeleteWhereString == null || useUpdateDeleteWhereString.length() == 0) {

              stringBuffer.append(TEXT_133);

            } else {
              stringBuffer.append(TEXT_134);
              stringBuffer.append(useUpdateDeleteWhereString);
              stringBuffer.append(TEXT_135);
            }
          }
          stringBuffer.append(TEXT_136);
        }
        stringBuffer.append(TEXT_137);

        if (!useMergeInsert) useInsertWhere = false;
        if (useMergeInsert) {
          boolean isfirstInsertWhere = true;
          String keyColumnName = null;
          for (Map<String, String> keyColumn : insertColumns) {
            if (isfirstInsertWhere) {
              isfirstInsertWhere = false;
            } else {
              mergeInsertName.append(",");
              mergeInsertValue.append(",");
            }
            if (keyColumn.get("INSERT").equals("true")) {
              keyColumnName = keyColumn.get("SCHEMA_COLUMN");
              if (!(keyColumnName != null
                  && keyColumnName.equals(MetadataToolHelper.validateValue(keyColumnName)))) {
                keyColumnName = "\\\"" + keyColumnName + "\\\"";
              }
              mergeInsertName.append(keyColumnName);
              mergeInsertValue.append("source." + keyColumnName);
            }
          }

          stringBuffer.append(TEXT_138);
          stringBuffer.append(mergeInsertName);
          stringBuffer.append(TEXT_139);
          stringBuffer.append(mergeInsertValue);
          stringBuffer.append(TEXT_140);
        }
        if (useInsertWhere) {
          String useInsertWhereString =
              ElementParameterParser.getValue(node, "__MERGE_INSERT_WHERE_STRING__");
          if (useInsertWhereString == null || useInsertWhereString.length() == 0) {

            stringBuffer.append(TEXT_141);

          } else {
            stringBuffer.append(TEXT_142);
            stringBuffer.append(useInsertWhereString);
            stringBuffer.append(TEXT_143);
          }
        }

        stringBuffer.append(TEXT_144);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_145);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_146);
      }

      stringBuffer.append(TEXT_147);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_148);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_149);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_150);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_151);
    }

    // MAIN

    String incomingConnName = null;
    columnList = null;

    List<? extends IConnection> conns = node.getIncomingConnections();
    if (conns != null && conns.size() > 0) {
      IConnection conn = conns.get(0);
      incomingConnName = conn.getName();
    }

    metadatas = node.getMetadataList();

    if (metadatas != null && metadatas.size() > 0) {
      IMetadataTable metadata = metadatas.get(0);
      if (metadata != null) {
        columnList = metadata.getListColumns();
      }
    }

    if (incomingConnName != null && columnList != null) {
      if (("INSERT").equals(dataAction)) {

        stringBuffer.append(TEXT_152);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_153);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_154);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_155);

      } else if (("UPDATE").equals(dataAction)) {

        stringBuffer.append(TEXT_156);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_157);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_158);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_159);

      } else if (("INSERT_OR_UPDATE").equals(dataAction)) {

        stringBuffer.append(TEXT_160);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_161);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_162);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_163);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_164);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_165);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_166);

      } else if (("UPDATE_OR_INSERT").equals(dataAction)) {

        stringBuffer.append(TEXT_167);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_168);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_169);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_170);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_171);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_172);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_173);

      } else if (("DELETE").equals(dataAction)) {

        stringBuffer.append(TEXT_174);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_175);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_176);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_177);

      } else if (("MERGE").equals(dataAction)) {

        stringBuffer.append(TEXT_178);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_179);
      }
    }

    // END

    if (("INSERT_OR_UPDATE").equals(dataAction) || ("UPDATE_OR_INSERT").equals(dataAction)) {

      stringBuffer.append(TEXT_180);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_181);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_182);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_183);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_184);

    } else {

      stringBuffer.append(TEXT_185);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_186);
    }

    stringBuffer.append(TEXT_187);

    if (!useExistingConn) {

      stringBuffer.append(TEXT_188);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_189);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_190);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_191);
    }

    stringBuffer.append(TEXT_192);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_193);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_194);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_195);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_196);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_197);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_198);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_199);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_200);
    stringBuffer.append(TEXT_201);
    return stringBuffer.toString();
  }
  public String generate(Object argument) {
    final StringBuffer stringBuffer = new StringBuffer();
    stringBuffer.append(TEXT_1);

    CodeGeneratorArgument codeGenArgument = (CodeGeneratorArgument) argument;
    INode node = (INode) codeGenArgument.getArgument();

    String cid = node.getUniqueName();

    String dbtable = null;
    String dbschema = ElementParameterParser.getValue(node, "__ELT_SCHEMA_NAME__");
    String uniqueNameConnection = null;
    INode previousNode = null;

    String differenttable = ElementParameterParser.getValue(node, "__DIFFERENT_TABLE_NAME__");
    boolean useDifferentTable =
        "true".equals(ElementParameterParser.getValue(node, "__USE_DIFFERENT_TABLE__"));

    stringBuffer.append(TEXT_2);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_3);

    List<IConnection> connections = (List<IConnection>) node.getIncomingConnections();
    if (connections != null && connections.size() > 0 && connections.get(0) != null) {
      IConnection connection = connections.get(0);
      previousNode = connection.getSource();
      String previousComponentName = previousNode.getUniqueName();
      dbtable = connection.getName();
      uniqueNameConnection = connection.getUniqueName();

      stringBuffer.append(TEXT_4);
      stringBuffer.append(previousComponentName);
      stringBuffer.append(TEXT_5);
      stringBuffer.append(uniqueNameConnection);
      stringBuffer.append(TEXT_6);
      stringBuffer.append(previousComponentName);
      stringBuffer.append(TEXT_7);
      stringBuffer.append(uniqueNameConnection);
      stringBuffer.append(TEXT_8);
    }

    stringBuffer.append(TEXT_9);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_10);
    stringBuffer.append(dbschema);
    stringBuffer.append(TEXT_11);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_12);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_13);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_14);
    stringBuffer.append(dbschema);
    stringBuffer.append(TEXT_15);
    stringBuffer.append(useDifferentTable ? differenttable : "\"" + dbtable + "\"");
    stringBuffer.append(TEXT_16);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_17);
    stringBuffer.append(useDifferentTable ? differenttable : "\"" + dbtable + "\"");
    stringBuffer.append(TEXT_18);

    String dataAction = ElementParameterParser.getValue(node, "__DATA_ACTION__");

    String dbhost = null;
    String dbport = null;
    String dbname = null;
    String dbuser = null;
    String dbpwd = null;
    boolean useExistingConn = false;
    if (previousNode != null) {
      dbhost = ElementParameterParser.getValue(previousNode, "__HOST__");
      dbport = ElementParameterParser.getValue(previousNode, "__PORT__");
      dbname = ElementParameterParser.getValue(previousNode, "__DBNAME__");
      dbuser = ElementParameterParser.getValue(previousNode, "__USER__");
      dbpwd = ElementParameterParser.getValue(previousNode, "__PASS__");
      useExistingConn =
          ("true")
              .equals(ElementParameterParser.getValue(previousNode, "__USE_EXISTING_CONNECTION__"));
    }
    String whereClause = ElementParameterParser.getValue(node, "__WHERE_CLAUSE__");

    stringBuffer.append(TEXT_19);

    if (useExistingConn) {
      String connection = ElementParameterParser.getValue(previousNode, "__CONNECTION__");
      String conn = "conn_" + connection;

      stringBuffer.append(TEXT_20);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_21);
      stringBuffer.append(conn);
      stringBuffer.append(TEXT_22);

    } else {

      stringBuffer.append(TEXT_23);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_24);
      stringBuffer.append(dbhost);
      stringBuffer.append(TEXT_25);
      stringBuffer.append(dbport);
      stringBuffer.append(TEXT_26);
      stringBuffer.append(dbname);
      stringBuffer.append(TEXT_27);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_28);
      stringBuffer.append(dbuser);
      stringBuffer.append(TEXT_29);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_30);
      stringBuffer.append(dbpwd);
      stringBuffer.append(TEXT_31);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_32);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_33);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_34);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_35);
    }
    List<IMetadataColumn> columnList = null;
    List<IMetadataTable> metadatas = node.getMetadataList();
    if (metadatas != null && metadatas.size() > 0) {
      IMetadataTable metadata = metadatas.get(0);
      if (metadata != null) {
        columnList = metadata.getListColumns();
      }
    }

    stringBuffer.append(TEXT_36);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_37);

    if (columnList != null && columnList.size() > 0) {

      class Column {

        IMetadataColumn column;

        String name;

        String sqlStmt;

        String value;

        boolean addCol;

        List<Column> replacement = new ArrayList<Column>();

        public Column(IMetadataColumn column) {
          this.column = column;
          String columname = column.getOriginalDbColumnName();
          if (columname != null && columname.trim().length() > 0) {
            this.name = columname;
          } else {
            this.name = column.getLabel();
          }
          this.sqlStmt = "=?";
          this.value = "?";
          this.addCol = false;
        }

        public boolean isReplaced() {
          return replacement.size() > 0;
        }

        public List<Column> getReplacement() {
          return this.replacement;
        }

        public IMetadataColumn getColumn() {
          return this.column;
        }

        public void setName(String name) {
          this.name = name;
        }

        public String getName() {
          return this.name;
        }

        public boolean isAddCol() {
          return this.addCol;
        }

        public String getSqlStmt() {
          return this.sqlStmt;
        }

        public String getValue() {
          return this.value;
        }
      }

      StringBuilder insertColName = new StringBuilder();

      StringBuilder insertValueStmt = new StringBuilder();

      StringBuilder updateSetStmt = new StringBuilder();

      StringBuilder updateWhereStmt = new StringBuilder();

      List<Column> stmtStructure = new LinkedList<Column>();

      for (IMetadataColumn column : columnList) {

        stmtStructure.add(new Column(column));
      }

      int counterOuter = 0;
      boolean firstKey = true;
      boolean firstNoneKey = true;
      boolean isfirstKey = true;
      for (Column colStmt : stmtStructure) {
        String suffix = ",";
        String colName = "\\\"" + colStmt.getName() + "\\\"";
        colStmt.setName(colName);
        if (colStmt.getColumn().isKey()) {
          if (isfirstKey) {
            isfirstKey = false;
          }
        }
        if (colStmt.isReplaced()) {
          List<Column> replacedColumns = colStmt.getReplacement();
          int counterReplace = 0;
          if (counterOuter == (stmtStructure.size() - 1)
              && counterReplace == (replacedColumns.size() - 1)) {
            suffix = "";
          }
          for (Column replacement : replacedColumns) {
            insertColName.append(replacement.getName() + suffix);
            insertValueStmt.append(replacement.getSqlStmt() + suffix);
            if (!colStmt.getColumn().isKey()) {
              if (!firstNoneKey) {
                updateSetStmt.append(",");
              } else {
                firstNoneKey = false;
              }
              updateSetStmt.append(replacement.getName());
              updateSetStmt.append(replacement.getSqlStmt());
            } else {
              if (!firstKey) {
                updateWhereStmt.append(" AND ");
              } else {
                firstKey = false;
              }
              updateWhereStmt.append(replacement.getName());
              updateWhereStmt.append(replacement.getSqlStmt());
            }
            counterReplace++;
          }
        } else {
          if (counterOuter == (stmtStructure.size() - 1)) {
            suffix = "";
          }
          if (colStmt.isAddCol()) {
            insertColName.append(colStmt.getName() + suffix);
            insertValueStmt.append(colStmt.getSqlStmt() + suffix);
            updateSetStmt.append(colStmt.getName());
            updateSetStmt.append(colStmt.getSqlStmt() + suffix);
          } else {
            insertColName.append(colStmt.getName() + suffix);
            insertValueStmt.append(colStmt.getValue() + suffix);
            if (!colStmt.getColumn().isKey()) {
              updateSetStmt.append(
                  colStmt.getName()
                      + "=\"+selectQueryColumnsName.split(\",\")[ "
                      + counterOuter
                      + "]+\""
                      + suffix);
            }
          }
        }
        counterOuter++;
      }

      if (("INSERT").equals(dataAction)) {

        stringBuffer.append(TEXT_38);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_39);
        stringBuffer.append(insertColName.toString());
        stringBuffer.append(TEXT_40);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_41);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_42);

      } else if (("UPDATE").equals(dataAction)) {

        stringBuffer.append(TEXT_43);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_44);
        stringBuffer.append(updateSetStmt.toString());
        stringBuffer.append(TEXT_45);

        if (CodeGenerationUtils.hasAlphaNumericCharacter(whereClause)) {

          stringBuffer.append(TEXT_46);
          stringBuffer.append(CodeGenerationUtils.replaceAllCrBySpace(whereClause));
          stringBuffer.append(TEXT_47);
        }

        stringBuffer.append(TEXT_48);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_49);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_50);

      } else if (("DELETE").equals(dataAction)) {

        stringBuffer.append(TEXT_51);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_52);

        if (CodeGenerationUtils.hasAlphaNumericCharacter(whereClause)) {

          stringBuffer.append(TEXT_53);
          stringBuffer.append(CodeGenerationUtils.replaceAllCrBySpace(whereClause));
          stringBuffer.append(TEXT_54);
        }

        stringBuffer.append(TEXT_55);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_56);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_57);
      }

      stringBuffer.append(TEXT_58);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_59);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_60);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_61);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_62);
    }
    if (dbtable != null && columnList != null) {
      if (("INSERT").equals(dataAction)) {

        stringBuffer.append(TEXT_63);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_64);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_65);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_66);

      } else if (("UPDATE").equals(dataAction)) {

        stringBuffer.append(TEXT_67);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_68);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_69);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_70);

      } else if (("DELETE").equals(dataAction)) {

        stringBuffer.append(TEXT_71);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_72);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_73);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_74);
      }
    }

    stringBuffer.append(TEXT_75);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_76);

    if (!useExistingConn) {

      stringBuffer.append(TEXT_77);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_78);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_79);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_80);
    }

    stringBuffer.append(TEXT_81);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_82);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_83);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_84);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_85);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_86);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_87);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_88);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_89);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_90);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_91);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_92);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_93);
    stringBuffer.append(TEXT_94);
    return stringBuffer.toString();
  }
  public String generate(Object argument) {
    final StringBuffer stringBuffer = new StringBuffer();

    // this util class use by set log4j debug paramters
    class DefaultLog4jCodeGenerateUtil {

      INode node = null;
      String cid = null;
      String dbproperties = null;
      String dbhost = null;
      String dbport = null;
      String dbname = null;
      String dbuser = null;
      String dbpwd = null;
      String connectionType = null;
      String dbVersion = null;
      String dbSchema = null;
      String useCursor = null;
      String trimAllColumn = null;
      String noNullValues = null;
      String dbquery = null;
      String table = null;
      boolean isLog4jEnabled = false;

      public void beforeComponentProcess(INode node) {
        this.node = node;
        init();
      }

      private void init() {
        cid = node.getUniqueName();
        dbproperties = ElementParameterParser.getValue(node, "__PROPERTIES__");
        dbhost = ElementParameterParser.getValue(node, "__HOST__");
        dbport = ElementParameterParser.getValue(node, "__PORT__");
        dbname = ElementParameterParser.getValue(node, "__DBNAME__");
        dbuser = ElementParameterParser.getValue(node, "__USER__");
        dbpwd = ElementParameterParser.getValue(node, "__PASS__");
        connectionType = ElementParameterParser.getValue(node, "__CONNECTION_TYPE__");
        dbVersion = ElementParameterParser.getValue(node, "__DB_VERSION__");
        dbSchema = ElementParameterParser.getValue(node, "__SCHEMA_DB__");
        useCursor = ElementParameterParser.getValue(node, "__USE_CURSOR__");
        trimAllColumn = ElementParameterParser.getValue(node, "__TRIM_ALL_COLUMN__");
        noNullValues = ElementParameterParser.getValue(node, "__NO_NULL_VALUES__");
        dbquery = ElementParameterParser.getValue(node, "__QUERY__");
        dbquery = dbquery.replaceAll("\n", " ");
        dbquery = dbquery.replaceAll("\r", " ");
        table = ElementParameterParser.getValue(node, "__TABLE__");
        isLog4jEnabled =
            ("true")
                .equals(ElementParameterParser.getValue(node.getProcess(), "__LOG4J_ACTIVATE__"));
      }

      public void infoComponentStart(INode node) {
        beforeComponentProcess(node);
        if (isLog4jEnabled) {

          stringBuffer.append(TEXT_1);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_2);
        }
      }

      public void initDbDebugRowBuffer() {
        if (isLog4jEnabled) {

          stringBuffer.append(TEXT_3);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_4);
        }
      }

      public void debugDriverClassName(String driverClass) {
        if (isLog4jEnabled) {

          stringBuffer.append(TEXT_5);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_6);
          stringBuffer.append(driverClass);
          stringBuffer.append(TEXT_7);
        }
      }

      public void debugConnectionParams(INode node, String driverClass) {
        beforeComponentProcess(node);
        generateConnectionParams();
        debugDriverClassName(driverClass);
        if (isLog4jEnabled) {

          stringBuffer.append(TEXT_8);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_9);
        }
      }

      public void dbConnectionParamsForELT(INode previousNode) {
        cid = previousNode.getUniqueName();
        dbhost = ElementParameterParser.getValue(previousNode, "__HOST__");
        dbname = ElementParameterParser.getValue(previousNode, "__DBNAME__");
        dbuser = ElementParameterParser.getValue(previousNode, "__USER__");
        dbpwd = ElementParameterParser.getValue(previousNode, "__PASS__");
      }

      public void additionalParameter(INode node) {
        String needtoConvet2Upper = ElementParameterParser.getValue(node, "__Convert_to_UPPer__");
      }

      public void generateAdditionalParameters(INode node) {
        additionalParameter(node);
      }

      public void generateConnectionParams() {
        if (isLog4jEnabled) {

          stringBuffer.append(TEXT_10);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_11);
          if (dbproperties != null
              && !("\"\"").equals(dbproperties)
              && !("").equals(dbproperties)) {
            stringBuffer.append(TEXT_12);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_13);
            stringBuffer.append(dbproperties);
            stringBuffer.append(TEXT_14);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_15);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_16);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_17);
          }
          stringBuffer.append(TEXT_18);
          if (dbhost != null && !("\"\"").equals(dbhost) && !("").equals(dbhost)) {
            stringBuffer.append(TEXT_19);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_20);
            stringBuffer.append(dbhost);
            stringBuffer.append(TEXT_21);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_22);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_23);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_24);
          }
          stringBuffer.append(TEXT_25);
          if (dbport != null && !("\"\"").equals(dbport) && !("").equals(dbport)) {
            stringBuffer.append(TEXT_26);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_27);
            stringBuffer.append(dbport.replace("'", "\""));
            stringBuffer.append(TEXT_28);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_29);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_30);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_31);
          }
          stringBuffer.append(TEXT_32);
          if (dbname != null && !("\"\"").equals(dbname) && !("").equals(dbname)) {
            stringBuffer.append(TEXT_33);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_34);
            stringBuffer.append(dbname);
            stringBuffer.append(TEXT_35);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_36);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_37);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_38);
          }
          stringBuffer.append(TEXT_39);
          if (dbuser != null && !("\"\"").equals(dbuser) && !("").equals(dbuser)) {
            stringBuffer.append(TEXT_40);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_41);
            stringBuffer.append(dbuser);
            stringBuffer.append(TEXT_42);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_43);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_44);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_45);
          }
          stringBuffer.append(TEXT_46);
          if (connectionType != null
              && !("\"\"").equals(connectionType)
              && !("").equals(connectionType)) {
            stringBuffer.append(TEXT_47);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_48);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_49);
            stringBuffer.append(connectionType);
            stringBuffer.append(TEXT_50);
          }
          stringBuffer.append(TEXT_51);
          if (dbVersion != null && !("\"\"").equals(dbVersion) && !("").equals(dbVersion)) {
            stringBuffer.append(TEXT_52);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_53);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_54);
            stringBuffer.append(dbVersion);
            stringBuffer.append(TEXT_55);
          }
          stringBuffer.append(TEXT_56);
          if (dbSchema != null && !("\"\"").equals(dbSchema) && !("").equals(dbSchema)) {
            stringBuffer.append(TEXT_57);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_58);
            stringBuffer.append(dbSchema);
            stringBuffer.append(TEXT_59);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_60);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_61);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_62);
          }
          stringBuffer.append(TEXT_63);
          if (useCursor != null && !("\"\"").equals(useCursor) && !("").equals(useCursor)) {
            stringBuffer.append(TEXT_64);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_65);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_66);
            stringBuffer.append(useCursor);
            stringBuffer.append(TEXT_67);
          }
          stringBuffer.append(TEXT_68);
          if (trimAllColumn != null
              && !("\"\"").equals(trimAllColumn)
              && !("").equals(trimAllColumn)) {
            stringBuffer.append(TEXT_69);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_70);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_71);
            stringBuffer.append(trimAllColumn);
            stringBuffer.append(TEXT_72);
          }
          stringBuffer.append(TEXT_73);
          if (noNullValues != null
              && !("\"\"").equals(noNullValues)
              && !("").equals(noNullValues)) {
            stringBuffer.append(TEXT_74);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_75);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_76);
            stringBuffer.append(noNullValues);
            stringBuffer.append(TEXT_77);
          }
          stringBuffer.append(TEXT_78);
          if (table != null && !("\"\"").equals(table) && !("").equals(table)) {
            stringBuffer.append(TEXT_79);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_80);
            stringBuffer.append(table);
            stringBuffer.append(TEXT_81);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_82);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_83);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_84);
          }
          stringBuffer.append(TEXT_85);
          if (dbquery != null && !("\"\"").equals(dbquery) && !("").equals(dbquery)) {
            stringBuffer.append(TEXT_86);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_87);
            stringBuffer.append(dbquery);
            stringBuffer.append(TEXT_88);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_89);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_90);
            stringBuffer.append(cid);
            stringBuffer.append(TEXT_91);
          }
          stringBuffer.append(TEXT_92);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_93);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_94);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_95);
        }
      }
    }

    DefaultLog4jCodeGenerateUtil log4jCodeGenerateUtil = new DefaultLog4jCodeGenerateUtil();

    stringBuffer.append(TEXT_96);

    CodeGeneratorArgument codeGenArgument = (CodeGeneratorArgument) argument;
    INode node = (INode) codeGenArgument.getArgument();

    boolean isLog4jEnabled =
        ("true").equals(ElementParameterParser.getValue(node.getProcess(), "__LOG4J_ACTIVATE__"));
    String cid = node.getUniqueName();

    String dbtable = null;
    String uniqueNameConnection = null;
    INode previousNode = null;

    String differenttable = ElementParameterParser.getValue(node, "__DIFFERENT_TABLE_NAME__");
    boolean useDifferentTable =
        "true".equals(ElementParameterParser.getValue(node, "__USE_DIFFERENT_TABLE__"));

    stringBuffer.append(TEXT_97);

    List<IConnection> connections = (List<IConnection>) node.getIncomingConnections();
    if (connections != null && connections.size() > 0 && connections.get(0) != null) {
      IConnection connection = connections.get(0);
      previousNode = connection.getSource();
      String previousComponentName = previousNode.getUniqueName();
      dbtable = connection.getName();
      uniqueNameConnection = connection.getUniqueName();

      stringBuffer.append(TEXT_98);
      stringBuffer.append(previousComponentName);
      stringBuffer.append(TEXT_99);
      stringBuffer.append(uniqueNameConnection);
      stringBuffer.append(TEXT_100);
      stringBuffer.append(previousComponentName);
      stringBuffer.append(TEXT_101);
      stringBuffer.append(uniqueNameConnection);
      stringBuffer.append(TEXT_102);
    }

    String dataAction = ElementParameterParser.getValue(node, "__DATA_ACTION__");

    String dbhost = null;
    String dbname = null;
    String dbuser = null;
    String dbpwd = null;
    boolean useExistingConn = false;
    if (previousNode != null) {
      dbhost = ElementParameterParser.getValue(previousNode, "__HOST__");
      dbname = ElementParameterParser.getValue(previousNode, "__DBNAME__");
      dbuser = ElementParameterParser.getValue(previousNode, "__USER__");
      dbpwd = ElementParameterParser.getValue(previousNode, "__PASS__");
      useExistingConn =
          ("true")
              .equals(ElementParameterParser.getValue(previousNode, "__USE_EXISTING_CONNECTION__"));
    }

    String whereClause = ElementParameterParser.getValue(node, "__WHERE_CLAUSE__");

    stringBuffer.append(TEXT_103);

    List<IMetadataColumn> columnList = null;

    List<IMetadataTable> metadatas = node.getMetadataList();
    if (metadatas != null && metadatas.size() > 0) {
      IMetadataTable metadata = metadatas.get(0);
      if (metadata != null) {
        columnList = metadata.getListColumns();
      }
    }

    stringBuffer.append(TEXT_104);

    if (useExistingConn) {
      String connection = ElementParameterParser.getValue(previousNode, "__CONNECTION__");
      String conn = "conn_" + connection;

      stringBuffer.append(TEXT_105);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_106);
      stringBuffer.append(conn);
      stringBuffer.append(TEXT_107);
      if (isLog4jEnabled) {
        stringBuffer.append(TEXT_108);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_109);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_110);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_111);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_112);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_113);
      }
    } else {

      stringBuffer.append(TEXT_114);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_115);
      stringBuffer.append(dbhost);
      stringBuffer.append(TEXT_116);
      stringBuffer.append(dbname);
      stringBuffer.append(TEXT_117);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_118);
      stringBuffer.append(dbuser);
      stringBuffer.append(TEXT_119);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_120);
      stringBuffer.append(dbpwd);
      stringBuffer.append(TEXT_121);

      log4jCodeGenerateUtil.debugConnectionParams(previousNode, "com.teradata.jdbc.TeraDriver");

      stringBuffer.append(TEXT_122);
      if (isLog4jEnabled) {
        stringBuffer.append(TEXT_123);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_124);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_125);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_126);
      }
      stringBuffer.append(TEXT_127);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_128);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_129);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_130);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_131);
      if (isLog4jEnabled) {
        stringBuffer.append(TEXT_132);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_133);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_134);
      }
    }

    stringBuffer.append(TEXT_135);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_136);

    class Column {

      String name;

      String sqlStmt;

      String value;

      boolean addCol;

      public Column(IMetadataColumn column) {
        String columname = column.getOriginalDbColumnName();
        if (columname != null && columname.trim().length() > 0) {
          this.name = columname;
        } else {
          this.name = column.getLabel();
        }
        this.sqlStmt = "=?";
        this.value = "?";
        this.addCol = false;
      }

      public String getName() {
        return this.name;
      }

      public boolean isAddCol() {
        return this.addCol;
      }

      public String getSqlStmt() {
        return this.sqlStmt;
      }

      public String getValue() {
        return this.value;
      }
    }

    if (columnList != null && columnList.size() > 0) {

      StringBuilder insertColName = new StringBuilder();

      StringBuilder insertValueStmt = new StringBuilder();

      StringBuilder updateSetStmt = new StringBuilder();

      List<Column> stmtStructure = new LinkedList<Column>();

      for (IMetadataColumn column : columnList) {

        stmtStructure.add(new Column(column));
      }

      int counterOuter = 0;

      for (Column colStmt : stmtStructure) {
        String suffix = ",";

        if (counterOuter == (stmtStructure.size() - 1)) {
          suffix = "";
        }
        if (colStmt.isAddCol()) {
          insertColName.append(colStmt.getName() + suffix);
          insertValueStmt.append(colStmt.getSqlStmt() + suffix);
          updateSetStmt.append(colStmt.getName());
          updateSetStmt.append(colStmt.getSqlStmt() + suffix);
        } else {
          insertColName.append(colStmt.getName() + suffix);
          insertValueStmt.append(colStmt.getValue() + suffix);
          updateSetStmt.append(
              colStmt.getName()
                  + "= src\"+ selectQueryColumnsName.split(\",\")[ "
                  + counterOuter
                  + "].substring(selectQueryColumnsName.split(\",\")["
                  + counterOuter
                  + "].indexOf(\".\"))+\""
                  + suffix);
        }
        counterOuter++;
      }

      stringBuffer.append(TEXT_137);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_138);
      stringBuffer.append(useDifferentTable ? differenttable : "\"" + dbtable + "\"");
      stringBuffer.append(TEXT_139);

      if (("INSERT").equals(dataAction)) {

        stringBuffer.append(TEXT_140);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_141);
        stringBuffer.append(insertColName.toString());
        stringBuffer.append(TEXT_142);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_143);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_144);

      } else if (("UPDATE").equals(dataAction)) {

        stringBuffer.append(TEXT_145);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_146);
        stringBuffer.append(updateSetStmt.toString());
        stringBuffer.append(TEXT_147);
        if (CodeGenerationUtils.hasAlphaNumericCharacter(whereClause)) {
          stringBuffer.append(TEXT_148);
          stringBuffer.append(CodeGenerationUtils.replaceAllCrBySpace(whereClause));
        }
        stringBuffer.append(TEXT_149);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_150);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_151);

      } else if (("DELETE").equals(dataAction)) {

        stringBuffer.append(TEXT_152);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_153);
        if (CodeGenerationUtils.hasAlphaNumericCharacter(whereClause)) {
          stringBuffer.append(TEXT_154);
          stringBuffer.append(CodeGenerationUtils.replaceAllCrBySpace(whereClause));
        }
        stringBuffer.append(TEXT_155);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_156);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_157);
      }

      stringBuffer.append(TEXT_158);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_159);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_160);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_161);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_162);
    }

    if (dbtable != null && columnList != null) {
      if (("INSERT").equals(dataAction)) {

        stringBuffer.append(TEXT_163);
        if (isLog4jEnabled) {
          stringBuffer.append(TEXT_164);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_165);
        }
        stringBuffer.append(TEXT_166);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_167);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_168);
        if (isLog4jEnabled) {
          stringBuffer.append(TEXT_169);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_170);
        }
        stringBuffer.append(TEXT_171);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_172);

      } else if (("UPDATE").equals(dataAction)) {

        stringBuffer.append(TEXT_173);
        if (isLog4jEnabled) {
          stringBuffer.append(TEXT_174);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_175);
        }
        stringBuffer.append(TEXT_176);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_177);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_178);
        if (isLog4jEnabled) {
          stringBuffer.append(TEXT_179);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_180);
        }
        stringBuffer.append(TEXT_181);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_182);

      } else if (("DELETE").equals(dataAction)) {

        stringBuffer.append(TEXT_183);
        if (isLog4jEnabled) {
          stringBuffer.append(TEXT_184);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_185);
        }
        stringBuffer.append(TEXT_186);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_187);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_188);
        if (isLog4jEnabled) {
          stringBuffer.append(TEXT_189);
          stringBuffer.append(cid);
          stringBuffer.append(TEXT_190);
        }
        stringBuffer.append(TEXT_191);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_192);
      }
    }

    stringBuffer.append(TEXT_193);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_194);

    if (!useExistingConn) {

      stringBuffer.append(TEXT_195);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_196);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_197);
      if (isLog4jEnabled) {
        stringBuffer.append(TEXT_198);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_199);
      }
      stringBuffer.append(TEXT_200);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_201);
      if (isLog4jEnabled) {
        stringBuffer.append(TEXT_202);
        stringBuffer.append(cid);
        stringBuffer.append(TEXT_203);
      }
      stringBuffer.append(TEXT_204);
    }

    stringBuffer.append(TEXT_205);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_206);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_207);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_208);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_209);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_210);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_211);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_212);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_213);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_214);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_215);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_216);
    stringBuffer.append(cid);
    stringBuffer.append(TEXT_217);
    if (isLog4jEnabled) {
      stringBuffer.append(TEXT_218);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_219);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_220);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_221);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_222);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_223);
      stringBuffer.append(cid);
      stringBuffer.append(TEXT_224);
    }
    stringBuffer.append(TEXT_225);
    return stringBuffer.toString();
  }