{
  "dBType" : "POSTGRESQL",
  "name" : "PostgreSQL",
  "getPSDEDataQueryCodeExps" : [ {
    "expression" : "t1.CREATEDATE",
    "name" : "CREATEDATE"
  }, {
    "expression" : "t1.CREATEMAN",
    "name" : "CREATEMAN"
  }, {
    "expression" : "t1.DATE",
    "name" : "DATE"
  }, {
    "expression" : "t1.IBIZSAMPLE0009ID",
    "name" : "IBIZSAMPLE0009ID"
  }, {
    "expression" : "t1.IBIZSAMPLE0009NAME",
    "name" : "IBIZSAMPLE0009NAME"
  }, {
    "expression" : "t1.KP",
    "name" : "KP"
  }, {
    "expression" : "t1.PD",
    "name" : "PD"
  }, {
    "expression" : "t1.PG",
    "name" : "PG"
  }, {
    "expression" : "t1.SP",
    "name" : "SP"
  }, {
    "expression" : "t1.SPMC",
    "name" : "SPMC"
  }, {
    "expression" : "CONCAT(t1.KP,\";\",t1.PG,\";\",t1.PD,\";\",t1.SP)",
    "name" : "TJ"
  }, {
    "expression" : "t1.UPDATEDATE",
    "name" : "UPDATEDATE"
  }, {
    "expression" : "t1.UPDATEMAN",
    "name" : "UPDATEMAN"
  } ],
  "queryCode" : "SELECT\nt1.CREATEDATE,\nt1.CREATEMAN,\nt1.DATE,\nt1.IBIZSAMPLE0009ID,\nt1.IBIZSAMPLE0009NAME,\nt1.KP,\nt1.PD,\nt1.PG,\nt1.SP,\nt1.SPMC,\nCONCAT(t1.KP,\";\",t1.PG,\";\",t1.PD,\";\",t1.SP) AS TJ,\nt1.UPDATEDATE,\nt1.UPDATEMAN\nFROM T_IBIZSAMPLE0009 t1 \n",
  "id" : "PSMODULES/Sample/PSDATAENTITIES/IBIZSample0009/PSDEDATAQUERIES/Default/PSDEDQCODES/POSTGRESQL.json"
}