DSXchange

Hash Partition (on F1 )and sort(and f1 and f3) in the input link of transformer.
Use following stage variables in the transformer.
Default value of all stage varibles should be 0

SVF1_1=F1
IF SVF11=SVF12 THEN SVF2= SVF2+1 ELSE 1
SVF12=SVF11

i cannot find the FMT() function in my designer

Hi, Can some one tell me how can i search a substring from behind,(i want to search for the 1st space from the end of a string) E.g. i want to split a note of more than 100 characters into 40 chars each. While doing so i want logically split the note, that means instead of truncating at the 40th Cha...

I am not sure of the official service provider. When i imported the metadata it gave longnvarchar (2147483647). We are using version8.1. I am able to 'view data' in the oracle connector. But when i try to insert data by doing 1;1 mapping in transformer for each field it is throwing the below error '...

Hi, Can some one tell me the maximum length of characters that oracle connector stage can read and process in datastage. I have 5 column maximum 12000 char each long(Clob datatype in oracle). i want to concatenate these columns and then split the note into 4000 characters each and create new records...

vishal_rastogi wrote: in transformer i am using if len(trim(link1.columnA)) = '' then 1 else 0

i am a little curious about this len()function. How can length be '', it can only be numeric value, right?

How about using if '' then 0 else as it is?

While readin the file you can read it as 'quoted' and while writing into the target mention it as no quotes.

I am sorry i was talking about trasforemer stage..

everytime you rerun the the sequence it gets a new process id, hence when you are rerunnng you receive this warning. If you check the director for the current paraments passed you will see this mentioned in the log as (current/ previous paramenter). In the sequence that you are rerunning you need to...

As it says, It locks the row(whichever has been read) does it allows to update the in the same process( i mean reading as reference and updating in same process) Yes , it allows the first process to update the rows And cannot be read the same row by any other process? but same row can be read n no....

you can use LPAD funciton to pad leading zeroes by mentioning the target length.(dont forget to add trim function for the input column)

If you read the response properly, SURA said 'If you want to take out, then you can make the mapped column as Int (You can use the function AsInteger(ColumnName)). ' Asinteger() will remove the leading zeroes. This may not be the best method but you can do Len(Column_Name)-Len(AsInteger(ColumnName))...

I am not sure as i dont have datastage access now, but you can try using 'column_name - 1' directly in trnsformer

which stage are you using..if you were using copy stage, this implicit conversion cannot take place in copy stage
After replacing with tranformer you need not write the timestamp to date functionas as this implicit conversion is handled by transformer

can you please explain in detail?