As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
TABLE FILE ACR_DATA
PER1 AS ''
PER2 AS ''
COMPUTE DIFF1/P32BS = PER2 - PER1; AS ''
PER3 AS ''
PER4 AS ''
COMPUTE DIFF2/P32BS = PER4 - PER3; AS ''
PER5 AS ''
PER6 AS ''
COMPUTE DIFF3/P32BS = PER6 - PER5; AS ''
BY SRTING NOPRINT
BY ORGANIZATION_LEVEL_3 NOPRINT
BY DEPARTMENT_CODE NOPRINT
BY SUBJECT NOPRINT
ON SUBJECT SUBHEAD
That is throwing this error:
0 ERROR AT OR NEAR LINE 383 IN PROCEDURE rom_proj_inst_plan
(FOC003) THE FIELDNAME IS NOT RECOGNIZED: PER4
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT
because I'm finding that PER4 and PER6 columns may not be in the file: ACR_DATA
Anyone have any creative ways to work-around and perform the COMPUTE only if the column exists?This message has been edited. Last edited by: globalwm,
8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel