Page 1 of 1

Phantom problem

Posted: Wed Nov 15, 2006 9:50 am
by sainath
Hi
I am geting phantom error in transformar stage .IMPROPER DATATYPE.

1.I went into project directory and found the below code in my job
trim(Change(XYPGALTNBR, XYPGALTCHAR, " "))
my aim is to trim the first character from the string .so i store in stage variables.
XYPGALTNBR - string
XYPGALTCHAR- first charc of string

2. I move the above code and if i run again .i am getting same error in other line.
IF NOT(STAGECOM.STAGE<STAGE.VAR.INITED,12>) THEN
STAGECOM.STAGE<STAGE.VAR.INITED,12> = @TRUE
V58S2.Stagevar%%12 = 0
please share your thoughts.
thks

Posted: Wed Nov 15, 2006 10:11 am
by ArndW
Where in the job is your trim code? In a stage variable? A derivation? It is more efficient to use the function "In.YourString[2,999]" to remove the first character from a string in DataStage.

Does it mean if you remove this one line then your program compiles and runs without a problem?

Posted: Thu Nov 16, 2006 8:11 am
by sainath
HI
Thanks for your reply .
if i change the code to "In.YourString[2,40]" to remove first char of a string there is no phantom error.
thks