I'm getting the following error:

NUMBER OF RECORDS IN TABLE= 6614532 LINES=6614532
0 ERROR AT OR NEAR LINE 69 IN PROCEDURE brenda_aFOCEXEC *
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: usedethold
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: USEDETHOLD
BYPASSING TO END OF COMMAND

Below is the code I'm using. Does anyone have any idea what might be causing the error? Thank you!

REMOTE DEST=DBWFRKV2

-MRNOEDIT BEGIN

-REMOTE BEGIN

DYNAM ALLOC DD USEDETX DS 'TL.P.RKV.D2.ARCH.USEDET(-2)' SHR REU

DYNAM ALLOC DD USEDET1 DS 'TL.P.RKV.D3.ARCH.USEDET(-2)' SHR REU

DYNAM ALLOC DD USEDET2 DS 'TL.P.RKV.D4.ARCH.USEDET(-2)' SHR REU

DYNAM ALLOC DD USEDET3 DS 'TL.P.RKV.D5.ARCH.USEDET(-2)' SHR REU

DYNAM ALLOC DD USEDET4 DS 'TL.P.RKV.D6.ARCH.USEDET(-2)' SHR REU

DYNAM ALLOC DD USEDET5 DS 'TL.P.RKV.D7.ARCH.USEDET(-2)' SHR REU

DYNAM ALLOC DD USEDET6 DS 'TL.P.RKV.D8.ARCH.USEDET(-2)' SHR REU

DYNAM ALLOC DD USEDET7 DS 'TL.P.RKV.D2.ARCH.USEDET(-1)' SHR REU

DYNAM ALLOC DD USEDET8 DS 'TL.P.RKV.D3.ARCH.USEDET(-1)' SHR REU

DYNAM ALLOC DD USEDET9 DS 'TL.P.RKV.D4.ARCH.USEDET(-1)' SHR REU

DYNAM ALLOC DD USEDET10 DS 'TL.P.RKV.D5.ARCH.USEDET(-1)' SHR REU

DYNAM ALLOC DD USEDET11 DS 'TL.P.RKV.D6.ARCH.USEDET(-1)' SHR REU

DYNAM ALLOC DD USEDET12 DS 'TL.P.RKV.D7.ARCH.USEDET(-1)' SHR REU

DYNAM ALLOC DD USEDET13 DS 'TL.P.RKV.D8.ARCH.USEDET(-1)' SHR REU


DYNAM CONCAT DD USEDETX USEDET1 USEDET2 USEDET3 USEDET4 USEDET5 USEDET6
DYNAM CONCAT DD USEDETX USEDET7 USEDET8 USEDET9 USEDET10 USEDET11 USEDET12 USEDET13



TABLEF FILE USEDETX
PRINT BAN_N
INV_D
R_TYP_I
RTE_I
BL_CYC_FR_D
BL_CYC_TO_D
REC_NUM_EO_C
USE_Q
USE_R
USE_A
JUR_I

-*WHERE INV_D FROM '20070201' TO '20070314';

ON TABLE HOLD AS USEDETHOLD

-RUN
-REMOTE END
-RUN



JOIN CLEAR *

JOIN BAN_N IN USEDETHOLD TO
MULTIPLE BAN_N IN MBANTAB AS J001
END

TABLE FILE USEDETHOLD
PRINT BAN_N
J001.TELCO
INV_D
R_TYP_I
RTE_I
BL_CYC_FR_D
BL_CYC_TO_D
REC_NUM_EO_C
USE_Q
USE_R
USE_A
JUR_I

