Results 1 to 14 of 14
  1. #1
    Join Date
    Jun 2012
    Posts
    32

    Unanswered: Create table with default value error ?

    Hello I am creating a table and want the yeardate field with date as a data type to have a default value so that if any user does not enter any value in the date field it should take a default value that is being set ?


    Code:
    create table company (
    compno varchar(10), compname varchar(30), address varchar(30), phoneno varchar(10), contactnme varchar(20), yeardate date default '20-03-2011')
    ERROR NOTE: DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0574N DEFAULT value or IDENTITY attribute value is not valid for column
    "YEARDATE" in table "MARSHELL.COMPANY". Reason code: "-180". SQLSTATE=42894

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Code:
    SQL0180N  The syntax of the string representation of a datetime value is
          incorrect.
    
    Explanation:
    
    The string representation of a date, time, or timestamp value does not
    conform to the syntax for the specified or implied data type.
    
    The statement cannot be processed.
    
    User response:
    
    Ensure that the syntax of the date, time, or timestamp value conforms to
    the syntax for its data type. If the string is not intended to be a
    date, time, or timestamp value, ensure that when used, it does not imply
    that data type.
    
    Federated system users: the problem might be due to a date/time
    representation problem at the data source. If the reason is unknown,
    isolate the problem to the data source failing the request
    Troubleshooting Guide and examine the date/time representation
    restrictions for that data source.
    
     sqlcode: -180
    
     sqlstate: 22007
    Andy

  3. #3
    Join Date
    Jun 2012
    Posts
    32
    Code:
    create table company (
    compno varchar(10), compname varchar(30), address varchar(30), phoneno varchar(10), contactnme varchar(20), yeardate date with default )

    this runs fine but cant i specify a specific date as a parameter ?

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Did you not read the error documentation I posted? Your string representation of a date is invalid. Just fix it.

    Andy

  5. #5
    Join Date
    Jun 2012
    Posts
    32
    Got the syntax but my question is if any insert operation is done and if we do not specific the yeardate field it should take the default values right ? but when i did an insert operation without the date year field i got the error message?


    Code:
    create table company (
    compno varchar(10), compname varchar(30), address varchar(30), phoneno varchar(10), contactnme varchar(20), yeardate date default '2011-12-03' )

    Code:
    C:\Program Files\IBM\SQLLIB\BIN>db2 insert into company values('0002','Mouse Inc
    .',' 1 Mousey Road, DisneyLand','111111','Mickey Mouse')
    DB21034E  The command was processed as an SQL statement because it was not a
    valid Command Line Processor command.  During SQL processing it returned:
    SQL0117N  The number of values assigned is not the same as the number of
    specified or implied columns or variables.  SQLSTATE=42802

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Read the error message on your INSERT and see if you can figure it out...

    Andy

  7. #7
    Join Date
    Jun 2012
    Posts
    32
    I do understand that it requires the dateyear value as well in the insert statement as the number of column does not match ? I will explain to you what i am trying to do I created a table Py_EMP_HC using table portioning

    Code:
    PARTITION BY RANGE(YEARDATE NULLS LAST)
    	( STARTING FROM ('12/01/2010') INCLUSIVE 
    	  ENDING AT ('11/30/2030') INCLUSIVE 
    	  EVERY (1 YEARS)
    	)
    this table did not have a column YEARDATE before so i added it now and partioned the table based on the date. i want to load date into table from Py_EMP_HC from the server into the Py_EMP_HC locally which i did using the export import of ixf file. But it does not insert the data from the .ixf file because there is no dateyear value in that ixf file so what i thought of is to give a default value to that field so that i can load the data into the table ?

    I hope you understand what i am trying to do.

  8. #8
    Join Date
    Jun 2012
    Posts
    32
    export to C:\temp_PY.ixf of ixf select * from db2inst1.PY_EMP_HC

    import from C:\temp_PY.ixf of ixf insert into db2inst1.PY_EMP_HC

    since the previous table did not have a partition and year date column so importing the .ixf file does not happen because of the dateyear field not present in the previous table so i thought of giving a single default value to that column ?

  9. #9
    Join Date
    Jun 2012
    Posts
    32
    Code:
    SQL3148W  A row from the input file was not inserted into the table.  SQLCODE
    "-327" was returned.
    
    SQL0327N  The row cannot be inserted into table "DB2INST1.PY_EMP_HC" because
    it is outside the bounds of the defined data partition ranges.  SQLSTATE=22525
    
    SQL3185W  The previous error occurred while processing data from row "24202"
    of the input file.
    
    SQL3110N  The utility has completed processing.  "24202" rows were read from
    the input file.
    
    SQL3221W  ...Begin COMMIT WORK. Input Record Count = "24202".
    
    SQL3222W  ...COMMIT of any database changes was successful.
    
    SQL3149N  "24202" rows were processed from the input file.  "0" rows were
    successfully inserted into the table.  "24202" rows were rejected.
    
    
    Number of rows read         = 24202
    Number of rows skipped      = 0
    Number of rows inserted     = 0
    Number of rows updated      = 0
    Number of rows rejected     = 24202
    Number of rows committed    = 24202

  10. #10
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Hint: you can specify the column names you are using on the insert statement...

    Andy

  11. #11
    Join Date
    Jun 2012
    Posts
    32
    There are almost 250 columns in that table PY_EMP_HC .... so i was first trying it on a small table to see if it work . So i dont think so that hint will work ?

    here the table definition :

    Code:
    CREATE TABLE "DB2INST1"."PY_EMP_HC" (
    		"ROW_ID" VARCHAR(50) NOT NULL, 
    		"PYDECHC" DOUBLE, 
    		"CYJANHC" DOUBLE, 
    		"CYFEBHC" DOUBLE, 
    		"CYMARHC" DOUBLE, 
    		"CYAPRHC" DOUBLE, 
    		"CYMAYHC" DOUBLE, 
    		"CYJUNHC" DOUBLE, 
    		"CYJULHC" DOUBLE, 
    		"CYAUGHC" DOUBLE, 
    		"CYSEPHC" DOUBLE, 
    		"CYOCTHC" DOUBLE, 
    		"CYNOVHC" DOUBLE, 
    		"CYDECHC" DOUBLE, 
    		"PYDECMT" VARCHAR(150), 
    		"CYJANMT" VARCHAR(150), 
    		"CYFEBMT" VARCHAR(150), 
    		"CYMARMT" VARCHAR(150), 
    		"CYAPRMT" VARCHAR(150), 
    		"CYMAYMT" VARCHAR(150), 
    		"CYJUNMT" VARCHAR(150), 
    		"CYJULMT" VARCHAR(150), 
    		"CYAUGMT" VARCHAR(150), 
    		"CYSEPMT" VARCHAR(150), 
    		"CYOCTMT" VARCHAR(150), 
    		"CYNOVMT" VARCHAR(150), 
    		"CYDECMT" VARCHAR(150), 
    		"PYDECMD" VARCHAR(150), 
    		"CYJANMD" VARCHAR(150), 
    		"CYFEBMD" VARCHAR(150), 
    		"CYMARMD" VARCHAR(150), 
    		"CYAPRMD" VARCHAR(150), 
    		"CYMAYMD" VARCHAR(150), 
    		"CYJUNMD" VARCHAR(150), 
    		"CYJULMD" VARCHAR(150), 
    		"CYAUGMD" VARCHAR(150), 
    		"CYSEPMD" VARCHAR(150), 
    		"CYOCTMD" VARCHAR(150), 
    		"CYNOVMD" VARCHAR(150), 
    		"CYDECMD" VARCHAR(150), 
    		"PYDECED" VARCHAR(150), 
    		"CYJANED" VARCHAR(150), 
    		"CYFEBED" VARCHAR(150), 
    		"CYMARED" VARCHAR(150), 
    		"CYAPRED" VARCHAR(150), 
    		"CYMAYED" VARCHAR(150), 
    		"CYJUNED" VARCHAR(150), 
    		"CYJULED" VARCHAR(150), 
    		"CYAUGED" VARCHAR(150), 
    		"CYSEPED" VARCHAR(150), 
    		"CYOCTED" VARCHAR(150), 
    		"CYNOVED" VARCHAR(150), 
    		"CYDECED" VARCHAR(150), 
    		"HRIWPYDECMT" VARCHAR(150), 
    		"HRIWCYJANMT" VARCHAR(150), 
    		"HRIWCYFEBMT" VARCHAR(150), 
    		"HRIWCYMARMT" VARCHAR(150), 
    		"HRIWCYAPRMT" VARCHAR(150), 
    		"HRIWCYMAYMT" VARCHAR(150), 
    		"HRIWCYJUNMT" VARCHAR(150), 
    		"HRIWCYJULMT" VARCHAR(150), 
    		"HRIWCYAUGMT" VARCHAR(150), 
    		"HRIWCYSEPMT" VARCHAR(150), 
    		"HRIWCYOCTMT" VARCHAR(150), 
    		"HRIWCYNOVMT" VARCHAR(150), 
    		"HRIWCYDECMT" VARCHAR(150), 
    		"HRIWPYDECHC" DOUBLE, 
    		"HRIWCYJANHC" DOUBLE, 
    		"HRIWCYFEBHC" DOUBLE, 
    		"HRIWCYMARHC" DOUBLE, 
    		"HRIWCYAPRHC" DOUBLE, 
    		"HRIWCYMAYHC" DOUBLE, 
    		"HRIWCYJUNHC" DOUBLE, 
    		"HRIWCYJULHC" DOUBLE, 
    		"HRIWCYAUGHC" DOUBLE, 
    		"HRIWCYSEPHC" DOUBLE, 
    		"HRIWCYOCTHC" DOUBLE, 
    		"HRIWCYNOVHC" DOUBLE, 
    		"HRIWCYDECHC" DOUBLE, 
    		"HRIWPYDECET" VARCHAR(150), 
    		"HRIWCYJANET" VARCHAR(150), 
    		"HRIWCYFEBET" VARCHAR(150), 
    		"HRIWCYMARET" VARCHAR(150), 
    		"HRIWCYAPRET" VARCHAR(150), 
    		"HRIWCYMAYET" VARCHAR(150), 
    		"HRIWCYJUNET" VARCHAR(150), 
    		"HRIWCYJULET" VARCHAR(150), 
    		"HRIWCYAUGET" VARCHAR(150), 
    		"HRIWCYSEPET" VARCHAR(150), 
    		"HRIWCYOCTET" VARCHAR(150), 
    		"HRIWCYNOVET" VARCHAR(150), 
    		"HRIWCYDECET" VARCHAR(150), 
    		"FUNCPYDEC" VARCHAR(150), 
    		"FUNCCYJAN" VARCHAR(150), 
    		"FUNCCYFEB" VARCHAR(150), 
    		"FUNCCYMAR" VARCHAR(150), 
    		"FUNCCYAPR" VARCHAR(150), 
    		"FUNCCYMAY" VARCHAR(150), 
    		"FUNCCYJUN" VARCHAR(150), 
    		"FUNCCYJUL" VARCHAR(150), 
    		"FUNCCYAUG" VARCHAR(150), 
    		"FUNCCYSEP" VARCHAR(150), 
    		"FUNCCYOCT" VARCHAR(150), 
    		"FUNCCYNOV" VARCHAR(150), 
    		"FUNCCYDEC" VARCHAR(150), 
    		"RLAPYDEC" VARCHAR(150), 
    		"RLACYJAN" VARCHAR(150), 
    		"RLACYFEB" VARCHAR(150), 
    		"RLACYMAR" VARCHAR(150), 
    		"RLACYAPR" VARCHAR(150), 
    		"RLACYMAY" VARCHAR(150), 
    		"RLACYJUN" VARCHAR(150), 
    		"RLACYJUL" VARCHAR(150), 
    		"RLACYAUG" VARCHAR(150), 
    		"RLACYSEP" VARCHAR(150), 
    		"RLACYOCT" VARCHAR(150), 
    		"RLACYNOV" VARCHAR(150), 
    		"RLACYDEC" VARCHAR(150), 
    		"RLDPYDEC" VARCHAR(150), 
    		"RLDCYJAN" VARCHAR(150), 
    		"RLDCYFEB" VARCHAR(150), 
    		"RLDCYMAR" VARCHAR(150), 
    		"RLDCYAPR" VARCHAR(150), 
    		"RLDCYMAY" VARCHAR(150), 
    		"RLDCYJUN" VARCHAR(150), 
    		"RLDCYJUL" VARCHAR(150), 
    		"RLDCYAUG" VARCHAR(150), 
    		"RLDCYSEP" VARCHAR(150), 
    		"RLDCYOCT" VARCHAR(150), 
    		"RLDCYNOV" VARCHAR(150), 
    		"RLDCYDEC" VARCHAR(150), 
    		"RLPYDEC" DOUBLE, 
    		"RLCYJAN" DOUBLE, 
    		"RLCYFEB" DOUBLE, 
    		"RLCYMAR" DOUBLE, 
    		"RLCYAPR" DOUBLE, 
    		"RLCYMAY" DOUBLE, 
    		"RLCYJUN" DOUBLE, 
    		"RLCYJUL" DOUBLE, 
    		"RLCYAUG" DOUBLE, 
    		"RLCYSEP" DOUBLE, 
    		"RLCYOCT" DOUBLE, 
    		"RLCYNOV" DOUBLE, 
    		"RLCYDEC" DOUBLE, 
    		"LCPY12" DOUBLE, 
    		"LCCY01" DOUBLE, 
    		"LCCY02" DOUBLE, 
    		"LCCY03" DOUBLE, 
    		"LCCY04" DOUBLE, 
    		"LCCY05" DOUBLE, 
    		"LCCY06" DOUBLE, 
    		"LCCY07" DOUBLE, 
    		"LCCY08" DOUBLE, 
    		"LCCY09" DOUBLE, 
    		"LCCY10" DOUBLE, 
    		"LCCY11" DOUBLE, 
    		"LCCY12" DOUBLE, 
    		"LCMAJORPY12" VARCHAR(150), 
    		"LCMAJORCY01" VARCHAR(150), 
    		"LCMAJORCY02" VARCHAR(150), 
    		"LCMAJORCY03" VARCHAR(150), 
    		"LCMAJORCY04" VARCHAR(150), 
    		"LCMAJORCY05" VARCHAR(150), 
    		"LCMAJORCY06" VARCHAR(150), 
    		"LCMAJORCY07" VARCHAR(150), 
    		"LCMAJORCY08" VARCHAR(150), 
    		"LCMAJORCY09" VARCHAR(150), 
    		"LCMAJORCY10" VARCHAR(150), 
    		"LCMAJORCY11" VARCHAR(150), 
    		"LCMAJORCY12" VARCHAR(150), 
    		"LCDIVPY12" VARCHAR(150), 
    		"LCDIVCY01" VARCHAR(150), 
    		"LCDIVCY02" VARCHAR(150), 
    		"LCDIVCY03" VARCHAR(150), 
    		"LCDIVCY04" VARCHAR(150), 
    		"LCDIVCY05" VARCHAR(150), 
    		"LCDIVCY06" VARCHAR(150), 
    		"LCDIVCY07" VARCHAR(150), 
    		"LCDIVCY08" VARCHAR(150), 
    		"LCDIVCY09" VARCHAR(150), 
    		"LCDIVCY10" VARCHAR(150), 
    		"LCDIVCY11" VARCHAR(150), 
    		"LCDIVCY12" VARCHAR(150), 
    		"LCDEPTPY12" VARCHAR(150), 
    		"LCDEPTCY01" VARCHAR(150), 
    		"LCDEPTCY02" VARCHAR(150), 
    		"LCDEPTCY03" VARCHAR(150), 
    		"LCDEPTCY04" VARCHAR(150), 
    		"LCDEPTCY05" VARCHAR(150), 
    		"LCDEPTCY06" VARCHAR(150), 
    		"LCDEPTCY07" VARCHAR(150), 
    		"LCDEPTCY08" VARCHAR(150), 
    		"LCDEPTCY09" VARCHAR(150), 
    		"LCDEPTCY10" VARCHAR(150), 
    		"LCDEPTCY11" VARCHAR(150), 
    		"LCDEPTCY12" VARCHAR(150), 
    		"LCPROJPY12" VARCHAR(150), 
    		"LCPROJCY01" VARCHAR(150), 
    		"LCPROJCY02" VARCHAR(150), 
    		"LCPROJCY03" VARCHAR(150), 
    		"LCPROJCY04" VARCHAR(150), 
    		"LCPROJCY05" VARCHAR(150), 
    		"LCPROJCY06" VARCHAR(150), 
    		"LCPROJCY07" VARCHAR(150), 
    		"LCPROJCY08" VARCHAR(150), 
    		"LCPROJCY09" VARCHAR(150), 
    		"LCPROJCY10" VARCHAR(150), 
    		"LCPROJCY11" VARCHAR(150), 
    		"LCPROJCY12" VARCHAR(150), 
    		"DEPTPY12" VARCHAR(150), 
    		"DEPTCY01" VARCHAR(150), 
    		"DEPTCY02" VARCHAR(150), 
    		"DEPTCY03" VARCHAR(150), 
    		"DEPTCY04" VARCHAR(150), 
    		"DEPTCY05" VARCHAR(150), 
    		"DEPTCY06" VARCHAR(150), 
    		"DEPTCY07" VARCHAR(150), 
    		"DEPTCY08" VARCHAR(150), 
    		"DEPTCY09" VARCHAR(150), 
    		"DEPTCY10" VARCHAR(150), 
    		"DEPTCY11" VARCHAR(150), 
    		"DEPTCY12" VARCHAR(150), 
    		"DIVPY12" VARCHAR(150), 
    		"DIVCY01" VARCHAR(150), 
    		"DIVCY02" VARCHAR(150), 
    		"DIVCY03" VARCHAR(150), 
    		"DIVCY04" VARCHAR(150), 
    		"DIVCY05" VARCHAR(150), 
    		"DIVCY06" VARCHAR(150), 
    		"DIVCY07" VARCHAR(150), 
    		"DIVCY08" VARCHAR(150), 
    		"DIVCY09" VARCHAR(150), 
    		"DIVCY10" VARCHAR(150), 
    		"DIVCY11" VARCHAR(150), 
    		"DIVCY12" VARCHAR(150), 
    		"MAJORPY12" VARCHAR(150), 
    		"MAJORCY01" VARCHAR(150), 
    		"MAJORCY02" VARCHAR(150), 
    		"MAJORCY03" VARCHAR(150), 
    		"MAJORCY04" VARCHAR(150), 
    		"MAJORCY05" VARCHAR(150), 
    		"MAJORCY06" VARCHAR(150), 
    		"MAJORCY07" VARCHAR(150), 
    		"MAJORCY08" VARCHAR(150), 
    		"MAJORCY09" VARCHAR(150), 
    		"MAJORCY10" VARCHAR(150), 
    		"MAJORCY11" VARCHAR(150), 
    		"MAJORCY12" VARCHAR(150),
    		"YEARDATE" DATE
    	)

  12. #12
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Either you specify the columns you are inserting, or you export the extra column.

    Andy

  13. #13
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    Quote Originally Posted by ARWinner View Post
    Hint: you can specify the column names you are using on the insert statement...

    Andy
    Even if your table has very many columns,
    you should follow ARWinner's suggestions, if you want to fill a specific column("yeardate") by a default(or specific) value('2011-12-03').

    Please see Syntax Diagram of IMPORT.
    IMPORT - IBM DB2 9.7 for Linux, UNIX, and Windows
    Especially marked Bold Red ...
    Code:
    Command syntax
    
    >>-IMPORT FROM--filename--OF--filetype-------------------------->
    
    >--+-------------------------+--+------------------------+------>
       |            .-,--------. |  |           .-,--------. |   
       |            V          | |  |           V          | |   
       '-LOBS FROM----lob-path-+-'  '-XML FROM----xml-path-+-'   
    
    >--+-------------------------------+---------------------------->
       |              .--------------. |   
       |              V              | |   
       '-MODIFIED BY----filetype-mod-+-'   
    
    >--+-------------------------------------------------------------------------------------------------------+-->
       |                 .-,------------------------.                                                          |   
       |                 V                          |                                                          |   
       '-METHOD--+-L--(----column-start--column-end-+--)--+------------------------------------------------+-+-'   
                 |                                        |                     .-,-------------------.    | |     
                 |                                        |                     V                     |    | |     
                 |                                        '-NULL INDICATORS--(----null-indicator-list-+--)-' |     
                 |       .-,-----------.                                                                     |     
                 |       V             |                                                                     |     
                 +-N--(----column-name-+--)------------------------------------------------------------------+     
                 |       .-,---------------.                                                                 |     
                 |       V                 |                                                                 |     
                 '-P--(----column-position-+--)--------------------------------------------------------------'     
    
    >--+------------------------------------+----------------------->
       '-XMLPARSE--+-STRIP----+--WHITESPACE-'   
                   '-PRESERVE-'                 
    
    >--+--------------------------------------------------------------------------------------+-->
       '-XMLVALIDATE USING--+-XDS--+-----------------------+--| Ignore and Map parameters |-+-'   
                            |      '-DEFAULT--schema-sqlid-'                                |     
                            +-SCHEMA--schema-sqlid------------------------------------------+     
                            '-SCHEMALOCATION HINTS------------------------------------------'     
    
       .-ALLOW NO ACCESS----.                                   
    >--+--------------------+--+----------------------------+------->
       '-ALLOW WRITE ACCESS-'  '-COMMITCOUNT--+-n---------+-'   
                                              '-AUTOMATIC-'     
    
    >--+---------------------+--+-------------+--------------------->
       '-+-RESTARTCOUNT-+--n-'  '-ROWCOUNT--n-'   
         '-SKIPCOUNT----'                         
    
    >--+-----------------+--+-----------+--------------------------->
       '-WARNINGCOUNT--n-'  '-NOTIMEOUT-'   
    
    >--+------------------------+----------------------------------->
       '-MESSAGES--message-file-'   
    
    >--+-+-INSERT---------+--INTO--+-table-name--+-------------------------+-+----------------------+-><
       | +-INSERT_UPDATE--+        |             |    .-,-------------.    | |                      |   
       | +-REPLACE--------+        |             |    V               |    | |                      |   
       | '-REPLACE_CREATE-'        |             '-(----insert-column-+--)-' |                      |   
       |                           '-| hierarchy description |---------------'                      |   
       '-CREATE--INTO--+-table-name--+-------------------------+--------------+--| tblspace-specs |-'   
                       |             |    .-,-------------.    |              |                         
                       |             |    V               |    |              |                         
                       |             '-(----insert-column-+--)-'              |                         
                       '-| hierarchy description |--+-AS ROOT TABLE---------+-'                         
                                                    '-UNDER--sub-table-name-'                           
    
    Ignore and Map parameters
    
    |--+--------------------------------+--------------------------->
       |            .-,------------.    |   
       |            V              |    |   
       '-IGNORE--(----schema-sqlid-+--)-'   
    
    >--+----------------------------------------------------+-------|
       |         .-,-----------------------------------.    |   
       |         V                                     |    |   
       '-MAP--(----(--schema-sqlid--,--schema-sqlid--)-+--)-'   
    
    hierarchy description
    
       .-ALL TABLES---------.           
    |--+-| sub-table-list |-+--+----+------------------------------->
                               '-IN-'   
    
    >--HIERARCHY--+-STARTING--sub-table-name-+----------------------|
                  '-| traversal-order-list |-'   
    
    sub-table-list
    
          .-,-------------------------------------------.      
          V                                             |      
    |--(----sub-table-name--+-------------------------+-+--)--------|
                            |    .-,-------------.    |        
                            |    V               |    |        
                            '-(----insert-column-+--)-'        
    
    traversal-order-list
    
          .-,--------------.      
          V                |      
    |--(----sub-table-name-+--)-------------------------------------|
    
    tblspace-specs
    
    |--+----------------------------------------------------------------------------------+--|
       '-IN--tablespace-name--+---------------------------+--+--------------------------+-'   
                              '-INDEX IN--tablespace-name-'  '-LONG IN--tablespace-name-'

  14. #14
    Join Date
    Jun 2012
    Posts
    32
    The solution of AR WINNER WORKED thanks a lot guys.

    Code:
    CONNECT TO  PY_TEST;
    
    import from C:\temp_PY.ixf of ixf insert into DB2INST1.PY_EMP_HC( ROW_ID ,PYDECHC  ,CYJANHC  ,
    		CYFEBHC  ,
    		CYMARHC  ,
    		CYAPRHC  ,
    		CYMAYHC  ,
    		CYJUNHC  ,
    		CYJULHC  ,
    		CYAUGHC  ,
    		CYSEPHC  ,
    		CYOCTHC  ,
    		CYNOVHC  ,
    		CYDECHC  ,
    		PYDECMT  ,
    		CYJANMT  ,
    		CYFEBMT  ,
    		CYMARMT  ,
    		CYAPRMT  ,
    		CYMAYMT  ,
    		CYJUNMT  ,
    		CYJULMT  ,
    		CYAUGMT  ,
    		CYSEPMT  ,
    		CYOCTMT  ,
    		CYNOVMT  ,
    		CYDECMT  ,
    		PYDECMD  ,
    		CYJANMD  ,
    		CYFEBMD  ,
    		CYMARMD  ,
    		CYAPRMD  ,
    		CYMAYMD  ,
    		CYJUNMD  ,
    		CYJULMD  ,
    		CYAUGMD  ,
    		CYSEPMD  ,
    		CYOCTMD  ,
    		CYNOVMD  ,
    		CYDECMD  ,
    		PYDECED  ,
    		CYJANED  ,
    		CYFEBED  ,
    		CYMARED  ,
    		CYAPRED  ,
    		CYMAYED  ,
    		CYJUNED  ,
    		CYJULED  ,
    		CYAUGED  ,
    		CYSEPED  ,
    		CYOCTED  ,
    		CYNOVED  ,
    		CYDECED  ,
    		HRIWPYDECMT  ,
    		HRIWCYJANMT  ,
    		HRIWCYFEBMT  ,
    		HRIWCYMARMT  ,
    		HRIWCYAPRMT  ,
    		HRIWCYMAYMT  ,
    		HRIWCYJUNMT  ,
    		HRIWCYJULMT  ,
    		HRIWCYAUGMT  ,
    		HRIWCYSEPMT  ,
    		HRIWCYOCTMT  ,
    		HRIWCYNOVMT  ,
    		HRIWCYDECMT  ,
    		HRIWPYDECHC  ,
    		HRIWCYJANHC  ,
    		HRIWCYFEBHC  ,
    		HRIWCYMARHC  ,
    		HRIWCYAPRHC  ,
    		HRIWCYMAYHC  ,
    		HRIWCYJUNHC  ,
    		HRIWCYJULHC  ,
    		HRIWCYAUGHC  ,
    		HRIWCYSEPHC  ,
    		HRIWCYOCTHC  ,
    		HRIWCYNOVHC  ,
    		HRIWCYDECHC  ,
    		HRIWPYDECET  ,
    		HRIWCYJANET  ,
    		HRIWCYFEBET  ,
    		HRIWCYMARET  ,
    		HRIWCYAPRET  ,
    		HRIWCYMAYET  ,
    		HRIWCYJUNET  ,
    		HRIWCYJULET  ,
    		HRIWCYAUGET  ,
    		HRIWCYSEPET  ,
    		HRIWCYOCTET  ,
    		HRIWCYNOVET  ,
    		HRIWCYDECET  ,
    		FUNCPYDEC  ,
    		FUNCCYJAN  ,
    		FUNCCYFEB  ,
    		FUNCCYMAR  ,
    		FUNCCYAPR  ,
    		FUNCCYMAY  ,
    		FUNCCYJUN  ,
    		FUNCCYJUL  ,
    		FUNCCYAUG  ,
    		FUNCCYSEP  ,
    		FUNCCYOCT  ,
    		FUNCCYNOV  ,
    		FUNCCYDEC  ,
    		RLAPYDEC  ,
    		RLACYJAN  ,
    		RLACYFEB  ,
    		RLACYMAR  ,
    		RLACYAPR  ,
    		RLACYMAY  ,
    		RLACYJUN  ,
    		RLACYJUL  ,
    		RLACYAUG  ,
    		RLACYSEP  ,
    		RLACYOCT  ,
    		RLACYNOV  ,
    		RLACYDEC  ,
    		RLDPYDEC  ,
    		RLDCYJAN  ,
    		RLDCYFEB  ,
    		RLDCYMAR  ,
    		RLDCYAPR  ,
    		RLDCYMAY  ,
    		RLDCYJUN  ,
    		RLDCYJUL  ,
    		RLDCYAUG  ,
    		RLDCYSEP  ,
    		RLDCYOCT  ,
    		RLDCYNOV  ,
    		RLDCYDEC  ,
    		RLPYDEC  ,
    		RLCYJAN  ,
    		RLCYFEB  ,
    		RLCYMAR  ,
    		RLCYAPR  ,
    		RLCYMAY  ,
    		RLCYJUN  ,
    		RLCYJUL  ,
    		RLCYAUG  ,
    		RLCYSEP  ,
    		RLCYOCT  ,
    		RLCYNOV  ,
    		RLCYDEC  ,
    		LCPY12  ,
    		LCCY01  ,
    		LCCY02  ,
    		LCCY03  ,
    		LCCY04  ,
    		LCCY05  ,
    		LCCY06  ,
    		LCCY07  ,
    		LCCY08  ,
    		LCCY09  ,
    		LCCY10  ,
    		LCCY11  ,
    		LCCY12  ,
    		LCMAJORPY12  ,
    		LCMAJORCY01  ,
    		LCMAJORCY02  ,
    		LCMAJORCY03  ,
    		LCMAJORCY04  ,
    		LCMAJORCY05  ,
    		LCMAJORCY06  ,
    		LCMAJORCY07  ,
    		LCMAJORCY08  ,
    		LCMAJORCY09  ,
    		LCMAJORCY10  ,
    		LCMAJORCY11  ,
    		LCMAJORCY12  ,
    		LCDIVPY12  ,
    		LCDIVCY01  ,
    		LCDIVCY02  ,
    		LCDIVCY03  ,
    		LCDIVCY04  ,
    		LCDIVCY05  ,
    		LCDIVCY06  ,
    		LCDIVCY07  ,
    		LCDIVCY08  ,
    		LCDIVCY09  ,
    		LCDIVCY10  ,
    		LCDIVCY11  ,
    		LCDIVCY12  ,
    		LCDEPTPY12  ,
    		LCDEPTCY01  ,
    		LCDEPTCY02  ,
    		LCDEPTCY03  ,
    		LCDEPTCY04  ,
    		LCDEPTCY05  ,
    		LCDEPTCY06  ,
    		LCDEPTCY07  ,
    		LCDEPTCY08  ,
    		LCDEPTCY09  ,
    		LCDEPTCY10  ,
    		LCDEPTCY11  ,
    		LCDEPTCY12  ,
    		LCPROJPY12  ,
    		LCPROJCY01  ,
    		LCPROJCY02  ,
    		LCPROJCY03  ,
    		LCPROJCY04  ,
    		LCPROJCY05  ,
    		LCPROJCY06  ,
    		LCPROJCY07  ,
    		LCPROJCY08  ,
    		LCPROJCY09  ,
    		LCPROJCY10  ,
    		LCPROJCY11  ,
    		LCPROJCY12  ,
    		DEPTPY12  ,
    		DEPTCY01  ,
    		DEPTCY02  ,
    		DEPTCY03  ,
    		DEPTCY04  ,
    		DEPTCY05  ,
    		DEPTCY06  ,
    		DEPTCY07  ,
    		DEPTCY08  ,
    		DEPTCY09  ,
    		DEPTCY10  ,
    		DEPTCY11  ,
    		DEPTCY12  ,
    		DIVPY12  ,
    		DIVCY01  ,
    		DIVCY02  ,
    		DIVCY03  ,
    		DIVCY04  ,
    		DIVCY05  ,
    		DIVCY06  ,
    		DIVCY07  ,
    		DIVCY08  ,
    		DIVCY09  ,
    		DIVCY10  ,
    		DIVCY11  ,
    		DIVCY12  ,
    		MAJORPY12  ,
    		MAJORCY01  ,
    		MAJORCY02  ,
    		MAJORCY03  ,
    		MAJORCY04  ,
    		MAJORCY05  ,
    		MAJORCY06  ,
    		MAJORCY07  ,
    		MAJORCY08  ,
    		MAJORCY09  ,
    		MAJORCY10  ,
    		MAJORCY11  ,
    		MAJORCY12 
    	) ;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •