• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 915
  • Last Modified:

Copy data from one table to another

Trying to move data from table F06116 to table F0618, got "Value for column or variable YTRTWC not compatible."  Please see file fields description below, is there a way get data moved from F06116-->F0618??

Thank you!

***File Field Description for F06116***

 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:06       Page    1
 Input parameters
   File  . . . . . . . . . . . . . . . . . . . :  F06116
     Library . . . . . . . . . . . . . . . . . :  PRODDTA
 File Information
   File  . . . . . . . . . . . . . . . . . . . :  F06116
     Library . . . . . . . . . . . . . . . . . :  PRODDTA
   File location . . . . . . . . . . . . . . . :  *LCL
   Externally described  . . . . . . . . . . . :  Yes
   Number of record formats  . . . . . . . . . :      1
   Type of file  . . . . . . . . . . . . . . . :  Physical
   SQL file type . . . . . . . . . . . . . . . :  TABLE
   File creation date  . . . . . . . . . . . . :  04/06/00
 Record Format Information
   Record format . . . . . . . . . . . . . . . :  F06116
   Format level identifier . . . . . . . . . . :  4408061958FC9
   Number of fields  . . . . . . . . . . . . . :    150
   Record length . . . . . . . . . . . . . . . :    717
 Field Level Information
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTAN8      ZONED        8  0       8         1        Both     YTAN8
     Allows the null value
   YTPALF     CHAR           12      12         9        Both     YTPALF
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPRTR     PACKED       9  0       5        21        Both     YTPRTR
     Allows the null value
   YTRCCD     CHAR            1       1        26        Both     YTRCCD
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTCKCN     ZONED        8  0       8        27        Both     YTCKCN
     Allows the null value
   YTAM       CHAR            1       1        35        Both     YTAM
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTCO       CHAR            5       5        36        Both     YTCO
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTHMCO     CHAR            5       5        41        Both     YTHMCO
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTHMCU     CHAR           12      12        46        Both     YTHMCU
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:06       Page    2
 Record format . . . . :  F06116        File . . . :  F06116       Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTMCU      CHAR           12      12        58        Both     YTMCU
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTOBJ      CHAR            6       6        70        Both     YTOBJ
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTSUB      CHAR            8       8        76        Both     YTSUB
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTRCO      CHAR            5       5        84        Both     YTRCO
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTGMCU     CHAR           12      12        89        Both     YTGMCU
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTGOBJ     CHAR            6       6       101        Both     YTGOBJ
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTGSUB     CHAR            8       8       107        Both     YTGSUB
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTSBL      CHAR            8       8       115        Both     YTSBL
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTSBLT     CHAR            1       1       123        Both     YTSBLT
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTWR01     CHAR            4       4       124        Both     YTWR01
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTMCUO     CHAR           12      12       128        Both     YTMCUO
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTMAIL     CHAR           10      10       140        Both     YTMAIL
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPHRW     PACKED       9  0       5       150        Both     YTPHRW
     Allows the null value
   YTOPSQ     ZONED        5  0       5       155        Both     YTOPSQ
     Allows the null value
   YTRILT     CHAR            1       1       160        Both     YTRILT
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:06       Page    3
 Record format . . . . :  F06116        File . . . :  F06116       Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTITM      ZONED        8  0       8       161        Both     YTITM
     Allows the null value
   YTPCUN     PACKED       9  0       5       169        Both     YTPCUN
     Allows the null value
   YTUM       CHAR            2       2       174        Both     YTUM
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPHRT     PACKED       9  0       5       176        Both     YTPHRT
     Allows the null value
   YTPPRT     PACKED       9  0       5       181        Both     YTPPRT
     Allows the null value
   YTBHRT     PACKED       9  0       5       186        Both     YTBHRT
     Allows the null value
   YTPBRT     PACKED       9  0       5       191        Both     YTPBRT
     Allows the null value
   YTBDRT     PACKED       9  0       5       196        Both     YTBDRT
     Allows the null value
   YTSHRT     PACKED       9  0       5       201        Both     YTSHRT
     Allows the null value
   YTSHFT     CHAR            1       1       206        Both     YTSHFT
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTSHD      PACKED       9  0       5       207        Both     YTSHD
     Allows the null value
   YTPAYM     PACKED       5  0       3       212        Both     YTPAYM
     Allows the null value
   YTLD       CHAR            1       1       215        Both     YTLD
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTGPA      PACKED       9  0       5       216        Both     YTGPA
     Allows the null value
   YTDPA      PACKED       9  0       5       221        Both     YTDPA
     Allows the null value
   YTRCPY     PACKED       9  0       5       226        Both     YTRCPY
     Allows the null value
   YTSAMT     PACKED      11  0       6       231        Both     YTSAMT
     Allows the null value
   YTUN       CHAR            6       6       237        Both     YTUN
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTJBCD     CHAR            6       6       243        Both     YTJBCD
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:06       Page    4
 Record format . . . . :  F06116        File . . . :  F06116       Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTJBST     CHAR            4       4       249        Both     YTJBST
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTWST      ZONED        2  0       2       253        Both     YTWST
     Allows the null value
   YTWCNT     ZONED        3  0       3       255        Both     YTWCNT
     Allows the null value
   YTWCTY     ZONED        4  0       4       258        Both     YTWCTY
     Allows the null value
   YTWCMP     CHAR            4       4       262        Both     YTWCMP
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTWET      CHAR            1       1       266        Both     YTWET
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTGENA     PACKED       9  0       5       267        Both     YTGENA
     Allows the null value
   YTWCAM     PACKED       9  0       5       272        Both     YTWCAM
     Allows the null value
   YTWCMB     PACKED       9  0       5       277        Both     YTWCMB
     Allows the null value
   YTGENB     PACKED       9  0       5       282        Both     YTGENB
     Allows the null value
   YTWCMO     PACKED       9  0       5       287        Both     YTWCMO
     Allows the null value
   YTGENO     PACKED       9  0       5       292        Both     YTGENO
     Allows the null value
   YTWCMX     PACKED       9  0       5       297        Both     YTWCMX
     Allows the null value
   YTGENX     PACKED       9  0       5       302        Both     YTGENX
     Allows the null value
   YTWCBN     PACKED       9  0       5       307        Both     YTWCBN
     Allows the null value
   YTHMO      ZONED        2  0       2       312        Both     YTHMO
     Allows the null value
   YTPDBA     PACKED       5  0       3       314        Both     YTPDBA
     Allows the null value
   YTPB       CHAR            1       1       317        Both     YTPB
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTDEDM     CHAR            1       1       318        Both     YTDEDM
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:06       Page    5
 Record format . . . . :  F06116        File . . . :  F06116       Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTSALY     CHAR            1       1       319        Both     YTSALY
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTNMTH     CHAR            1       1       320        Both     YTNMTH
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPFRQ     CHAR            1       1       321        Both     YTPFRQ
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTFY       ZONED        2  0       2       322        Both     YTFY
     Allows the null value
   YTDGL      ZONED        6  0       6       324        Both     YTDGL
     Allows the null value
   YTPN       ZONED        2  0       2       330        Both     YTPN
     Allows the null value
   YTDWK      ZONED        6  0       6       332        Both     YTDWK
     Allows the null value
   YTDW       CHAR            1       1       338        Both     YTDW
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPPED     ZONED        6  0       6       339        Both     YTPPED
     Allows the null value
   YTPPP      CHAR            1       1       345        Both     YTPPP
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTDTBT     PACKED      13  0       7       346        Both     YTDTBT
     Allows the null value
   YTTCDE     PACKED      13  0       7       353        Both     YTTCDE
     Allows the null value
   YTEQCO     CHAR            5       5       360        Both     YTEQCO
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTEQWO     CHAR            9       9       365        Both     YTEQWO
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTEQCG     CHAR            9       9       374        Both     YTEQCG
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTQOBJ     CHAR            6       6       383        Both     YTQOBJ
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTERC      CHAR            2       2       389        Both     YTERC
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:06       Page    6
 Record format . . . . :  F06116        File . . . :  F06116       Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTEQRT     PACKED       9  0       5       391        Both     YTEQRT
     Allows the null value
   YTEQGR     PACKED       9  0       5       396        Both     YTEQGR
     Allows the null value
   YTEQHR     PACKED       9  0       5       401        Both     YTEQHR
     Allows the null value
   YTEXR      CHAR           30      30       406        Both     YTEXR
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTP001     CHAR            3       3       436        Both     YTP001
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTP002     CHAR            3       3       439        Both     YTP002
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTP003     CHAR            3       3       442        Both     YTP003
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTP004     CHAR            3       3       445        Both     YTP004
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTUSER     CHAR           10      10       448        Both     YTUSER
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTCMMT     CHAR            1       1       458        Both     YTCMMT
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTCKDT     ZONED        6  0       6       459        Both     YTCKDT
     Allows the null value
   YTUAMT     PACKED       9  0       5       465        Both     YTUAMT
     Allows the null value
   YTYST      CHAR            1       1       470        Both     YTYST
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTICU      ZONED        8  0       8       471        Both     YTICU
     Allows the null value
   YTGICU     ZONED        8  0       8       479        Both     YTGICU
     Allows the null value
   YTDICJ     ZONED        6  0       6       487        Both     YTDICJ
     Allows the null value
   YTUPMJ     ZONED        6  0       6       493        Both     YTUPMJ
     Allows the null value
   YTPID      CHAR           10      10       499        Both     YTPID
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:06       Page    7
 Record format . . . . :  F06116        File . . . :  F06116       Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTANI      CHAR           29      29       509        Both     YTANI
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTCTRY     ZONED        2  0       2       538        Both     YTCTRY
     Allows the null value
   YTANN8     ZONED        8  0       8       540        Both     YTANN8
     Allows the null value
   YTPGRP     CHAR            2       2       548        Both     YTPGRP
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPAYG     CHAR            1       1       550        Both     YTPAYG
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPAYN     CHAR            1       1       551        Both     YTPAYN
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTSFLG     CHAR            1       1       552        Both     YTSFLG
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTWS       CHAR            1       1       553        Both     YTWS
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPCK      CHAR            1       1       554        Both     YTPCK
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTICC      CHAR            1       1       555        Both     YTICC
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTICS      CHAR            1       1       556        Both     YTICS
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTCMTH     CHAR            1       1       557        Both     YTCMTH
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTACO      CHAR            1       1       558        Both     YTACO
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTAI       CHAR            1       1       559        Both     YTAI
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTSEC$     CHAR            1       1       560        Both     YTSEC$
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:06       Page    8
 Record format . . . . :  F06116        File . . . :  F06116       Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTOHF      CHAR            1       1       561        Both     YTOHF
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTDEP1     CHAR            1       1       562        Both     YTDEP1
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTDEP2     CHAR            1       1       563        Both     YTDEP2
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTDEP3     CHAR            1       1       564        Both     YTDEP3
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTDEP4     CHAR            1       1       565        Both     YTDEP4
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTDEP5     CHAR            1       1       566        Both     YTDEP5
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTDEP6     CHAR            1       1       567        Both     YTDEP6
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTTT01     CHAR            2       2       568        Both     YTTT01
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTTT02     CHAR            2       2       570        Both     YTTT02
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTTT03     CHAR            2       2       572        Both     YTTT03
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTTT04     CHAR            2       2       574        Both     YTTT04
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTTT05     CHAR            2       2       576        Both     YTTT05
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTTT06     CHAR            2       2       578        Both     YTTT06
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTTT07     CHAR            2       2       580        Both     YTTT07
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTTT08     CHAR            2       2       582        Both     YTTT08
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:06       Page    9
 Record format . . . . :  F06116        File . . . :  F06116       Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTTT09     CHAR            2       2       584        Both     YTTT09
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTTT10     CHAR            2       2       586        Both     YTTT10
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTTT11     CHAR            2       2       588        Both     YTTT11
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTTT12     CHAR            2       2       590        Both     YTTT12
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTTT13     CHAR            2       2       592        Both     YTTT13
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTTT14     CHAR            2       2       594        Both     YTTT14
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTTT15     CHAR            2       2       596        Both     YTTT15
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTUSR      CHAR           18      18       598        Both     YTUSR
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTEPA      PACKED       9  0       5       616        Both     YTEPA
     Allows the null value
   YTBFA      PACKED      11  0       6       621        Both     YTBFA
     Allows the null value
   YTRTWC     PACKED       9  0       5       627        Both     YTRTWC
     Allows the null value
   YTGENR     PACKED       9  0       5       632        Both     YTGENR
     Allows the null value
   YTADV      CHAR            1       1       637        Both     YTADV
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTSTIP     CHAR            1       1       638        Both     YTSTIP
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTALPH     CHAR           40      40       639        Both     YTALPH
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTIIAP     CHAR            1       1       679        Both     YTIIAP
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:06       Page   10
 Record format . . . . :  F06116        File . . . :  F06116       Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTFICM     CHAR            1       1       680        Both     YTFICM
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTDTAB     CHAR            5       5       681        Both     YTDTAB
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTDTSP     PACKED      13  0       7       686        Both     YTDTSP
     Allows the null value
   YTYST1     CHAR            1       1       693        Both     YTYST1
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTCKCS     CHAR           15      15       694        Both     YTCKCS
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTALT0     CHAR            1       1       709        Both     YTALT0
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPOS      CHAR            8       8       710        Both     YTPOS
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37


