midrange.com code scratchpad
Name:
Store product table with sample data.
Scriptlanguage:
Plain Text
Tabwidth:
4
Date:
09/08/2008 07:16:10 pm
IP:
Logged
Description:
Definition what product # is okay for a store to receive.
Order form # is basically the product #.
Assume that there are no gaps in the product code#
Code:
  1.  
  2. CREATE TABLE PGMT/DTKSTRPF ( 
  3.     STOF# DECIMAL(10, 0) NOT NULL DEFAULT 0 , 
  4.     STSTORE DECIMAL(3, 0) NOT NULL DEFAULT 0)   
  5.       
  6.     RCDFMT DTKSTRRF   ; 
  7.   
  8. LABEL ON TABLE PGMT/DTKSTRPF 
  9.     IS 'Order Form Stores Auth. to Order.' ; 
  10.   
  11. LABEL ON COLUMN PGMT/DTKSTRPF 
  12. ( STOF# IS 'ORDER FORM#' , 
  13.     STSTORE IS 'Store               Number' ) ; 
  14.   
  15. LABEL ON COLUMN PGMT/DTKSTRPF 
  16. ( STOF# TEXT IS 'ORDER FORM#' , 
  17.     STSTORE TEXT IS 'Store Number' ) ;
  18.  
  19. Insert into PGMT/DTKSTRPF (STOF#, STSTORE)
  20. Values
  21. (2           ,1    ),
  22. (2           ,2    ),
  23. (2           ,3    ),
  24. (2           ,4    ),
  25. (2           ,5    ),
  26. (2           ,6    ),
  27. (2           ,7    ),
  28. (2           ,9    ),
  29. (2           ,10   ),
  30. (2           ,11   ),
  31. (2           ,12   ),
  32. (2           ,13   ),
  33. (2           ,14   ),
  34. (2           ,15   ),
  35. (2           ,17   ),
  36. (2           ,18   ),
  37. (2           ,20   ),
  38. (2           ,21   ),
  39. (2           ,22   ),
  40. (2           ,23   ),
  41. (2           ,25   ),
  42. (2           ,26   ),
  43. (2           ,28   ),
  44. (2           ,29   ),
  45. (2           ,30   ),
  46. (2           ,31   ),
  47. (2           ,34   ),
  48. (2           ,36   ),
  49. (2           ,37   ),
  50. (2           ,38   ),
  51. (2           ,39   ),
  52. (2           ,40   ),
  53. (2           ,41   ),
  54. (2           ,42   ),
  55. (2           ,43   ),
  56. (2           ,44   ),
  57. (2           ,45   ),
  58. (2           ,47   ),
  59. (2           ,48   ),
  60. (2           ,49   ),
  61. (2           ,50   ),
  62. (2           ,51   ),
  63. (2           ,52   ),
  64. (2           ,53   ),
  65. (2           ,55   ),
  66. (2           ,56   ),
  67. (2           ,57   ),
  68. (2           ,58   ),
  69. (2           ,59   ),
  70. (2           ,60   ),
  71. (6           ,1    ),
  72. (6           ,3    ),
  73. (6           ,4    ),
  74. (6           ,6    ),
  75. (6           ,9    ),
  76. (6           ,11   ),
  77. (6           ,13   ),
  78. (6           ,14   ),
  79. (6           ,15   ),
  80. (6           ,18   ),
  81. (6           ,20   ),
  82. (6           ,22   ),
  83. (6           ,23   ),
  84. (6           ,27   ),
  85. (6           ,28   ),
  86. (6           ,29   ),
  87. (6           ,30   ),
  88. (6           ,34   ),
  89. (6           ,38   ),
  90. (6           ,39   ),
  91. (6           ,40   ),
  92. (6           ,41   ),
  93. (6           ,44   ),
  94. (6           ,47   ),
  95. (6           ,48   ),
  96. (6           ,49   ),
  97. (6           ,51   ),
  98. (6           ,64   ),
  99. (8           ,58   ),
  100. (10          ,1    ),
  101. (10          ,11   ),
  102. (11          ,7    ),
  103. (11          ,10   ),
  104. (11          ,11   ),
  105. (11          ,12   ),
  106. (11          ,17   ),
  107. (11          ,21   ),
  108. (11          ,24   ),
  109. (11          ,25   ),
  110. (11          ,26   ),
  111. (11          ,31   ),
  112. (11          ,36   ),
  113. (11          ,37   ),
  114. (11          ,52   ),
  115. (11          ,53   )
  116.  
  117.  
© 2004-2019 by midrange.com generated in 0.004s valid xhtml & css