ported jobs from 7.5x2 to 8.01.x;getting a strang error

[muascdev]

i am getting the following error;DataStage Job 138 Phantom 9612

Program "DSP.Open": Line 122, Exception raised in GCI subroutine:

Access violation.

Attempting to Cleanup after ABORT raised in stage J07_INSERT_INTO_MDM_NODE_M..Copy_of_DUAL

DataStage Phantom Aborting with @ABORT.CODE = 3


All i am doing is getting the seq number from dual; i am using link partioner and link collector in this job; any help is appreciated

[muascdev]

this issue is resolved; problem was in 7.5.2 sql used to be where num=:num in 8.x it needs to be ?

[muascdev]

the problem was actually table name not being specified