{
  "dBType" : "MYSQL5",
  "mOSFilePath" : "psmodules/Sample/psdataentities/IBIZSAMPLE0009/psdedataqueries/DEFAULT/psdedqcodes/MYSQL5",
  "name" : "MySQL5",
  "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",
  "rTMOSFilePath" : "psmodules/Sample/psdataentities/IBIZSAMPLE0009/psdedataqueries/DEFAULT/psdedqcodes/MYSQL5",
  "id" : "PSMODULES/Sample/PSDATAENTITIES/IBIZSample0009/PSDEDATAQUERIES/Default/PSDEDQCODES/MYSQL5.json"
}