***File Field Description for F0618***

 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:26       Page    1
 Input parameters
   File  . . . . . . . . . . . . . . . . . . . :  F0618
     Library . . . . . . . . . . . . . . . . . :  PRODDTA
 File Information
   File  . . . . . . . . . . . . . . . . . . . :  F0618
     Library . . . . . . . . . . . . . . . . . :  PRODDTA
   File location . . . . . . . . . . . . . . . :  *LCL
   Externally described  . . . . . . . . . . . :  Yes
   Number of record formats  . . . . . . . . . :      1
   Type of file  . . . . . . . . . . . . . . . :  Physical
   SQL file type . . . . . . . . . . . . . . . :  TABLE
   File creation date  . . . . . . . . . . . . :  04/06/00
 Record Format Information
   Record format . . . . . . . . . . . . . . . :  F0618
   Format level identifier . . . . . . . . . . :  3D7D52D566C66
   Number of fields  . . . . . . . . . . . . . :     99
   Record length . . . . . . . . . . . . . . . :    520
 Field Level Information
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTAN8      ZONED        8  0       8         1        Both     YTAN8
     Allows the null value
   YTPALF     CHAR           12      12         9        Both     YTPALF
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPRTR     PACKED       9  0       5        21        Both     YTPRTR
     Allows the null value
   YTRCCD     CHAR            1       1        26        Both     YTRCCD
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTCKCN     ZONED        8  0       8        27        Both     YTCKCN
     Allows the null value
   YTAM       CHAR            1       1        35        Both     YTAM
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTCO       CHAR            5       5        36        Both     YTCO
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTHMCO     CHAR            5       5        41        Both     YTHMCO
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTHMCU     CHAR           12      12        46        Both     YTHMCU
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:26       Page    2
 Record format . . . . :  F0618         File . . . :  F0618        Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTMCU      CHAR           12      12        58        Both     YTMCU
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTOBJ      CHAR            6       6        70        Both     YTOBJ
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTSUB      CHAR            8       8        76        Both     YTSUB
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTRCO      CHAR            5       5        84        Both     YTRCO
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTGMCU     CHAR           12      12        89        Both     YTGMCU
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTGOBJ     CHAR            6       6       101        Both     YTGOBJ
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTGSUB     CHAR            8       8       107        Both     YTGSUB
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTSBL      CHAR            8       8       115        Both     YTSBL
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTSBLT     CHAR            1       1       123        Both     YTSBLT
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTWR01     CHAR            4       4       124        Both     YTWR01
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTMCUO     CHAR           12      12       128        Both     YTMCUO
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTMAIL     CHAR           10      10       140        Both     YTMAIL
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPHRW     PACKED       9  0       5       150        Both     YTPHRW
     Allows the null value
   YTOPSQ     ZONED        5  0       5       155        Both     YTOPSQ
     Allows the null value
   YTRILT     CHAR            1       1       160        Both     YTRILT
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:26       Page    3
 Record format . . . . :  F0618         File . . . :  F0618        Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTITM      ZONED        8  0       8       161        Both     YTITM
     Allows the null value
   YTPCUN     PACKED       9  0       5       169        Both     YTPCUN
     Allows the null value
   YTUM       CHAR            2       2       174        Both     YTUM
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPHRT     PACKED       9  0       5       176        Both     YTPHRT
     Allows the null value
   YTPPRT     PACKED       9  0       5       181        Both     YTPPRT
     Allows the null value
   YTBHRT     PACKED       9  0       5       186        Both     YTBHRT
     Allows the null value
   YTPBRT     PACKED       9  0       5       191        Both     YTPBRT
     Allows the null value
   YTBDRT     PACKED       9  0       5       196        Both     YTBDRT
     Allows the null value
   YTSHRT     PACKED       9  0       5       201        Both     YTSHRT
     Allows the null value
   YTSHFT     CHAR            1       1       206        Both     YTSHFT
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTSHD      PACKED       9  0       5       207        Both     YTSHD
     Allows the null value
   YTPAYM     PACKED       5  0       3       212        Both     YTPAYM
     Allows the null value
   YTLD       CHAR            1       1       215        Both     YTLD
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTGPA      PACKED       9  0       5       216        Both     YTGPA
     Allows the null value
   YTDPA      PACKED       9  0       5       221        Both     YTDPA
     Allows the null value
   YTRCPY     PACKED       9  0       5       226        Both     YTRCPY
     Allows the null value
   YTSAMT     PACKED      11  0       6       231        Both     YTSAMT
     Allows the null value
   YTUN       CHAR            6       6       237        Both     YTUN
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTJBCD     CHAR            6       6       243        Both     YTJBCD
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:26       Page    4
 Record format . . . . :  F0618         File . . . :  F0618        Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTJBST     CHAR            4       4       249        Both     YTJBST
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTWST      ZONED        2  0       2       253        Both     YTWST
     Allows the null value
   YTWCNT     ZONED        3  0       3       255        Both     YTWCNT
     Allows the null value
   YTWCTY     ZONED        4  0       4       258        Both     YTWCTY
     Allows the null value
   YTWCMP     CHAR            4       4       262        Both     YTWCMP
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTWET      CHAR            1       1       266        Both     YTWET
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTGENA     PACKED       9  0       5       267        Both     YTGENA
     Allows the null value
   YTWCAM     PACKED       9  0       5       272        Both     YTWCAM
     Allows the null value
   YTWCMB     PACKED       9  0       5       277        Both     YTWCMB
     Allows the null value
   YTGENB     PACKED       9  0       5       282        Both     YTGENB
     Allows the null value
   YTWCMO     PACKED       9  0       5       287        Both     YTWCMO
     Allows the null value
   YTGENO     PACKED       9  0       5       292        Both     YTGENO
     Allows the null value
   YTWCMX     PACKED       9  0       5       297        Both     YTWCMX
     Allows the null value
   YTGENX     PACKED       9  0       5       302        Both     YTGENX
     Allows the null value
   YTWCBN     PACKED       9  0       5       307        Both     YTWCBN
     Allows the null value
   YTHMO      ZONED        2  0       2       312        Both     YTHMO
     Allows the null value
   YTPDBA     PACKED       5  0       3       314        Both     YTPDBA
     Allows the null value
   YTPB       CHAR            1       1       317        Both     YTPB
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTDEDM     CHAR            1       1       318        Both     YTDEDM
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:26       Page    5
 Record format . . . . :  F0618         File . . . :  F0618        Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTSALY     CHAR            1       1       319        Both     YTSALY
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTNMTH     CHAR            1       1       320        Both     YTNMTH
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPFRQ     CHAR            1       1       321        Both     YTPFRQ
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTFY       ZONED        2  0       2       322        Both     YTFY
     Allows the null value
   YTDGL      ZONED        6  0       6       324        Both     YTDGL
     Allows the null value
   YTPN       ZONED        2  0       2       330        Both     YTPN
     Allows the null value
   YTDWK      ZONED        6  0       6       332        Both     YTDWK
     Allows the null value
   YTDW       CHAR            1       1       338        Both     YTDW
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPPED     ZONED        6  0       6       339        Both     YTPPED
     Allows the null value
   YTPPP      CHAR            1       1       345        Both     YTPPP
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTDTBT     PACKED      13  0       7       346        Both     YTDTBT
     Allows the null value
   YTTCDE     PACKED      13  0       7       353        Both     YTTCDE
     Allows the null value
   YTEQCO     CHAR            5       5       360        Both     YTEQCO
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTEQWO     CHAR            9       9       365        Both     YTEQWO
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTEQCG     CHAR            9       9       374        Both     YTEQCG
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTQOBJ     CHAR            6       6       383        Both     YTQOBJ
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTERC      CHAR            2       2       389        Both     YTERC
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:26       Page    6
 Record format . . . . :  F0618         File . . . :  F0618        Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTEQRT     PACKED       9  0       5       391        Both     YTEQRT
     Allows the null value
   YTEQGR     PACKED       9  0       5       396        Both     YTEQGR
     Allows the null value
   YTEQHR     PACKED       9  0       5       401        Both     YTEQHR
     Allows the null value
   YTEXR      CHAR           30      30       406        Both     YTEXR
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTP001     CHAR            3       3       436        Both     YTP001
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTP002     CHAR            3       3       439        Both     YTP002
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTP003     CHAR            3       3       442        Both     YTP003
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTP004     CHAR            3       3       445        Both     YTP004
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTUSER     CHAR           10      10       448        Both     YTUSER
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTCMMT     CHAR            1       1       458        Both     YTCMMT
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTCKDT     ZONED        6  0       6       459        Both     YTCKDT
     Allows the null value
   YTUAMT     PACKED       9  0       5       465        Both     YTUAMT
     Allows the null value
   YTRTWC     PACKED       9  0       5       470        Both     YTRTWC
     Allows the null value
   YTGENR     PACKED       9  0       5       475        Both     YTGENR
     Allows the null value
   YTCKCS     CHAR           15      15       480        Both     YTCKCS
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTGICU     ZONED        8  0       8       495        Both     YTGICU
     Allows the null value
   YTAID      CHAR            8       8       503        Both     YTAID
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
 5722SS1 V5R2M0  020719      Display File Field Description                                      3/31/06  14:58:26       Page    7
 Record format . . . . :  F0618         File . . . :  F0618        Library . . . . . . . . . . :  PRODDTA
              Data        Field  Buffer    Buffer        Field    Column
   Field      Type       Length  Length  Position        Usage    Heading
   YTCMTH     CHAR            1       1       511        Both     YTCMTH
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTALT0     CHAR            1       1       512        Both     YTALT0
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37
   YTPOS      CHAR            8       8       513        Both     YTPOS
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37

