DSXchange

devidotcom wrote:Well.. guess its vertical pivot.

Please elobrate how to use pivot stage in this case..

Vertical Pivot is available only in 8.5

The SIGSEGV has returned to haunt this job again. The error message is StageName,2: Operator terminated abnormally: received signal SIGSEGV. The StageName corresponds to the target ODBC stage where deletes are happening. I changed the job to single node and it ran fine. But tooooo slow.. How can I r...

The ODBC stage has just one reject link. There is no other output

Just curious to know why it is not working with the Clear Partitioning option on the output of ODBC. Why do I need to add another stage just for the sake of it ?

Actually the error contains the stage name of the sequential file, I edited it out while pasting here. So it is confirmed that it is the operator for the sequential stage

Are the column data types of the target DB2 in sync with your source data? If yes, you can just import the metadata and do a straight move. If there are any not null fields in your target, you may need to handle nulls in transformer before loading the DB2.

What exactly is your requirement? What is the stage you are using to read the data ? What is the target? Please provide more details

Ravi.K wrote:Check at Sequential file stage (Reject link) Preserve Partitioning, Is it Clear or Set. if it is set then make it to clear and try.

It is clear. As I already mentioned in my above post, the ODBC stage preceding the Seq file stage has Preserve Partitioning as Clear.

Sequential File stage does not understand nulls. So you have to handle it. Inside Sequential File Stage Properties, go to columns and then double click on the left hand side of the required column name. In that you will find a "Nullable" property. Set a Null Field Value for that. It can be...

Read it as varchar in the source stage. Have a transformer and use function StringtoDate(Source, "%dd%mmm%yy"). In the target use data type as Date

Parallel job joining two tables using Join Stage. Data loaded into target ODBC which has a reject link. The rejects are being captured in sequential file. Preserve Partitioning is cleared in ODBC. Input Partitioning is Round Robin in Sequential Stage...Getting warning "When checking operator: A...

i have a sequence containing a routine activity and job activity. The routine activity is calling a server routine. Code of that routine is $INCLUDE DSINCLUDE JOBCONTROL.H *Initialize variables varJobName='' varJobStatus='' varRetVal='' varDelimitor=',' varReturn='0' varStartTime='' varEndTime='' va...

Strangely, when I ran the job today, it went off fine. The only change I did was setting APT_DISABLE_COMBINATION =True. This I did, so that I could know exactly where the error is coming. I was planning to run the job and then paste "the complete, unedited error message here" as chulett wa...

I tried hash partitioning on target ODBC where delete is happening. The key used in partition is the same on which index is created on the table and also used in Where statement.

I am getting SIGSEGV error and job is aborting. Please help