DSXchange

I changed the datatype in designer from numeric to nvarchar and i try to run the job i get the following: Error when checking operator: When binding output schema variable "resRec": When binding output interface field "NOMINATION_KEY" to field "NOMINATION_KEY": Implicit...

I changed the datatype in designer from numeric to nvarchar and i try to run the job i get the following: Error when checking operator: When binding output schema variable "resRec": When binding output interface field "NOMINATION_KEY" to field "NOMINATION_KEY": Implicit...

Hi,

I need to convert NUMERIC(10) datatype to NVARCHAR(10) in Parallel Job from desinger. when i change the type and execute it throws error.

is there a way to do it.

Thanks,
Vindy

Yes it works...

Thanks all...

StageVariable Derivation - Num(DSLink4.Src)

Target Derivation - < If (StageVar = 1) Then DSLink4.Src Else 'T' End>

even if i put like this it shows 'General Syntax Error'

StageVariable Derivation - Num(DSLink4.Src)

Target Derivation - < If (StageVar = 1) Then DSLink4.Src > i am getting error here.

i tried with Num(field) and stored it in stagevar

when i try to check like:

if (stagevar = 1) then
source_fld
else
'Txt'
end

it shows error

bgs_vb

i have a case

source_fld should be compared for numeric or text

if numeric then < populate into target_fld _1> and < put 'n' to target_fld_txt>

otherwise <populate into target_fld_2> and <put 't' to target_fld_txt>

how do i solve it.

Thanks,
bgs_vb

Hi,

can anybody tell me whether we can use if..then...else / CASE conditions in a stage variable..

thanks in advance.

bgs_vb

Hi,

I got RPC Daemon error while connecting to client. i told my adminstrator to restart the datastage server. but he could not start the server he is getting Win32.5 Error.

What could be the reason?

Vindy

Hi Gurus,

I get the following error in the Hash file.

"J_Stage_PS_S_BUS_UNIT_RC_CRM..HASH_PS_S_BUS_UNIT_RC.lkp_out: DSD.UVOpen Unable to open file HASH_PS_S_BUS_UNIT_RC."

Anyone could explain me why it happens so.

Vindy

Hi Craig,

I searched and also tried changing the IPC_TIMEOUT and IPC_BUF_SIZE parameters, but still get errors.

Vindy

well, the error happens like this :
J_Stage_PS_S_COUNTRY_TBL_CRM..IPC_in.source_in: ds_ipcopen() - call to CreateMutex() failed - The handle is invalid.

Hi,

I get the CreateFileMapping() error

how to solve that.

Vindy

Hi, I am getting the following error on running a seq job. ----------------------------------------------------------------------------------- J_Stage_PS_S_BUS_UNIT_RY_CRM..IPC_in.source_in: ds_ipcopen() - call to CreateMutex() failed - The handle is invalid. ----------------------------------------...