mem_memberbase_page_append.kjb 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <job>
  3. <name>mem_memberbase_page_append</name>
  4. <description/>
  5. <extended_description/>
  6. <job_version/>
  7. <job_status>0</job_status>
  8. <directory>/</directory>
  9. <created_user>-</created_user>
  10. <created_date>2019/05/26 19:54:10.397</created_date>
  11. <modified_user>-</modified_user>
  12. <modified_date>2019/05/26 19:54:10.397</modified_date>
  13. <parameters>
  14. </parameters>
  15. <slaveservers>
  16. </slaveservers>
  17. <job-log-table>
  18. <connection/>
  19. <schema/>
  20. <table/>
  21. <size_limit_lines/>
  22. <interval/>
  23. <timeout_days/>
  24. <field>
  25. <id>ID_JOB</id>
  26. <enabled>Y</enabled>
  27. <name>ID_JOB</name>
  28. </field>
  29. <field>
  30. <id>CHANNEL_ID</id>
  31. <enabled>Y</enabled>
  32. <name>CHANNEL_ID</name>
  33. </field>
  34. <field>
  35. <id>JOBNAME</id>
  36. <enabled>Y</enabled>
  37. <name>JOBNAME</name>
  38. </field>
  39. <field>
  40. <id>STATUS</id>
  41. <enabled>Y</enabled>
  42. <name>STATUS</name>
  43. </field>
  44. <field>
  45. <id>LINES_READ</id>
  46. <enabled>Y</enabled>
  47. <name>LINES_READ</name>
  48. </field>
  49. <field>
  50. <id>LINES_WRITTEN</id>
  51. <enabled>Y</enabled>
  52. <name>LINES_WRITTEN</name>
  53. </field>
  54. <field>
  55. <id>LINES_UPDATED</id>
  56. <enabled>Y</enabled>
  57. <name>LINES_UPDATED</name>
  58. </field>
  59. <field>
  60. <id>LINES_INPUT</id>
  61. <enabled>Y</enabled>
  62. <name>LINES_INPUT</name>
  63. </field>
  64. <field>
  65. <id>LINES_OUTPUT</id>
  66. <enabled>Y</enabled>
  67. <name>LINES_OUTPUT</name>
  68. </field>
  69. <field>
  70. <id>LINES_REJECTED</id>
  71. <enabled>Y</enabled>
  72. <name>LINES_REJECTED</name>
  73. </field>
  74. <field>
  75. <id>ERRORS</id>
  76. <enabled>Y</enabled>
  77. <name>ERRORS</name>
  78. </field>
  79. <field>
  80. <id>STARTDATE</id>
  81. <enabled>Y</enabled>
  82. <name>STARTDATE</name>
  83. </field>
  84. <field>
  85. <id>ENDDATE</id>
  86. <enabled>Y</enabled>
  87. <name>ENDDATE</name>
  88. </field>
  89. <field>
  90. <id>LOGDATE</id>
  91. <enabled>Y</enabled>
  92. <name>LOGDATE</name>
  93. </field>
  94. <field>
  95. <id>DEPDATE</id>
  96. <enabled>Y</enabled>
  97. <name>DEPDATE</name>
  98. </field>
  99. <field>
  100. <id>REPLAYDATE</id>
  101. <enabled>Y</enabled>
  102. <name>REPLAYDATE</name>
  103. </field>
  104. <field>
  105. <id>LOG_FIELD</id>
  106. <enabled>Y</enabled>
  107. <name>LOG_FIELD</name>
  108. </field>
  109. <field>
  110. <id>EXECUTING_SERVER</id>
  111. <enabled>N</enabled>
  112. <name>EXECUTING_SERVER</name>
  113. </field>
  114. <field>
  115. <id>EXECUTING_USER</id>
  116. <enabled>N</enabled>
  117. <name>EXECUTING_USER</name>
  118. </field>
  119. <field>
  120. <id>START_JOB_ENTRY</id>
  121. <enabled>N</enabled>
  122. <name>START_JOB_ENTRY</name>
  123. </field>
  124. <field>
  125. <id>CLIENT</id>
  126. <enabled>N</enabled>
  127. <name>CLIENT</name>
  128. </field>
  129. </job-log-table>
  130. <jobentry-log-table>
  131. <connection/>
  132. <schema/>
  133. <table/>
  134. <timeout_days/>
  135. <field>
  136. <id>ID_BATCH</id>
  137. <enabled>Y</enabled>
  138. <name>ID_BATCH</name>
  139. </field>
  140. <field>
  141. <id>CHANNEL_ID</id>
  142. <enabled>Y</enabled>
  143. <name>CHANNEL_ID</name>
  144. </field>
  145. <field>
  146. <id>LOG_DATE</id>
  147. <enabled>Y</enabled>
  148. <name>LOG_DATE</name>
  149. </field>
  150. <field>
  151. <id>JOBNAME</id>
  152. <enabled>Y</enabled>
  153. <name>TRANSNAME</name>
  154. </field>
  155. <field>
  156. <id>JOBENTRYNAME</id>
  157. <enabled>Y</enabled>
  158. <name>STEPNAME</name>
  159. </field>
  160. <field>
  161. <id>LINES_READ</id>
  162. <enabled>Y</enabled>
  163. <name>LINES_READ</name>
  164. </field>
  165. <field>
  166. <id>LINES_WRITTEN</id>
  167. <enabled>Y</enabled>
  168. <name>LINES_WRITTEN</name>
  169. </field>
  170. <field>
  171. <id>LINES_UPDATED</id>
  172. <enabled>Y</enabled>
  173. <name>LINES_UPDATED</name>
  174. </field>
  175. <field>
  176. <id>LINES_INPUT</id>
  177. <enabled>Y</enabled>
  178. <name>LINES_INPUT</name>
  179. </field>
  180. <field>
  181. <id>LINES_OUTPUT</id>
  182. <enabled>Y</enabled>
  183. <name>LINES_OUTPUT</name>
  184. </field>
  185. <field>
  186. <id>LINES_REJECTED</id>
  187. <enabled>Y</enabled>
  188. <name>LINES_REJECTED</name>
  189. </field>
  190. <field>
  191. <id>ERRORS</id>
  192. <enabled>Y</enabled>
  193. <name>ERRORS</name>
  194. </field>
  195. <field>
  196. <id>RESULT</id>
  197. <enabled>Y</enabled>
  198. <name>RESULT</name>
  199. </field>
  200. <field>
  201. <id>NR_RESULT_ROWS</id>
  202. <enabled>Y</enabled>
  203. <name>NR_RESULT_ROWS</name>
  204. </field>
  205. <field>
  206. <id>NR_RESULT_FILES</id>
  207. <enabled>Y</enabled>
  208. <name>NR_RESULT_FILES</name>
  209. </field>
  210. <field>
  211. <id>LOG_FIELD</id>
  212. <enabled>N</enabled>
  213. <name>LOG_FIELD</name>
  214. </field>
  215. <field>
  216. <id>COPY_NR</id>
  217. <enabled>N</enabled>
  218. <name>COPY_NR</name>
  219. </field>
  220. </jobentry-log-table>
  221. <channel-log-table>
  222. <connection/>
  223. <schema/>
  224. <table/>
  225. <timeout_days/>
  226. <field>
  227. <id>ID_BATCH</id>
  228. <enabled>Y</enabled>
  229. <name>ID_BATCH</name>
  230. </field>
  231. <field>
  232. <id>CHANNEL_ID</id>
  233. <enabled>Y</enabled>
  234. <name>CHANNEL_ID</name>
  235. </field>
  236. <field>
  237. <id>LOG_DATE</id>
  238. <enabled>Y</enabled>
  239. <name>LOG_DATE</name>
  240. </field>
  241. <field>
  242. <id>LOGGING_OBJECT_TYPE</id>
  243. <enabled>Y</enabled>
  244. <name>LOGGING_OBJECT_TYPE</name>
  245. </field>
  246. <field>
  247. <id>OBJECT_NAME</id>
  248. <enabled>Y</enabled>
  249. <name>OBJECT_NAME</name>
  250. </field>
  251. <field>
  252. <id>OBJECT_COPY</id>
  253. <enabled>Y</enabled>
  254. <name>OBJECT_COPY</name>
  255. </field>
  256. <field>
  257. <id>REPOSITORY_DIRECTORY</id>
  258. <enabled>Y</enabled>
  259. <name>REPOSITORY_DIRECTORY</name>
  260. </field>
  261. <field>
  262. <id>FILENAME</id>
  263. <enabled>Y</enabled>
  264. <name>FILENAME</name>
  265. </field>
  266. <field>
  267. <id>OBJECT_ID</id>
  268. <enabled>Y</enabled>
  269. <name>OBJECT_ID</name>
  270. </field>
  271. <field>
  272. <id>OBJECT_REVISION</id>
  273. <enabled>Y</enabled>
  274. <name>OBJECT_REVISION</name>
  275. </field>
  276. <field>
  277. <id>PARENT_CHANNEL_ID</id>
  278. <enabled>Y</enabled>
  279. <name>PARENT_CHANNEL_ID</name>
  280. </field>
  281. <field>
  282. <id>ROOT_CHANNEL_ID</id>
  283. <enabled>Y</enabled>
  284. <name>ROOT_CHANNEL_ID</name>
  285. </field>
  286. </channel-log-table>
  287. <pass_batchid>N</pass_batchid>
  288. <shared_objects_file/>
  289. <entries>
  290. <entry>
  291. <name>设置变量930</name>
  292. <description/>
  293. <type>SET_VARIABLES</type>
  294. <attributes/>
  295. <replacevars>Y</replacevars>
  296. <filename/>
  297. <file_variable_type>JVM</file_variable_type>
  298. <fields>
  299. <field>
  300. <variable_name>page</variable_name>
  301. <variable_value>1</variable_value>
  302. <variable_type>JVM</variable_type>
  303. </field>
  304. <field>
  305. <variable_name>pagesize</variable_name>
  306. <variable_value>50</variable_value>
  307. <variable_type>JVM</variable_type>
  308. </field>
  309. <field>
  310. <variable_name>pagecount</variable_name>
  311. <variable_value>930</variable_value>
  312. <variable_type>JVM</variable_type>
  313. </field>
  314. </fields>
  315. <parallel>N</parallel>
  316. <draw>Y</draw>
  317. <nr>0</nr>
  318. <xloc>304</xloc>
  319. <yloc>144</yloc>
  320. <attributes_kjc/>
  321. </entry>
  322. <entry>
  323. <name>Start</name>
  324. <description/>
  325. <type>SPECIAL</type>
  326. <attributes/>
  327. <start>Y</start>
  328. <dummy>N</dummy>
  329. <repeat>N</repeat>
  330. <schedulerType>0</schedulerType>
  331. <intervalSeconds>0</intervalSeconds>
  332. <intervalMinutes>60</intervalMinutes>
  333. <hour>12</hour>
  334. <minutes>0</minutes>
  335. <weekDay>1</weekDay>
  336. <DayOfMonth>1</DayOfMonth>
  337. <parallel>N</parallel>
  338. <draw>Y</draw>
  339. <nr>0</nr>
  340. <xloc>96</xloc>
  341. <yloc>176</yloc>
  342. <attributes_kjc/>
  343. </entry>
  344. <entry>
  345. <name>page&lt;=pagecount</name>
  346. <description/>
  347. <type>SIMPLE_EVAL</type>
  348. <attributes/>
  349. <valuetype>variable</valuetype>
  350. <fieldname/>
  351. <variablename>page</variablename>
  352. <fieldtype>number</fieldtype>
  353. <mask/>
  354. <comparevalue>${pagecount}</comparevalue>
  355. <minvalue/>
  356. <maxvalue/>
  357. <successcondition>equal</successcondition>
  358. <successnumbercondition>smallequal</successnumbercondition>
  359. <successbooleancondition>false</successbooleancondition>
  360. <successwhenvarset>N</successwhenvarset>
  361. <parallel>N</parallel>
  362. <draw>Y</draw>
  363. <nr>0</nr>
  364. <xloc>432</xloc>
  365. <yloc>208</yloc>
  366. <attributes_kjc/>
  367. </entry>
  368. <entry>
  369. <name>JavaScript</name>
  370. <description/>
  371. <type>EVAL</type>
  372. <attributes/>
  373. <script>var page;
  374. page = parent_job.getVariable("page");
  375. var pagecount = parent_job.getVariable("pagecount");
  376. if(page == pagecount){
  377. false;
  378. }else{
  379. page++;
  380. parent_job.setVariable("page",page);
  381. true;
  382. }</script>
  383. <parallel>N</parallel>
  384. <draw>Y</draw>
  385. <nr>0</nr>
  386. <xloc>384</xloc>
  387. <yloc>48</yloc>
  388. <attributes_kjc/>
  389. </entry>
  390. <entry>
  391. <name>转换</name>
  392. <description/>
  393. <type>TRANS</type>
  394. <attributes/>
  395. <specification_method>filename</specification_method>
  396. <trans_object_id/>
  397. <filename>${Internal.Entry.Current.Directory}/mem_memberbase_delete_not_exist.ktr</filename>
  398. <transname/>
  399. <arg_from_previous>N</arg_from_previous>
  400. <params_from_previous>N</params_from_previous>
  401. <exec_per_row>N</exec_per_row>
  402. <clear_rows>N</clear_rows>
  403. <clear_files>N</clear_files>
  404. <set_logfile>N</set_logfile>
  405. <logfile/>
  406. <logext/>
  407. <add_date>N</add_date>
  408. <add_time>N</add_time>
  409. <loglevel>Basic</loglevel>
  410. <cluster>N</cluster>
  411. <slave_server_name/>
  412. <set_append_logfile>N</set_append_logfile>
  413. <wait_until_finished>Y</wait_until_finished>
  414. <follow_abort_remote>N</follow_abort_remote>
  415. <create_parent_folder>N</create_parent_folder>
  416. <logging_remote_work>N</logging_remote_work>
  417. <run_configuration>Pentaho local</run_configuration>
  418. <parameters>
  419. <pass_all_parameters>Y</pass_all_parameters>
  420. </parameters>
  421. <parallel>N</parallel>
  422. <draw>Y</draw>
  423. <nr>0</nr>
  424. <xloc>560</xloc>
  425. <yloc>160</yloc>
  426. <attributes_kjc/>
  427. </entry>
  428. <entry>
  429. <name>成功</name>
  430. <description/>
  431. <type>SUCCESS</type>
  432. <attributes/>
  433. <parallel>N</parallel>
  434. <draw>Y</draw>
  435. <nr>0</nr>
  436. <xloc>688</xloc>
  437. <yloc>272</yloc>
  438. <attributes_kjc/>
  439. </entry>
  440. </entries>
  441. <hops>
  442. <hop>
  443. <from>Start</from>
  444. <to>设置变量930</to>
  445. <from_nr>0</from_nr>
  446. <to_nr>0</to_nr>
  447. <enabled>Y</enabled>
  448. <evaluation>Y</evaluation>
  449. <unconditional>Y</unconditional>
  450. </hop>
  451. <hop>
  452. <from>page&lt;=pagecount</from>
  453. <to>转换</to>
  454. <from_nr>0</from_nr>
  455. <to_nr>0</to_nr>
  456. <enabled>Y</enabled>
  457. <evaluation>Y</evaluation>
  458. <unconditional>N</unconditional>
  459. </hop>
  460. <hop>
  461. <from>设置变量930</from>
  462. <to>page&lt;=pagecount</to>
  463. <from_nr>0</from_nr>
  464. <to_nr>0</to_nr>
  465. <enabled>Y</enabled>
  466. <evaluation>Y</evaluation>
  467. <unconditional>N</unconditional>
  468. </hop>
  469. <hop>
  470. <from>page&lt;=pagecount</from>
  471. <to>成功</to>
  472. <from_nr>0</from_nr>
  473. <to_nr>0</to_nr>
  474. <enabled>Y</enabled>
  475. <evaluation>N</evaluation>
  476. <unconditional>N</unconditional>
  477. </hop>
  478. <hop>
  479. <from>转换</from>
  480. <to>JavaScript</to>
  481. <from_nr>0</from_nr>
  482. <to_nr>0</to_nr>
  483. <enabled>Y</enabled>
  484. <evaluation>Y</evaluation>
  485. <unconditional>N</unconditional>
  486. </hop>
  487. <hop>
  488. <from>JavaScript</from>
  489. <to>page&lt;=pagecount</to>
  490. <from_nr>0</from_nr>
  491. <to_nr>0</to_nr>
  492. <enabled>Y</enabled>
  493. <evaluation>Y</evaluation>
  494. <unconditional>N</unconditional>
  495. </hop>
  496. </hops>
  497. <notepads>
  498. </notepads>
  499. <attributes>
  500. <group>
  501. <name>METASTORE.pentaho</name>
  502. <attribute>
  503. <key>Default Run Configuration</key>
  504. <value>{"namespace":"pentaho","id":"Default Run Configuration","name":"Default Run Configuration","description":"Defines a default run configuration","metaStoreName":null}</value>
  505. </attribute>
  506. </group>
  507. <group>
  508. <name>{"_":"Embedded MetaStore Elements","namespace":"pentaho","type":"Default Run Configuration"}</name>
  509. <attribute>
  510. <key>Pentaho local</key>
  511. <value>{"children":[{"children":[],"id":"server","value":null},{"children":[],"id":"clustered","value":"N"},{"children":[],"id":"name","value":"Pentaho local"},{"children":[],"id":"description","value":null},{"children":[],"id":"pentaho","value":"N"},{"children":[],"id":"readOnly","value":"Y"},{"children":[],"id":"sendResources","value":"N"},{"children":[],"id":"logRemoteExecutionLocally","value":"N"},{"children":[],"id":"remote","value":"N"},{"children":[],"id":"local","value":"Y"},{"children":[],"id":"showTransformations","value":"N"}],"id":"Pentaho local","value":null,"name":"Pentaho local","owner":null,"ownerPermissionsList":[]}</value>
  512. </attribute>
  513. </group>
  514. </attributes>
  515. </job>