0
jingyizou
Asked:
jingyizou
  • 5
  • 5
  • 3
  • +2
1 Solution
 
_b_hCommented:
A relatively simple RPG program or SQL statement can move the fields, but you would need to specify what input fields are mapped to which output fields.
Barry
0
 
tliottaCommented:
jingyizou:

Since the definitions _seem_ to be the same in both tables, first thought is that the value is invalid. Best answer might be simply to fix the incorrect value(s) before trying to copy.

Tom

p.s. But I suspect that you'd like to avoid that for some reason?
0
 
_b_hCommented:
The two files match up to position 470.
Then field YTYST (char 1) is copied to field YTRTWC (packed 9 0), so that will create the error.
There are some fields that are only in the input file:
YTYST      CHAR            1       1       470        Both     YTYST
YTICU      ZONED        8  0       8       471        Both     YTICU
YTGICU     ZONED        8  0       8       479        Both     YTGICU
YTDICJ     ZONED        6  0       6       487        Both     YTDICJ
YTUPMJ     ZONED        6  0       6       493        Both     YTUPMJ
YTPID      CHAR           10      10       499        Both     YTPID
YTANI      CHAR           29      29       509        Both     YTANI
YTCTRY     ZONED        2  0       2       538        Both     YTCTRY
YTANN8     ZONED        8  0       8       540        Both     YTANN8
YTPGRP     CHAR            2       2       548        Both     YTPGRP
YTPAYG     CHAR            1       1       550        Both     YTPAYG
YTPAYN     CHAR            1       1       551        Both     YTPAYN
YTSFLG     CHAR            1       1       552        Both     YTSFLG
YTWS       CHAR            1       1       553        Both     YTWS
YTPCK      CHAR            1       1       554        Both     YTPCK
YTICC      CHAR            1       1       555        Both     YTICC
YTICS      CHAR            1       1       556        Both     YTICS
YTCMTH     CHAR            1       1       557        Both     YTCMTH
YTACO      CHAR            1       1       558        Both     YTACO
YTAI       CHAR            1       1       559        Both     YTAI
YTSEC$     CHAR            1       1       560        Both     YTSEC$
YTOHF      CHAR            1       1       561        Both     YTOHF
YTDEP1     CHAR            1       1       562        Both     YTDEP1
YTDEP2     CHAR            1       1       563        Both     YTDEP2
YTDEP3     CHAR            1       1       564        Both     YTDEP3
YTDEP4     CHAR            1       1       565        Both     YTDEP4
YTDEP5     CHAR            1       1       566        Both     YTDEP5
YTDEP6     CHAR            1       1       567        Both     YTDEP6
YTTT01     CHAR            2       2       568        Both     YTTT01
YTTT02     CHAR            2       2       570        Both     YTTT02
YTTT03     CHAR            2       2       572        Both     YTTT03
YTTT04     CHAR            2       2       574        Both     YTTT04
YTTT05     CHAR            2       2       576        Both     YTTT05
YTTT06     CHAR            2       2       578        Both     YTTT06
YTTT07     CHAR            2       2       580        Both     YTTT07
YTTT08     CHAR            2       2       582        Both     YTTT08
YTTT09     CHAR            2       2       584        Both     YTTT09
YTTT10     CHAR            2       2       586        Both     YTTT10
YTTT11     CHAR            2       2       588        Both     YTTT11
YTTT12     CHAR            2       2       590        Both     YTTT12
YTTT13     CHAR            2       2       592        Both     YTTT13
YTTT14     CHAR            2       2       594        Both     YTTT14
YTTT15     CHAR            2       2       596        Both     YTTT15
YTUSR      CHAR           18      18       598        Both     YTUSR
YTEPA      PACKED       9  0       5       616        Both     YTEPA
YTBFA      PACKED      11  0       6       621        Both     YTBFA
YTADV      CHAR            1       1       637        Both     YTADV
YTSTIP     CHAR            1       1       638        Both     YTSTIP
YTALPH     CHAR           40      40       639        Both     YTALPH
YTIIAP     CHAR            1       1       679        Both     YTIIAP
YTFICM     CHAR            1       1       680        Both     YTFICM
YTDTAB     CHAR            5       5       681        Both     YTDTAB
YTDTSP     PACKED      13  0       7       686        Both     YTDTSP
YTYST1     CHAR            1       1       693        Both     YTYST1


