DSXchange

Here are the properties of my Merge state: Merge Keys: Key = One Sort Order = Ascending Options: UnMatched Masters Mode = Keep Warn On Reject Updates = False Warn On UnMatched Masters = False I have 2 links with 1 PK with the same name in both links. This column is a char column. Virtually all rows ...

I changed the "Unmatched Masters Mode" to Keep. However, this way the all rows go to the matched link and the reject link. I would think that allmost all rows should go to the matched link and only a few should go to the reject link.

Ray and Havoc, thank you for your responses. Ray, How do I capture the dropped rows? In the corresponding reject link? In my job, it looks like even when the rows are matching, it is populating the reject file only. The matched file remains empty. I'll post the score in a minute.

I have a job with 2 input files. One Master file and one update file. I want to use the Merge stage like an inner join. The reason I am not using a Join stage is because Join does not allow a reject link which I need. My questions are: 1)It is mentioned in the Developer's guide, page 20-2, that choo...

2 more questions: 1) The 3 parameters, stage_label.$ErrSource, stage_label.$ErrNumber and stage_label.$ErrMessage, do they get logged automatically in the log for the sequence job? I would assume that the Message Text in the Terminator Activity stage also gets logged. 2) How do you raise an error to...

Also, what is the difference between "Executed OK" and <JobName>.$Status = 1? I would think that "<JobName>.$Status = 1? (Finished)" is the same as "Executed OK and/or Execution finished with warnings".

The Exception Handler does not accept any input links whereas the Terminator stage does. 1)Does that mean that we put the Exception Handler anywhere on the sequencer? 2)Does this mean that whenever an exception occurs, that is an execution status other than OK in a job activity or execute command st...

I have 2 questions: 1)The Exception Handler CAN be used to execute a path (other job activities and execute command stages) in the job sequence after a certain exception occurs. Right? 2)An Exception Handler CANNOT be connected to a job activity/execute command activity stage whereas a Terminator ca...

I tried by giving DOS Line terminator as well. Still the same error.

One note. 2 of the 3 source file stages of the job are datasets and 1 sequential file. They are all going into a join.

Record Level:
Final Delimiter: None
Record Delimiter: Unix Newline

Field Level:
Delimiter: None

The error I get is: ##I TFCN 000001 11:47:47(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.1A Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved ##I TUTL 000031 11:47:47(001) <main_program> The open files limit is 1024; raising to 65536. ##I TOSH 0...

If Field Width for display size, why do I get the error message then? It overrides the value specified in the Length column. Where would I set the SQL precision, i.e., where does Datastage read the actual value of the column size from?

I would like to get a value from a Unix text file by using a before-job subroutine as: cat FileName1 I would like this value to be the initial value of a stage variable in the job. I know that I can have a sequence job and call this in a exec command stage and then call the job in a job activity sta...

I found the reason and it is definitely a strange one. On the columns tab of the sequential file stage, I rightclicked and added Field Properties. This opens the Edit Column Meta Data window. On this window, the Field Width property for the last column is 10 eventhough on the Columns tab, I specifie...