 |
|||||
|
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. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| issue with printing TABHEAD | Login/Join |
| Platinum Member |
Hi All My code goes like this , *********************************************** TABLE FILE HOLD IBD AUDIT_ACTION_DESCRIPTION AS 'ACTION' COL_NAME AS 'COLUMN NAME' OLD_VALUE AS 'OLD VALUE' NEW_VALUE AS 'NEW VALUE' modby AS 'MODIFIED BY' BY PRIMARY_KEY_DATA ON TABLE SUBHEAD "ABC" END ************************************************ I am getting an error like, ************************************************ 0 ERROR AT OR NEAR LINE 10 IN PROCEDURE __WCFEX FOCEXEC * (FOC013) THE 'ON FIELDNAME' FIELD IS NOT A SORT FIELD: SUBHEAD BYPASSING TO END OF COMMAND (FOC009) INCOMPLETE REQUEST STATEMENT ************************************************ Can anyone help this out?? Thanks Gobi WebFOCUS 7610 Windows | ||
|
| Expert |
Gobi, Are you sure that it is this TABLE request to which WebFOCUS is objecting or a previous one? There is no ON FIELDNAME in that oart of your program so it is unlikely that the error is as a result of this particular section of your code. To ensure that error messages are issued at the relevant point within the sysprint make sure you have a -RUN after each TABLE request END statement. T
| |||||||||
|
| Member |
Tobi, you get this error if you have a fieldname TABLE in your hold file or DEFINE statment, Mika | |||
|
| Platinum Member |
Hi Mashal, Yes Mashal ... i have the field name in my Hold file ..... How to overcome this issue ? WebFOCUS 7610 Windows | |||
|
| Expert |
Gobi, Rule of thumb, never use reserved words as alternatives for fieldnames. True of any language!! Way forward? Change the fieldname equal to TABLE - if indeed that is what you have. Also, if you want to SUBHEAD on change of this field, include it as a BY statement with or without NOPRINT. T
| |||||||||
|
| Member |
Tobi, if I were you I would change the name in hold file - using reserved words as fieldnames causes a lot of trouble, -Mika | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only Topic | View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |