I'm attempting to get values from the UNILEVELTREEHISTORY table based on a list of customerids created in the hold file V1, using 'IN FILE'. I keep getting ERROR (FOC006), THE FORMAT OF THE TEST VALUE IS INCONSISTENT WITH FIELD FORMAT: My code is below:
-SET &ECHO=ALL; SET EMPTYREPORT=ON SET ASNAMES=ON
TABLE FILE COMMISSIONUNILEVELTREE PRINT CUSTOMERID WHERE CUSTOMERID EQ 1450316; ON TABLE HOLD AS V1 END -RUN
TABLE FILE UNILEVELTREEHISTORY PRINT UNILEVELTREEHISTORYID CUSTOMERID MOVEDATE PREVIOUSSPONSORID WHERE CUSTOMERID IN FILE V1; END -RUN
Any tips on what I'm missing? ThanksThis message has been edited. Last edited by: FP Mod Chuck,
October 08, 2019, 12:38 PM
FP Mod Chuck
ModGuy31
Try ON TABLE HOLD AS V1 FORMAT ALPHA
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
October 08, 2019, 12:51 PM
ModGuy31
Thank you Chuck. That did it.
October 08, 2019, 04:47 PM
jgelona
If all the only way you are going to use V1 is in the where clause, you can use ON TABLE SAVE AS V1. This will not create a master and it will automatically be ALPHA format.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.