DSD.ODBLinkStats

pattemk · Post by **pattemk** » Mon May 20, 2013 7:14 am

Hi,

I am trying to migrate a server job in 7.5 to datastage v9.1.

The job input is a sequential file and the output is a sequential file.

The job uses a hash file stage also for cdc purpose.

There is one routine used in transformer

I am getting the below error

From previous run
DataStage Job 4814 Phantom 2428
DataStage Phantom Finished.
Program "DSD.ODBLinkStats": Line 376, Improper data type.
Attempting to Cleanup after ABORT raised in job XXXXXX
I do not have any idea on this error and what i should be doing.
Please let me know for any further information

Please advice

chulett · Post by **chulett** » Mon May 20, 2013 7:19 am

Can you post the routine code, please?

pattemk · Post by **pattemk** » Mon May 20, 2013 7:27 am

Code sample

Code: Select all

If IsNull(STAGECOM.ARR(ColNo)) Then
   Ans = @NULL.STR
End Else
   Ans = STAGECOM.ARR(ColNo)
End
Repeat
Return(Ans)

chulett · Post by **chulett** » Mon May 20, 2013 10:09 am

Hmmm.... looks like naughty stuff, the kind of thing that doesn't survive across major releases, and there have been two since it was created. Gonna have to defer this one to Ray or Kim.

And now you've edited it down to almost nothing.

ray.wurlod · Post by **ray.wurlod** » Mon May 20, 2013 1:18 pm

DSODB is the DataStage Operational DataBase, which supports the Operations Console.

I have not investigated version 9.1 in sufficient detail to state whether STAGECOM.ARR still has the same structure as in earlier releases - every time we've mentioned it in the past we've asserted that the vendor does not publish these details and reserves the right to change them at any time.

pattemk · Post by **pattemk** » Tue May 21, 2013 2:10 am

Hi Ray,

Just an FYI, There are few other server jobs within my datastage project (9.1) which uses this routine, all other jobs work fine with this routine except for this one particualr job. I was wondering if i may do some modifications with in this one job so that it will work fine.

The job has input and output as sequential files and there is one transformer in between where i am using this routine. Please advice if by changing the metadata for the columns might make it work.

ray.wurlod · Post by **ray.wurlod** » Tue May 21, 2013 5:34 am

No idea. It's YOU who is mucking around with STAGECOM.ARR - it's YOU who must decode whether what you're doing still maps onto the same structures as it used to in the Transformer stage code. I don't have your code, only you do.