DSXchange

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

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

Hi,

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

Try to view data from Datastage designer. If any permission issues or filepath issues then it will throw you the error.

There's no "View Data" from the Merge stage.

Hi ,

I checked my file path and it is correct and how do i check whether the files have read permissions or not and as craig said the View Data is in disable mode.


Thanks in advance

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.