There are some fields that are only in the output file:
YTGICU     ZONED        8  0       8       495        Both     YTGICU
YTAID      CHAR            8       8       503        Both     YTAID
YTCMTH     CHAR            1       1       511        Both     YTCMTH

If you want to drop the extra fields from the input file, and have default values for extra fields in the output file,
you could just copy the file, mapping and dropping those fields:
CPYF FROMFILE(PRODDTA/F06116) TOFILE(PRODDTA/F0618) MBROPT(*ADD) FMTOPT(*MAP *DROP)      
Otherwise, you are back to the SQL or RPG option.

Barry
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
jingyizouAuthor Commented:
Barry,

I assume CPYF command will overwrite source file?? Am i correct?  Actually I want keep all the records in f0618, add  those from f060116. Can i use cpyf?

Thanks
0
 
jingyizouAuthor Commented:
"A relatively simple RPG program or SQL statement can move the fields, but you would need to specify what input fields are mapped to which output fields.
Barry"


Barry,
could you let me know how to specify fields using SQL statement??

0
 
BryavCommented:
Wow, guys - I think this is lot simpler than all of that.  The F0618 and F06116 are JD Edwards Payroll transaction files.

I'm sorry I didn't see this post earlier because I think this is really simple.  The F0618 is the Transactional History file.  The F06116 is the work file for entering employee time transactions.