WHERE J001.TELCO EQ
('450C' OR
'458C' OR
'4644' OR
'5084' OR
'530C' OR
'587C' OR
'6053' OR
'6059' OR
'6123' OR
'6329' OR
'635C' OR
'653C' OR
'7035' OR
'7075' OR
'7125' OR
'7135' OR
'7136' OR
'7138' OR
'7139' OR
'7140' OR
'7142' OR
'7143' OR
'7144' OR
'7145' OR
'7146' OR
'7147' OR
'7148' OR
'7194' OR
'7213' OR
'7216' OR
'7217' OR
'7218' OR
'7308' OR
'7309' OR
'7310' OR
'7314' OR
'7315' OR
'7325' OR
'7351' OR
'7378' OR
'7421' OR
'7529' OR
'7530' OR
'7531' OR
'7532' OR
'7658' OR
'7678' OR
'7679' OR
'7680' OR
'7681' OR
'7682' OR
'7683' OR
'7684' OR
'7685' OR
'7686' OR
'7687' OR
'7688' OR
'7689' OR
'7690' OR
'7691' OR
'7692' OR
'7693' OR
'7694' OR
'7695' OR
'7696' OR
'7697' OR
'7698' OR
'7699' OR
'770E' OR
'7808' OR
'7890' OR
'7891' OR
'7921' OR
'7922' OR
'7923' OR
'7924' OR
'7925' OR
'7926' OR
'7927' OR
'7928' OR
'7929' OR
'7930' OR
'7931' OR
'7932' OR
'7933' OR
'7934' OR
'7935' OR
'7941' OR
'7942' OR
'7962' OR
'7963' OR
'7964' OR
'802C' OR
'8271' OR
'8299' OR
'8300' OR
'8344' OR
'8389' OR
'8392' OR
'8405' OR
'8406' OR
'8418' OR
'8419' OR
'8420' OR
'8500' OR
'8995' OR
'8822' OR
'ATNT');

ON TABLE PCHOLD FORMAT HTML
END

Brian,

Is there an END missing from your first request, or am I just blind and can't see it? There should be one at the end of the first TABLE FILE request.

Regards,
Mika

quote:

USEDETHOLD

Is there a mainframe FOCUS restriction on the number of characters of a filename, 8 perhaps?

Francis,

I don't believe that is the problem as I've used filenames with more characters than USEDETHOLD in the past that worked.

quote:

(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: USEDETHOLD

Do you have your HOLDMAST ALLOCated?? MASTER???

HOLD masters are written to HOLDMAST unless that PDS is concatenated to MASTER DDNAME and you do not have write permissions to the MASTER PDS. Should be separate DDNAME's...

On an IBM mainframe a DDNAME can be from one to eight characters long, so I'm not sure how a hold file name of more than eight characters would work...

Gonna throw out some stuff here - justtrying ot help.
Place an end before ON TABLE HOLD AS USEDETHOLD
Also,mainframe did have an 8 character name restriction at one point. I thought that was to be extended to 16 but not sure on that one.

I would break up the code step by step and see where code works and when it stops.
I have not used tso/mvs in over 10 years (shh dont tell anyone-lol) but here goes my .02

try a ? tso ddname to see what you allocated..
assume nothing is allocated automatically
did you allocate your own sorting space? did you allocate enough?
curious if you tried only dynam concat on say 5 datasets (i know you are nowhere near the limit. But I always try to get small stuff to work then expand. How about shortening the 'where' list. these are some basics that you may have already tried.

if you place a -exit after -remote end. do you get results or error message? if results, then go to next step and stop job there, etc...

Ira Unix 5.3.6

Are you not passing the request to wfserver DBWFRKV2 to create the HOLD file with -REMOTE BEGIN and then returning to the default wfserver.

Since the default server will not have the same filesystem you will have to copy the hold file and master from the remote server or extend the -REMOTE END

Hammo1j is on the right track. What you need it to change ON TABLE HOLD AS USEDETHOLD to ON TABLE PCHOLD AS USEDETHOLD - this sends the hold file back to the "host" system. You are executing code in a REMOTE environment. When it finishes you just hold the file which holds it on that remote environment. Then you try to run a fex on the local system against data on the remote system - won't happen. The on table pchold when used with the -REMOTE execution sends the data and MFD back to the "calling" or "host" environment so you can do further processing.