March 01, 2007, 10:49 AM
Pam Krattvarchar and other fields in master
We have a varchar field in our master that is 7000 bytes. I've been searching on variable and varchar all morning because I know I've seen posts on this issue, but I'm not finding the solution I need. The fields after the varchar field are being ignored. I regenerated the master and it's exactly the same as it was.
The fields on the database (db2) are
PROCESS_DATE DATE 4
ALT_DEL_METHOD VARCHAR 7000
TOTALDESTS DECIMAL 1
ALLOCATIONMETH CHAR 1
FREQ CHAR 1
The master is being generated through the console. The ALT_DEL_METHOD is being created as TX50. I've tried changing it to a variety of things, but the webfocus code still says (FOC003) THE FIELDNAME IS NOT RECOGNIZED: ALLOCATIONMETH (I've tried all 3 fields after the varchar field and they all give the same error).
Here is the master for those fields above:
FIELD=PROCESS_DATE ,PROCESS_DATE,
YYMD ,DATE ,MISSING=OFF,$
FIELD=ALT_DEL_METHOD ,ALT_DEL_METHOD,
TX50 ,TX ,MISSING=ON ,$
FIELD=TOTALDESTS ,TOTALDESTS,
P2 ,P8 ,MISSING=ON ,$
FIELD=ALLOCATIONMETH ,ALLOCATIONMETH,
A1 ,A1 ,MISSING=ON ,$
FIELD=FREQ ,FREQ,
A1 ,A1 ,MISSING=ON ,$
How do I code the ALT_DEL_METHOD so that the fields are recognized after it. I did ask if the varchar field could be moved to the end, but that was not the solution they wanted to go with.
Thanks.
March 05, 2007, 12:31 PM
Pam KrattThis is the entire master file. As for the db2 create statement ... I have no idea. We have dbas on the db2 mainframe side that do the creation of the tables. I can ask for it, but it will probably take a couple of days to get. This table has been existing for quite a while, we're just starting to use these fields at the end of the master. ALT_DEL_METHOD is my problem field.
FILE=NBTBLSPH, SUFFIX=DB2 ,$
SEGNAME=NBTBLSPH, SEGTYPE=S0 ,$
FIELD=LUMPSUMID ,LUMPSUMID,
A20 ,A20 ,MISSING=ON ,$
FIELD=PLANNBR ,PLANNBR,
A12 ,A12 ,MISSING=ON ,$
FIELD=FEDTAXID ,FEDTAXID,
A9 ,A9 ,MISSING=ON ,$
FIELD=PYMTTYPE ,PYMTTYPE,
A2 ,A2 ,MISSING=ON ,$
FIELD=PSTGDTE ,PSTGDTE,
P8 ,P8 ,MISSING=ON ,$
FIELD=DSTRDTE ,DSTRDTE,
P7 ,P8 ,MISSING=ON ,$
FIELD=LUMPSUMSTATUS ,LUMPSUMSTATUS,
A1 ,A1 ,MISSING=ON ,$
FIELD=VALUDTE ,VALUDTE,
P7 ,P8 ,MISSING=ON ,$
FIELD=SHRTOT ,SHRTOT,
P11.4 ,P8 ,MISSING=ON ,$
FIELD=SCTYNBR ,SCTYNBR,
A9 ,A9 ,MISSING=ON ,$
FIELD=DSTRPCT ,DSTRPCT,
P4 ,P8 ,MISSING=ON ,$
FIELD=DSTRAMT ,DSTRAMT,
P14.2 ,P8 ,MISSING=ON ,$
FIELD=CPTLGAINAMT ,CPTLGAINAMT,
P14.2 ,P8 ,MISSING=ON ,$
FIELD=NONTAXAMT ,NONTAXAMT,
P14.2 ,P8 ,MISSING=ON ,$
FIELD=STWTHHIND ,STWTHHIND,
A1 ,A1 ,MISSING=ON ,$
FIELD=FEDWTHHAMT ,FEDWTHHAMT,
P14.2 ,P8 ,MISSING=ON ,$
FIELD=NETUNRLZAPPR ,NETUNRLZAPPR,
P14.2 ,P8 ,MISSING=ON ,$
FIELD=SHRPRIC ,SHRPRIC,
P11.4 ,P8 ,MISSING=ON ,$
FIELD=SHRCOST ,SHRCOST,
P11.4 ,P8 ,MISSING=ON ,$
FIELD=ORDINCMTAXAMT ,ORDINCMTAXAMT,
P14.2 ,P8 ,MISSING=ON ,$
FIELD=OTHERINCM ,OTHERINCM,
P14.2 ,P8 ,MISSING=ON ,$
FIELD=PYMTMETH ,PYMTMETH,
A2 ,A2 ,MISSING=ON ,$
FIELD=PYMTAMT ,PYMTAMT,
P14.2 ,P8 ,MISSING=ON ,$
FIELD=TAXCDE ,TAXCDE,
A3 ,A3 ,MISSING=ON ,$
FIELD=FACTCPTLGAINAMT ,FACTCPTLGAINAMT,
P14.2 ,P8 ,MISSING=ON ,$
FIELD=WTHHST ,WTHHST,
A2 ,A2 ,MISSING=ON ,$
FIELD=FEDWTHHIND ,FEDWTHHIND,
A1 ,A1 ,MISSING=ON ,$
FIELD=FACESHRVALU ,FACESHRVALU,
P12.4 ,P8 ,MISSING=ON ,$
FIELD=DSTRCAT ,DSTRCAT,
A2 ,A2 ,MISSING=ON ,$
FIELD=FIXSTWTHHAMT ,FIXSTWTHHAMT,
P14.2 ,P8 ,MISSING=ON ,$
FIELD=FIXFEDWTHHAMT ,FIXFEDWTHHAMT,
P14.2 ,P8 ,MISSING=ON ,$
FIELD=EXMNTOT ,EXMNTOT,
P3 ,P8 ,MISSING=ON ,$
FIELD=TAXSTAT ,TAXSTAT,
A1 ,A1 ,MISSING=ON ,$
FIELD=MISCINCOME ,MISCINCOME,
P14.2 ,P8 ,MISSING=ON ,$
FIELD=PLANNAME1 ,PLANNAME1,
A32 ,A32 ,MISSING=ON ,$
FIELD=PLANNAME2 ,PLANNAME2,
A32 ,A32 ,MISSING=ON ,$
FIELD=ISSUEDATE ,ISSUEDATE,
P9 ,P8 ,MISSING=ON ,$
FIELD=PAYOFFDATE ,PAYOFFDATE,
P9 ,P8 ,MISSING=ON ,$
FIELD=FIRSTPAYDTE ,FIRSTPAYDTE,
P9 ,P8 ,MISSING=ON ,$
FIELD=INTRATE ,INTRATE,
P10.6 ,P8 ,MISSING=ON ,$
FIELD=PAYAMT ,PAYAMT,
P13.2 ,P8 ,MISSING=ON ,$
FIELD=NUMOFPAYS ,NUMOFPAYS,
P5 ,P8 ,MISSING=ON ,$
FIELD=PAYFREQ ,PAYFREQ,
A1 ,A1 ,MISSING=ON ,$
FIELD=LOANSETUP ,LOANSETUP,
P13.2 ,P8 ,MISSING=ON ,$
FIELD=LOANMAINT ,LOANMAINT,
P13.2 ,P8 ,MISSING=ON ,$
FIELD=CHECKDESC1 ,CHECKDESC1,
A50 ,A50 ,MISSING=ON ,$
FIELD=CHECKDESC2 ,CHECKDESC2,
A50 ,A50 ,MISSING=ON ,$
FIELD=APR ,APR,
P11.6 ,P8 ,MISSING=ON ,$
FIELD=FINCHARGE ,FINCHARGE,
P13.2 ,P8 ,MISSING=ON ,$
FIELD=AMTFIN ,AMTFIN,
P13.2 ,P8 ,MISSING=ON ,$
FIELD=TOTOFPYMTS ,TOTOFPYMTS,
P13.2 ,P8 ,MISSING=ON ,$
FIELD=WHENDUE ,WHENDUE,
A30 ,A30 ,MISSING=ON ,$
FIELD=REQ_PAYDATE ,REQ_PAYDATE,
YYMD ,DATE ,MISSING=ON ,$
FIELD=LS_GROUPID ,LS_GROUPID,
A20 ,A20 ,MISSING=ON ,$
FIELD=ADMIN_GROUPID ,ADMIN_GROUPID,
A20 ,A20 ,MISSING=ON ,$
FIELD=FIRSTNAME ,FIRSTNAME,
A36 ,A36 ,MISSING=ON ,$
FIELD=MIDNAME ,MIDNAME,
A36 ,A36 ,MISSING=ON ,$
FIELD=LASTNAME ,LASTNAME,
A36 ,A36 ,MISSING=ON ,$
FIELD=SUFFIX ,SUFFIX,
A36 ,A36 ,MISSING=ON ,$
FIELD=INCAREOF ,INCAREOF,
A36 ,A36 ,MISSING=ON ,$
FIELD=ADRLNE1 ,ADRLNE1,
A36 ,A36 ,MISSING=ON ,$
FIELD=ADRLNE2 ,ADRLNE2,
A36 ,A36 ,MISSING=ON ,$
FIELD=CITY ,CITY,
A20 ,A20 ,MISSING=ON ,$
FIELD=ST ,ST,
A2 ,A2 ,MISSING=ON ,$
FIELD=ZIP ,ZIP,
A9 ,A9 ,MISSING=ON ,$
FIELD=COUNTRY ,COUNTRY,
A20 ,A20 ,MISSING=ON ,$
FIELD=DVSN ,DVSN,
A5 ,A5 ,MISSING=ON ,$
FIELD=REGNCDE ,REGNCDE,
A2 ,A2 ,MISSING=ON ,$
FIELD=PRTPSTAT ,PRTPSTAT,
A1 ,A1 ,MISSING=ON ,$
FIELD=DTHBENYTAXID ,DTHBENYTAXID,
A9 ,A9 ,MISSING=ON ,$
FIELD=BENYTOT ,BENYTOT,
P4 ,P8 ,MISSING=ON ,$
FIELD=BRTHDTE ,BRTHDTE,
P9 ,P8 ,MISSING=ON ,$
FIELD=USCTZNCDE ,USCTZNCDE,
A1 ,A1 ,MISSING=ON ,$
FIELD=NMEADRNBR ,NMEADRNBR,
A12 ,A12 ,MISSING=ON ,$
FIELD=NMELUMPSUMSTAT ,NMELUMPSUMSTAT,
A1 ,A1 ,MISSING=ON ,$
FIELD=NMEPERIODICSTAT ,NMEPERIODICSTAT,
A1 ,A1 ,MISSING=ON ,$
FIELD=TERMDTE ,TERMDTE,
P7 ,P8 ,MISSING=ON ,$
FIELD=PRTPDTE ,PRTPDTE,
P7 ,P8 ,MISSING=ON ,$
FIELD=PROCESS_DATE ,PROCESS_DATE,
YYMD ,DATE ,MISSING=OFF,$
FIELD=ALT_DEL_METHOD ,ALT_DEL_METHOD,
TX50 ,TX ,MISSING=ON ,$
FIELD=TOTALDESTS ,TOTALDESTS,
P2 ,P8 ,MISSING=ON ,$
FIELD=ALLOCATIONMETH ,ALLOCATIONMETH,
A1 ,A1 ,MISSING=ON ,$
FIELD=FREQ ,FREQ,
A1 ,A1 ,MISSING=ON ,$