I am having trouble deciphering an error message I'm receiving in a parallel job. The job has an inner join stage with two Oracle stages as the sources for the join. The first Database stage ahs a simple SQL select as the data source. The second stage has the following:
SELECT
EVENT_PARTICIPANT_MONITORED_LG.Event_Participant_ID ,
EVENT_PARTICIPANT_MONITORED_LG.Monitored_Leg_ID,
EVENT_PARTICIPANT_MONITORED_LG.On_Board_Status ,
EVENT_PARTICIPANT_MONITORED_LG.Armed_Status ,
EVENT_PARTICIPANT_MONITORED_LG.Confirmation_Call_Attempts,
EVENT_PARTICIPANT_MONITORED_LG.Confirmation_Call_Success ,
EVENT_PARTICIPANT_MONITORED_LG.Last_Confirmation_Call_Status
FROM EVENT_PARTICIPANT, EVENT_PARTICIPANT_MONITORED_LG , MONITORED_LEG
WHERE
EVENT_PARTICIPANT.ID=EVENT_PARTICIPANT_MONITORED_LG.EVENT_PARTICIPANT_ID AND EVENT_PARTICIPANT_MONITORED_LG.MONITORED_LEG_ID=MONITORED_LEG.ID AND
MONITORED_LEG.DEPARTURE_DATE>= #$date_last_updated#
When I run the job, I get the following message:
main_program: Data set, file set, or file "DBS_EVENT_PARTICIPANT_MONITORED:lnk_Evt_Participant_Monitored.v": Non-pipe (or non-virtual data set) with .v in its name [sil\step_il.C:8454]
Data set, file set, or file "DBS_EVENT_PARTICIPANT:lnk_Evt_Participant.v": Non-pipe (or non-virtual data set) with .v in its name [sil\step_il.C:8454]
The thing is, I am not finding ".v" anywhere in the job. lnk_Evt_Particiapnt_Monitored is the name of the link coming out of the database stage to the join.
Anyone have any clue as to what this means??
Thanks!
Need Error Message Help
Moderators: chulett, rschirm, roy
Re: Use Escape character
looks like a special character dichiper issue. i see there are 2 issueswhenry6000 wrote:I am having trouble deciphering an error message I'm receiving in a parallel job. The job has an inner join stage with two Oracle stages as the sources for the join. The first Database stage ahs a simple SQL select as the data source. The second stage has the following:
SELECT
EVENT_PARTICIPANT_MONITORED_LG.Event_Participant_ID ,
EVENT_PARTICIPANT_MONITORED_LG.Monitored_Leg_ID,
EVENT_PARTICIPANT_MONITORED_LG.On_Board_Status ,
EVENT_PARTICIPANT_MONITORED_LG.Armed_Status ,
EVENT_PARTICIPANT_MONITORED_LG.Confirmation_Call_Attempts,
EVENT_PARTICIPANT_MONITORED_LG.Confirmation_Call_Success ,
EVENT_PARTICIPANT_MONITORED_LG.Last_Confirmation_Call_Status
FROM EVENT_PARTICIPANT, EVENT_PARTICIPANT_MONITORED_LG , MONITORED_LEG
WHERE
EVENT_PARTICIPANT.ID=EVENT_PARTICIPANT_MONITORED_LG.EVENT_PARTICIPANT_ID AND EVENT_PARTICIPANT_MONITORED_LG.MONITORED_LEG_ID=MONITORED_LEG.ID AND
MONITORED_LEG.DEPARTURE_DATE>= #$date_last_updated#
When I run the job, I get the following message:
main_program: Data set, file set, or file "DBS_EVENT_PARTICIPANT_MONITORED:lnk_Evt_Participant_Monitored.v": Non-pipe (or non-virtual data set) with .v in its name [sil\step_il.C:8454]
Data set, file set, or file "DBS_EVENT_PARTICIPANT:lnk_Evt_Participant.v": Non-pipe (or non-virtual data set) with .v in its name [sil\step_il.C:8454]
The thing is, I am not finding ".v" anywhere in the job. lnk_Evt_Particiapnt_Monitored is the name of the link coming out of the database stage to the join.
Anyone have any clue as to what this means??
Thanks!
a)missing quotes
b)try to use escape character. see
character, which is an escape character\
Code: Select all
MONITORED_LEG.DEPARTURE_DATE>= '#\$date_last_updated#'
regards,
Prabu[/code]
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA