DSXchange

What sort of stages are you using? Are you loading lookup filesets in the job? If you turn off combination does the error point to a particular stage?

laknar - that didn't help clarify your problem at all. What stages are you using? are you calling functions from a transform stage? Are any of your string columns nullable?

Yes, that could be. You are missing at least one library in your libpath.

What values are you seeing for the text columns defined as value spaces? Are they all the same character and if so, which one? Have you checked to make 100% certain that your file on the UNIX box is actually still in EBCDIC and not in ASCII (this would explain a binary transfer with COMP-3 columns b...

You need to also execute your $DSHOME/.dsenv file in order to set your environment settings for libraries and path.

Although there is no equivalent PX/EE function for the BASIC "FMT" there is usually no need to use one. PX will perform automated input conversions. Do you need to perform a specific output conversion?

DataStageSolutions - I tend to take the best of both worlds in this case. I will always place the hashed files (regardless of initial or expected size) in a different directory. But I will then put a remote pointer to the hashed file in the project VOC so that I can use normal commands. Filling up t...

Ahh, I neglected to think about the inability to write nulls to a sequential file. If you change the date output to 9999-12-31 (are you 100% that is your correct default date format?) and check the output file, do you have 9999-12-31 in that column?

A sequencer can have 1 or many inputs and one output. The two choices are "any" or "all". "Any" means that the output is triggered when the first input link produces a row, "All" means the output is not triggered until all inputs have triggered.

vinbhate, I now marked the post as non-premium.

What happens when you try to execute the shell script manually from a shell? Any error messages? Basically your script is returning error code 139 which DataStage cannot handle and aborts. You could try resetting your job and looking at the log entry "from previous run" to see if there is a detailed...

Krishna, A "Job Sequence", sometimes called just a Sequence, is a DataStage job type usually used to control other jobs or activities or routines. The Sequencer is a stage used in a Job Sequence which allows parallel processing streams to merge back together. Or did you wish to ask another question

Hello Vishal,

Have you made any progress on this error? I think that nobody else has seen that specific problem, otherwise you would have received an answer by now. But if you have solved it you could benefit the forum by posting the cause and resolution. Thanks!

I've never had to use the debug mode; but perhaps if you explained what is going wrong (i.e. RPC daemon not running) the debug output might help.

What happens when you just specify a nullable column and set none of the optional attributes?