Simply want to append the contents of the first hold file to the second. Fields are of similar type. I can not seem to get the syntax right....Suggestions...

DEFINE FILE FIN_LVPG_PRD_GL_VW
CHGS/D12.2=0;
END

TABLE FILE FIN_LVPG_PRD_GL_VW
SUM FIN_LVPG_PRD_GL_VW.FIN_LVPG_PRD_GL_VW.PRD_AMOUNT AS BADDEBT
CHGS
BY LOWEST FIN_LVPG_PRD_GL_VW.FIN_LVPG_PRD_GL_VW.FISCAL_YR AS FY
BY LOWEST FIN_LVPG_PRD_GL_VW.FIN_LVPG_PRD_GL_VW.MTH_KEY AS PERIOD
BY LOWEST FIN_LVPG_PRD_GL_VW.FIN_LVPG_PRD_GL_VW.LVPG_IDXBANBR AS BANBR
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS HOLDBADDEBT FORMAT ALPHA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
ENDSTYLE
END
DEFINE FILE TBLMSTR_CHGS
BADDEBT/D12.2=0;
END
TABLE FILE TBLMSTR_CHGS
SUM
BADDEBT
TBLMSTR_CHGS.TBLMSTR_CHGS.TTLCHGS AS CHGS
BY LOWEST TBLMSTR_CHGS.TBLMSTR_CHGS.FISCALYEAROFINVCREPD AS FY
BY LOWEST TBLMSTR_CHGS.TBLMSTR_CHGS.INVCREPD AS PERIOD
BY LOWEST TBLMSTR_CHGS.TBLMSTR_CHGS.RPTBANBR AS BANBR
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS HOLDCHGS FORMAT ALPHA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END

TABLE FILE HOLDBADDEBT
PRINT
FIN_LVPG_PRD_GL_VW.FIN_LVPG_PRD_GL_VW.PRD_AMOUNT
CHGS
FIN_LVPG_PRD_GL_VW.FIN_LVPG_PRD_GL_VW.FISCAL_YR
FIN_LVPG_PRD_GL_VW.FIN_LVPG_PRD_GL_VW.MTH_KEY
FIN_LVPG_PRD_GL_VW.FIN_LVPG_PRD_GL_VW.LVPG_IDXBANBR
ON TABLE HOLD
MORE
FILE HOLDCHGS
END

*errors out:
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
0 NUMBER OF RECORDS IN TABLE= 1339 LINES= 1339
0 ERROR AT OR NEAR LINE 44 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC003) THE FIELDNAME IS NOT RECOGNIZED:
FIN_LVPG_PRD_GL_VW.FIN_LVPG_PRD_GL_VW.PRD_AMOUNT
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT



I tried using the the 'as' names...same error....

This message has been edited. Last edited by: <Kathryn Henning>,

When using the MORE command, all the fieldnames and formats MUST be the same.

You also cant use fully quallified field names.

Another option is to TABLE HOLD FORMAT ALPHA the first file, re-FILEDEF the HOLD FILE to APPEND mode, and TABLE SAVE the second file.

ok wait...confused...I thought I had each HOLD file set up with the exact same names! By using 'As fldnm'.

I tried using something like this but it yeilded the error in the same spot...this time on BADDEPT..

TABLE FILE HOLDBADDEBT
SUM BADDEBT CHGS
BY FY PERIOD BANBR
MORE
FILE HOLDCHGS
.
.
.
errors out not recognizing BADDEBT...

Thanks Waz!

Are you using SET ASNAMES = ON and SET HOLDLIST = PRINTONLY?

THANKS!

So...
ON TABLE SET ASNAMES ON
ON TABLE SET HOLDLIST PRINTONLY

I assume ASNAMES uses the names I assign...what does the HOLDLIST do? I will give it a go soon!

btw, the code gets further..I now get a more helpfull error message:
0 ERROR AT OR NEAR LINE 47 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC957) FORMAT MISMATCH FOR THE FIELD: BADDEBT


When I hover over column: BADDEBT in my table, it is PACKED 20.2...I believe I just need to determine the syntax to change:

DEFINE FILE TBLMSTR_CHGS
BADDEBT/D20.2=0;

to a similar type....

quote:

IP

Ignored post by RobertF posted January 09, 2014 08:56 AMShow Post

Powered by Social Strata

********CLOSED
all is working!

Hi Robert,

Can you edit your first post in this thread and add [CLOSED] to the title.

Hi @RobertF,

I generally include these commands when I create HOLD files. They work well for me as "defaults".

ON TABLE SET ASNAMES ON:
As you said - if you specify an "AS" name for a column, then the field in the HOLD file will have that name.

ON TABLE SET HOLDLIST PRINTONLY
This tells WebFOCUS to only write the columns that you would have seen on the report (e.g. if it was an online report) to the HOLD file.

For example, if your report uses "NOPRINT" or COMPUTE statements that refer to columns that aren't being printed, then the default would normally have been to write these "hidden" columns to the HOLD file.
This command overrides that default - so the "hidden" fields don't make their way to the HOLD file.