DSXchange

Argghhhhhhhh is right I should have checked that first thing. Thanks for the help that fixed my problem.

Didn't even think it could be a data type issue but it is a Char so thanks. i will change it to varchar2 and give it a go.

In my transformation I am hard coding a ORIGINAL_DATA_SOURCE and then sending the rows into the final staging dimension table through an insert or update. The initial insert works fine but I noticed the ORIGINAL_DATA_SOURCE included three spaces not established in the transformation. When testing up...

When assigning the Derivation GetEnvironment(%envvar%)

it doesn't like GetEnvironment($PPID) or GetEnvironment($$)

Is there a list of envvar that will work?

Im with ya now. Too bad the help isnt that descrptive.

I tried to right click on the stage variable and it would not work. I can set one up in the transformer properties where it asks for NAME...INITIAL VALUE...SQLTYPE...EXTENDED...Precision...SCALE...DESCRIPTION once defined there the system variable option becomes ungrayed and I can use the variable I...

Slowly but surely im catching on. I see i can set a system variable in the transformer properties.

I went back to the transformer and noticed that the stage variable selection is grayed out so maybe I do not have access to use that item. Or perhaps I need to set one up prior to it becoming available in the transformer.

I looked up GetEnvironment in the help and this is all it tells me. The following table lists the functions available in the Utility category (square brackets indicate an argument is optional): Name Description Arguments Output GetEnvironment Return the value of the given environment variable enviro...

Can I pass a variable from an ExecSH into datastage? My plan would be to pass echo $$ into a variable which I could then call within data stage. Is this possible?

Cool thanks ill give it a shot

Yeah I figured that if it was not available in the job I would have to grab it out of unix. Thanks

The one initiating the job should work.

Basically I would like to attach the PID from UNIX into our job so that the Change Data Capture log entries will contain the PID. I have looked at the DSMacro's in the transformer and they do not contain a very robust list of system variables. I have seen similar discussions on-line but no definitiv...

went back to the same job that compiled with no errors and tried to kick it off and it failed and has the same issues so maybe we do have the same issue as the other guy