To get the recrods to history, you just have to post your payroll to history.  You do this in JDE by doing a Final Payroll Update.

You should never manually post records to the history file.  They're moved via a JDE DREAM Writer.  The F06116 is the current data and the F0618 is the all the data that has been finally posted.

The employee time card review programs look at the F06116 for the current info and the F0618 for the posted time entries.

If you have more questions about this you should contact the JDE/PeopleSoft/Oracle help desk.  They can walk you through the particulars for you environment.

Let me know if you need more help with this.  But this is a process you need to run, not a technical thing that needs to be done.

- Bryant

0
 
BryavCommented:
I should add that there's an integrity report P06705 that does the final update and runs an integrity report.

I can look up  other details for you if you need/want.  Just let me know.  I have worked with JDE Payroll in the past, but it's been a while - I'll have to look at my manuals.

Let me know if you need more info.

Thanks and good luck.

Bryant
0
 
jingyizouAuthor Commented:
Hi Bryant,

You definitely are the right person to talk to. Yes F0618, F06116 are JDE payroll tables. We had issues with payroll, a few transaction didn't get posted to history. So we spoke to JDE and the solution they provide is manully move data from f06116 to f0618. We use AS/400 as enterprise server and I'm just trying to figure out how to get it done as I happen to be that lucky IT person to take care of the data transfer.

