DSXchange

Kandy/Ray, Appreciate all your help and thanks for researching further in the issue. But unfortunatley even though my job have the same design as Kandy's (specified in the post) I am not able to see the columns in the sequential file (reject link). Do you think we need to install any fix pack to res...

Kandy, That's what I thought they should appear by default in the reject link. I looked in both reject tab of odbc connector stage and input column definations of sequential file (which is used to capture the rejects) and found RejectERRORCODE and RejectERRORTXT fields only. Interestingly, when I li...

Thanks for the quick responses! :) Based on your suggestions I am able to add Error Code and Error Desc fields to the metadata of the reject link but could n't see the actual fields from the odbc connector stage (Target). Is there any way we can get all fields from Odbc connector Stage in the reject...

Hi, I am working on DataStage 8.5 . In my requirement I am using odbc connector stage(Sql Sever DB) as a Target where I need to reject records that fail while loading data due to constraint violation etc. To perfom this I created a reject link and linked to a sequential file, but I am not able rejec...

Any thoughts about the issue? If needed I can open this as a new topic.

I'm in same situation Message Id:IIS-DSEE-TUXX-00002 Message: TRAN1_1,0: Internal Error: (xfer_->initialFixRunLength_f == initialFixRunLength):./../include/apt_internal/api/transfer_rep.h: 739: Buffer and schema variable padding do not match. Data corruption will occur. Traceback: Could not obtain ...

Hi Ravi..Thanks for the response...

I tried for one record but still have the same warnings.

Hello All, In my requirement I need to convert a input field(COL1) which is read as String(Varchar(8)) to JulianDay. Example of Input field value : 20110222 I used the following derivation in the Transformer. JulianDayFromDate(StringToDate(COL1,"%yyyy%mm%dd") ) I am getting the correct out...

Hi,

I see the issue is with the partitioning in Sort Stage.
Can you please suggest me what kind of partitioning type is preferred if the data is passing through Sort Stage?
I am getting correct output when I use the Execution Mode as "Sequential".

Thanks James! The second method worked for me with Slight modification. Code: Sv1: If keyChange =1 Then input.Col3 Else Sv1 Sv2: If ( keyChange =0 ) Then input.Col3 Else input.Col3 Sv3: If Sv2>= Sv1 then "TRUE" Else "False" Also in the Sort Stage I used Execution Mode as "Se...

You'd have to sort the records first based on your key column and then use Stage variables in a Transformer to do the comparison. Thanks for the response! I followed the above flow and sorted the input based on KeyColumn(Col2) and created a KeyChangeColumn. Below are the Stage variables that I crea...

Hello All, In my requirement I need to compare a value from 2 records having one Key column. For example: Col1 Col2 Col3 1 A 4000 2 A 5000 ..... I need to compare the Col3 value from both records. Col2 is the Key Column. If (Col3 value from the second record >= Col3 value from first record) then TRU...

Hi, I know this is known issue but, I was not able to resolve the issue from the search. In our source database the processes are sitting idle waiting to read from metastage_loc_info table which does not exist, because of that our jobs are extracting data at very low rate like 60records /sec. As sug...

Hi,

I am generating surrogate key and also using flat file option. But the initial value for next run is not coming from the flat file. it is taking some random value. Can you guys please help me in what i should give in the block size, I think that is something i am missing.
Appreciate your help.

I agree with Willams. In my jobs, I am also passing the sqlquery as parameter but I see no problem with '=' sign.
But whenever I need to use quotes I am used backslash operator.