Advertisement
josema0890

matching 1:n cursor rutinizado

Mar 22nd, 2018
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.27 KB | None | 0 0
  1. MATCHING 1:N CON REPOSICIONAMIENTO
  2.  
  3. 1000-INICIO
  4. 1100-ABRIRFICHEROS
  5. 1200-GESTIONAR-REPOS
  6. 1000-INICIO-EXIT
  7. .
  8.  
  9. 1100-ABRIR-FICHEROS
  10. ***************************************
  11. 1200-GESTIONAR-REPOS
  12. MOVE 'PGM' TO D-PGM
  13. SELECT ESTADO,
  14. REG
  15. INTO :D-ESTADO,
  16. :D-REG
  17. FROM DAREPOS
  18. WHERE PGM = :D-PGM
  19. EVALUATE SQLCODE
  20. WHEN 0
  21. EVALUATE D-ESTADO
  22. WHEN 'OK'
  23. PERFORM LEER-ENTRADA1
  24. PERFORM LEER-ENTRADA2
  25. WHEN 'KO'
  26. MOVE D-REG-TEXT TO CLAVE-REPOS
  27. PERFORM LEER-ENTRADA1
  28. UNTIL COD-MEDICO = COD-MED-M
  29.  
  30. PERFORM LEER-ENTRADA2
  31. UNTIL COD-MEDICO >= COD-MED-P AND
  32. ID-PAC > COD-PAC-P
  33.  
  34. IF INDICADOR = 'S'
  35. SET SI-COINCIDE TO TRUE
  36. ELSE
  37. SET NO-COINCIDE TO TRUE
  38. END-IF
  39. WHEN OTHER
  40. DISPLAY 'ERROR FATAL'
  41. END-EVALUATE
  42. ***************************************
  43. 2000-PROCESO
  44. EVALUATE TRUE
  45. WHEN KMA = KMO
  46. SET SW-SI-COINCIDE TO TRUE
  47. PERFORM LEER-ENTRADA2
  48. WHEN KMA < KMO
  49. IF NO-COINCIDE
  50. ESCRIBIR SALIDA
  51. DELETE MEDICOS
  52. COMMIT
  53. MOVE CLAVE-REPOS TO D-REG-TEXT
  54. UPDATE DAREPOS
  55. END-IF
  56. PERFORM LEER-ENTRADA1
  57. WHEN KMA > KMO
  58. UPDATE PACIENTES
  59. COMMIT
  60. MOVE CLAVE-REPOS TO D-REG-TEXT
  61. UPDATE DAREPOS
  62. WHEN OTHER
  63. DISPLAY 'ERROR FATAL'
  64. .
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement