DSXchange

Hi,

I tested for a Job containing Universe Stage on my Local Machine.(i.e Server installed on My Local Machine).
But when i tried the same job on our Production Server, it gave error.

sample1..UniVerse_13.IDENT1.DSLink8: DSD.BCIPut call to SQLExecute failed.
SQL statement:UPDATE "T2RngGT" SET RNG_TYP_NME = ?, RNG_CDE = ?, RNG_CDE_DESC = ?, RNG_LWR_LMT_NBR = ?, RNG_UPR_LMT_NBR = ?, PRCS_DTE = ? WHERE (RNG_TYP_NBR = 1)
SQLSTATE=S1000, DBMS.CODE=930164
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: Parameter marker 2 does not match expected data type.
SQLSTATE=S1000, DBMS.CODE=930121
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: CursorDefineParam failure.

For using Universe Stage do we need to alter some setttings.

Gokul

Is it a user-defined SQL. Check the data type of second column in the link.

It looks like the table (UniVerse file) is declared differently in each environment. Use the Manager to read in the column descriptions in both environment and compare them.

Specifically, check that the data type if RNG_CODE is the same in DataStage as it is in UniVerse. This is the column name associated with the second parameter marker.

Always read everything in the error message.