Thank you.
0
 
BryavCommented:
Okay, then if you have to do it manually, I'd just do it in SQL.  Here's the 2 SQL statements you'll need to get you started:

First insert the records from the F06116 into the F0618 via the following SQLcode:
(Note you may want to select only specific records - I'm selecting all of them - let me know if you want only certain records like specific employee (YTAN8) numbers, etc.)  To enter the SQL you can just do STRSQL while inside the right JDE environment on a command line.  Then just copy and paste the code in.  It's 2 pages worth, so you can break it up at the Select part and do half on one page and half on the next.

INSERT INTO PPSDTA/F0618                                          
(YTAN8, YTPALF, YTPRTR, YTRCCD, YTCKCN,                          
YTAM, YTCO, YTHMCO, YTHMCU, YTMCU, YTOBJ, YTSUB, YTRCO, YTGMCU,  
YTGOBJ, YTGSUB, YTSBL, YTSBLT, YTWR01, YTMCUO, YTMAIL, YTPHRW,    
YTOPSQ, YTRILT, YTITM, YTPCUN, YTUM, YTPHRT, YTPPRT, YTBHRT,      
YTPBRT, YTBDRT, YTSHRT, YTSHFT, YTSHD, YTPAYM, YTLD, YTGPA, YTDPA,
YTRCPY, YTSAMT, YTUN, YTJBCD, YTJBST, YTWST, YTWCNT, YTWCTY,      
YTWCMP, YTWET, YTGENA, YTWCAM, YTWCMB, YTGENB, YTWCMO, YTGENO,    
YTWCMX, YTGENX, YTWCBN, YTHMO, YTPDBA, YTPB, YTDEDM, YTSALY,      
YTNMTH, YTPFRQ, YTFY, YTDGL, YTPN, YTDWK, YTDW, YTPPED, YTPPP,    
YTDTBT, YTTCDE, YTEQCO, YTEQWO, YTEQCG, YTQOBJ, YTERC, YTEQRT,    
YTEQGR, YTEQHR, YTEXR, YTP001, YTP002, YTP003, YTP004, YTUSER,    
YTCMMT, YTCKDT, YTUAMT, YTRTWC, YTGENR, YTCKCS, YTGICU,          
YTCMTH, YTALT0, YTPOS)                                            
SELECT                                                            
YTAN8, YTPALF, YTPRTR, YTRCCD, YTCKCN,                            
YTAM, YTCO, YTHMCO, YTHMCU, YTMCU, YTOBJ, YTSUB, YTRCO, YTGMCU,  
YTGOBJ, YTGSUB, YTSBL, YTSBLT, YTWR01, YTMCUO, YTMAIL, YTPHRW,    
YTOPSQ, YTRILT, YTITM, YTPCUN, YTUM, YTPHRT, YTPPRT, YTBHRT,      
YTPBRT, YTBDRT, YTSHRT, YTSHFT, YTSHD, YTPAYM, YTLD, YTGPA, YTDPA,
YTRCPY, YTSAMT, YTUN, YTJBCD, YTJBST, YTWST, YTWCNT, YTWCTY,      
YTWCMP, YTWET, YTGENA, YTWCAM, YTWCMB, YTGENB, YTWCMO, YTGENO,    
YTWCMX, YTGENX, YTWCBN, YTHMO, YTPDBA, YTPB, YTDEDM, YTSALY,      
YTNMTH, YTPFRQ, YTFY, YTDGL, YTPN, YTDWK, YTDW, YTPPED, YTPPP,    
YTDTBT, YTTCDE, YTEQCO, YTEQWO, YTEQCG, YTQOBJ, YTERC, YTEQRT,    
YTEQGR, YTEQHR, YTEXR, YTP001, YTP002, YTP003, YTP004, YTUSER,    
YTCMMT, YTCKDT, YTUAMT, YTRTWC, YTGENR, YTCKCS, YTGICU,          
YTCMTH, YTALT0, YTPOS                                            
from F06116                                                      

This inserts all the recrods in the F06116 inot the F0618.

Next, after you verify that all the records were added to the F0618, you just delete the records from the F06116 file by entering the following SQL

Delete from F06116

If you insert only specific records, then you need to do the same where clause on the delete statement.

Wallah, you're done.  I'm not sure if there's anything else in the F0618 that needs to be filled in or not.  But I think that's all you have to.

When you're done, I'd run a payroll integrity report to make sure things are good.  Also I'd recommend making a quick copy of both the F06116 and the F0618 before you do the SQL.  That way if something goes awry, you can replace the files quickly and easily.

Let me know if you need more help.  That should do the trick though and you'll be done.

Bryant
0
 
ShadowProgrammerCommented:
Sorry to butt in...

I have compared the file layouts and the fields of F0618 are basically a subset of F06116 fields PLUS one extra field, this is
   YTAID      CHAR            8       8       503        Both     YTAID
     Allows the null value
     Coded Character Set Identifier  . . . . . :     37

So you have two options you could use (which avoid writing ad-hoc programs)

(1) Copy file F06116 to F0618 using CPYF with the options (*MAP *DROP), this will copy the relevant fields and leave YTAID unpopulated -  which you would need to do manually via DFU or SQL.

(2) Alternative - my preferred solution - is use Query to select the records you want to copy and create a new user defined field YTAID as 8 characters [ set to the desired value assuming you know what to set it to ]
Select ALL fields including the new field YTAID, define the result as an output file....
run the query.
copy the query output file to to F0618 using CPYF with the options (*MAP *DROP), this will copy the relevant fields including YTAID.
>>> if you need YTAID to have different values, repeat the process for each YTAID value needed.

Advantage to this method is you can double check the records in the query output file BEFORE copying them into the history file.  - check you have selected the right number of records.

Tony.
0
 
ShadowProgrammerCommented:
jingyizou - I have just seen Bryants recent post (SQL statements)... and have read the comment from JDE about MOVING the records, not copying the records,

so you would have to delete the records from F06116 after doing my copy process.

Bryant - the SQL looks ok except for the additional field YTAID which you need to cater for.

If it was my choice, I would still SQL to an empty version of F0618 and then double check BEFORE copying into proper F0618 and deleting F06116 records.

Tony
0
 
tliottaCommented:
Yeah, it's not at all clear why a complex SQL statement is needed when a far simpler CPYF seems to accomplish the same thing.

The OP didn't clarify how the error happened. It seemed as if a CPYF might have failed with an error indicating that a value mismatch was present. That is, there already has been an attempt to copy the data but there was limited success.

Tom
0
 
jingyizouAuthor Commented:
Bryant,

I ran the sql on as/400, it works great and I see the data get copied to f0618. But in payroll --paystub history, I didn't see the records.  I'll let our payroll person talk to JDE or it could be me miss something. I don't know much about payroll. As far as the moving data part, I think we're all set here.

Thank you for you guys help. I appreciate it.

Thanks

Jingyi
0
 
BryavCommented:
Glad to hear it Jingyi!  

Regarding the rest of it: I know that when you post to history, it also posts to the F6146 - PDBA Summary History File, and the F0619 DBA Detail History File for all of the deductions.  Also there's a Tax Ledger F06166 file that tracks the taxes.  Finally, there's a file F063451 and F06345 that has the Historical Payroll Registers and Processing respectively.  I don't remember for sure, but I think running the Verify Integrity of Payroll Summary History (P067011) will correct the discrepencies where they don't show up in the other files.

I believe you get to this from menu G0731 - Payroll History Audit Report. Option 11 depending on the JDE version.  This will show you the discrepencies between the payroll files, but I don't think it fixed anything.  Then I belive you have to run the options under History File Repost (options 14 - 20) to fix the various problems.  My guess it that you'll have to run most of them.  The JDE Analyst will know for sure.

Let me know if you have further questions.

To everyone else - you're right a cpyf with *drop *map with and *add option  would have also worked - I'm just so used to doing things in SQL that it's quick and easy and you can see exactly what it's doing.  Plus you can test it first by doing selects before you update or insert.  Also, I wasn't sure if there would be selction criteria, so I figured SQL was easiest to tweak.  Plus, most non-AS/400 folks understand SQL.  It took me literally about 90 seconds to write the SQL - about the same as it would have to do the cpyf - 6 of 1 or half-a-dozen of the other - same difference.

Also, I left out the YTAID field in the SQL so it didn't copy - the AID - Account field doesn't exist in the history file.

Thanks,

Bryant
0
 
tliottaCommented:
Bryant:

The "non-AS/400 folks" part makes good sense. Personally though, I'm still curious about what caused the error. It still feels as if _something_ is wrong that hasn't been discovered.

The first way I'd expect the error would be when using the file after an image-copy had been done with bad data. The second would be from attempting to copy with mapping or INSERTing actual invalid data.

I'm not clear on where/how the error was reported, so I'm not clear on whether anything has actually been fixed. (Nor if there even was a problem.)

Tom
0
 
ShadowProgrammerCommented:
Bryant...

>> Also, I left out the YTAID field in the SQL so it didn't copy - the AID - Account field doesn't exist in the history file.

My point was that the field YTAID didn't exist in the input file, F06116 but did exist in the output file, F0618...
so did the SQL default the value to null which is allowed for YTAID ??  Maybe that is why he can't see the records... and he needs to assign a value to YTAID.

Tony.
0
 
BryavCommented:
I'm not too concerned about the YTAID field, but you might be right Tony - that may be why it doesn't show up, but I'm thinking there are many reasons why they don't show up.  Basically, for some reason the update failed for those few employees left in the 6116 file.  The update program looks at the employee file and some AAIs (Automatic Accounting Instructions) to determine the account to post to and populates the AID field.  Also the final update program posts entries, based on the employee's setup to the various deductions and corresponding deduction files (DBA files).  The integrity fixes will resolve all of these issues.

Jingyi said they were instructed by the JDE Help Desk analyst to move the data to the 618.  Knowing how JDE works on most things, the rest can probably be fixed by running a few DREAM Writer programs to get the other postings corrected automatically.  JDE has a lot of fail-safe fixes built in for situations like this.  The account numbers are likely based on the type of hours (reg, ot, dbl time, etc.) plus a different account for various deductions and taxes, etc.  All of that is set up in JDE and there are programs to run to repopulate those fileds (AID field, and data in other files).  

I think the JDE analyst can help them get things back to normal from here.  

Jingyi, if you need more help, let us know....

Regarding the Null thing, Tony, I went back and looked at the original post, and I see what you mean - they must be using One World with only the data on the iSeries.  Jingyi's reference to "Enterprise Server" references that too. I'm assuming that the JDE fixes will correct that, but it's possible that you need to have a value in the field.  But if it's not running an RPG program and is running in Windows, then nulls are no big deal.  I'm guessing the programs are running in windows and not in RPG on the 400 where nulls would cause an issue.  In Native 400 version of JDE (World), nulls aren't allowed, so I know this is a different version of JDE.

Let me know if you have anymore questions.

- Bryant
0
 
jingyizouAuthor Commented:
I went back look the table F0618, YTAID field are all blank. I'm guessing YTAID may not be why it doesn't show up. I'll post the solution when I hear back from JDE analyst. It most likely will be an JDE issue rather than AS/400.  
Thank you for the help.

jingyi
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 5
  • 5
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now