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.

Hi Pam,
I don't have a ready solution for you but here is what i would try:
1. Take out the TX field from the master and see if you get the same error. If you do then it is not the TX field which is causing the problem.
2. I see that the TX field is 7K long. There was a time when there was a limitation of 4K. Do you have another DB2 table with a field less than 4K? What happens there?

This is a DB2 table, so I would normally rely on the Master generated by the Synonym Generator from the WF Web Console.

However, try making the varchar column the last column in the Master, for DBMS tables the sequence of columns in the Master does not matter.

I tried removing the 7000 byte field from the master and I still got the error. I also moved the field to the end of the master trying it as a tx field and other formats and still got the error.

There are 3 fields after the 7000 byte field and it doesn't matter which field I try to display ... each of them will give me an error.

Any other thoughts?

Pam,
Could you show the full DB2 CREATE TABLE statement and the generated MASTER file?

When you create a new field for TX50 field the alias name must be the same as the database name and the actual format must be TX.
Ex:
FIELDNAME=RELEASE_INFORMATION_COMMENT, ALIAS=RELEASE_INFORMATION_COMMENT, USAGE=TX50, ACTUAL=TX,
MISSING=ON,$
FIELDNAME=RELEASE_INFORMATION_COMMENT2, ALIAS=RELEASE_INFORMATION_COMMENT, USAGE=A4000, ACTUAL=TX,
MISSING=ON,$

This 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 ,$

Pam,

Ok. You say that you can display all the fields preceding ALT_DEL_METHOD.
Could you create a new MASTER and its ACX using only the last 3 fields and see if that works?

FILE=PAM, SUFFIX=DB2 ,$
SEGNAME=NBTBLSPH, SEGTYPE=S0 ,$
FIELD=TOTALDESTS ,TOTALDESTS,
P2 ,P8 ,MISSING=ON ,$
FIELD=ALLOCATIONMETH ,ALLOCATIONMETH,
A1 ,A1 ,MISSING=ON ,$
FIELD=FREQ ,FREQ,
A1 ,A1 ,MISSING=ON ,$

Going back a (long) while now...

Don't you have to have something like ENGINE DB2 SET CONVERSION LONGCHARS TEXT, or if you use AnnV for actual and usage, that might work.

sorry to waste everyone's time. It ended up this application that I'm helping out does not look at the masters on the local machine but on a server for the test environment. The master was not up to date on that server. It was the suggestion to change the master to just display the last 3 fields that found this out. Once I got the master updated on the server, all fields are now being displayed. Thanks for everyone's help.

The first rule in debugging a WebFOCUS program:

Determine which Program and Master are being used.

WHENCE CAR MASTER
WHENCE TEST1 FOCEXEC