DSXchange

What is the trick to load in variable block data using the complex file stage? I see the variable block dropdown option, but I do not know how to import a variable block layout. Has anybody done this before?

how do I do that?

If it's in the limits section when you run the job then it doesn't seem to work. It puts in a Fatal entry to the log and it continues processing.

I looked for something like that and all I found is the "abort after X warnings" setting when you run a job. But when I set it to 1 then it added an error entry to the log, but the job continued and finished with a status of "Finish with warnings". I also thought that a message h...

I am trying to make DB2 UDB API stage rollback when there is bad data that gets rejected by DB2, but it does not. It just creates a warning and continues inserting the rest of the records. For examlpe out of 200 records 10 have a bad date. DB2 inserts 190 instread of rolling back to the last success...

When changing the value of a column in a build op where the input column name is the same as the output column name I get this warning: When checking operator: Dropping component "COLUMN_NAME" because of prior component with same name -My input schema and output schema are the same. -I hav...

step 1 - Within your server/parallel job write the summary record to a text file. 1 file for trailed and another file for the calculated sum. step 2 - Then in the sequence job write a routine to read in the two files and compare the output. Use a condition activity to change your work flow as needed.

search for: "Limiting access to only view the job log."

With server jobs, if you don't release them then they will not be runnable for operator users (according to Ray). However, parallel jobs don't have a concept of being released so you're stuck making an interface.

the source is a data set.
the target is an xml output stage.
the only other stage is an intermediate transformer stage.

It's a mix of data types, but I don't think it's a data type problem because the exact same data runs okay and other times it does not (with the exact same data).

We have opened a ticket with IBM, but if they do not come up with anything then I will simply generate the XML in a transformer stage.

I hope someone comes through with a solution

yah, char will pad all unused bytes with CHAR(0). Trim does not remove them. I use the convert function:

convert(char(0),'',inputcolumn)

I'm getting this error in the XML Output stage: Operator terminated abnormally: received signal SIGSEGV The catch to this is that I don't always get the error. Somedays it works and some days it does not (with the same input). I've never had this problem before in other jobs, but this time the job c...

ds_team wrote:if i restart the main job. is this possible.

No, if you reset the job then it will run from start. What you need to do is run it again without reseting and it will continue from where it left off. This is assuming that you check of that the job is restartable in the job properties window.

You can do one of two things. To make columns null when there is no match you need to set the column to nullable. To assign default values you need to go to the columns tab and double-click on the box with the column number to open the meta data editor.

I don't have an answer, but I have had this problem before. Lots of times in the windows version. It is usally due to a bug in the job that causes it to use up a lot of memory. However sometime there is no reason for it. I've contacted IBM support about it and they had no answers. Other then clear y...

What options did you compile your C++ routine with?

I had a similar problem before and it was resolved when I recompiled without any extended compilation options. (not the datastage job, but the routine itself).