I am trying to read a value from CAR file in Infoassist.Code in OTHER section is as :
-DEFAULT &TEMP = ''; TABLE FILE CAR PRINT SEATS BY COUNTRY NOPRINT WHERE COUNTRY EQ 'ENGLAND' WHERE RECORDLIMIT EQ 1 ON TABLE SAVE AS HLD END -RUN -READ HLD &TEMP.I2. -TYPE &TEMP
I want to use the &TEMP value to Compute new field in my reporting object master file. But I am getting below error :
Code: 1067 Type: xPropertyValueQuery (FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: CAR BYPASSING TO END OF COMMAND 0 ERROR AT OR NEAR LINE 15 IN PROCEDURE abs_by_country_ctd (FOC339) DIALOGUE MANAGER -READ FAILED: CHECK FILEDEF OR ALLOCATION FOR: -READ HLD &TEMP.I2.
When I remove -READ line this code works. Can anyopne please suggest where I am going wrong. Please help.
Thanks in advance.This message has been edited. Last edited by: Kerry,
WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML
With the code supplied, my guess is that CAR master file is not in the path.
Also the value stored will be an alpha field, use &TEMP.A2.
Not sure if this was in by 7.6.11, but try this -
APP PREPENDPATH IBISAMP TABLE FILE CAR PRINT SEATS AS TEMP BY COUNTRY NOPRINT WHERE COUNTRY EQ 'ENGLAND' WHERE RECORDLIMIT EQ 1 ON TABLE HOLD AS HLD ON TABLE SET ASNAMES ON END -RUN -READFILE HLD -? &TEMP
Please, dear Focus users, don't use a semi-column with -DEFAULTS. -SET and -DEFAULTS are not to be melt in your bains.
-SET needs a semi-column in the end and just sets the value of a single DM variables.
-Defaults provides a value to a DM Variable, if nor previously setted. You may -Defaults more than one DM Variable on a single line, Comma will separate the different affectations by Default :
-DEFAULTS &QUAL1 = 'OLD', &QUAL2 = 'BORING'
One may be imprecise when playing with Focus, but, sometimes, one may pay the price for it. At least, it's my point of view
Cordially and Focusely
Focus Mainframe 7.6.11
Dev Studio 7.6.11 and !!!
PC Focus, Focus for OS/2, FFW Six, MSO
|Powered by Social Strata|