Hi,
I have created a routine in Datastage, basically a transform function type.It is compiled and tested properly; but, when i am using in transformer stage the job is getting aborted without proper information in the log.fyi, i have tested the routine by creating a direct input file to output file transformation with transformer stage in between.
I am not sure whether there are any limitations on 8x server jobs for using routines inside the expression or stage variables section in transformer stages. Please help...
Log info:
DataStage Job 1107 Phantom 28708
The locks necessary for database operations at the current isolation
level (0) are not held by this process.
Rolling back uncommitted transactions begun within this execution environment.
Attempting to Cleanup after ABORT was raised in stage PAR003_CONDITION_STG_To_ALG_SRV2..Transformer_67
DataStage Phantom Aborting with @ABORT.CODE = 3
DS Routine issue - Job aborting
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: