Hi ,
I am trying to do inner join using merge stage and i am giving the directory paths for two files and file names at Output tab. i am having two sequential files. wen i run the job it is giving the following error
Program "DSP.Open": Line 122, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage Merge..Merge_0
DataStage Phantom Aborting with @ABORT.CODE = 3
Any help is really appreciated
Thanks in advance
merge stage
Moderators: chulett, rschirm, roy
Re: merge stage
Hi,rsunny wrote:Program "DSP.Open": Line 122, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage Merge..Merge_0
DataStage Phantom Aborting with @ABORT.CODE = 3
It seems that DataStage is not able to find the file, so check the path of the files that you have mentioned in Merge Stage and also make sure you have read permison on those files
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Check permissions using operating system commands/utilities. For example, using Windows Explorer permissions can be seen by viewing the Properties of the object, under the Security tab. Doubtless there's a DOS command also. You can also use UNIX commands such as ls -l because you have MKS Toolkit installed.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.