DSXchange

There are many simmilar combination. But to get a efficient idea related to above comination would more then enough to progress on rest.

Can you suggest any idea on below requirement The below criteria/keyword i want to search from a text field/column coming from source. 1)C/O 2)C / O 3)C.O 1)COMPANY 2)C O M P A N Y 3)C.O.M.P.A.N.Y -I want to find out all records where any of these combination would be there. -Both key word should be...

Can anyone please through some light on converting DD/MM/YYYY format to YYYY-MM-DD format in PX?

Biggest problem I see is there's no Field() function in your code. :wink: To use Field to extract "X Y" from a space delimited string, you'll need to pull two fields, not one... and ... Sorry missed the Field ;-) Field(Lnk[Index(SurrFileslnk.COL1, "ASIA EUROPE", 1),256], " ...

Can anyone give me the correct Field function syntax please?

e.g
my req is to extrac "ASIA EUROPE" from a string. I am using below code

Lnk[Index(SurrFileslnk.COL1, "ASIA EUROPE", 1),256], " ", 1, 1)

but seems someting wrong with above

Please suggest

I think it would return =TEST from first example as index will keep the first position. Is there any function to return last character of substring in stage variables There's nothing in the original specification that asserts that "TEST" will always follow "ABC=". Ray, the first...

svABCpos <--- Index(InLink.TheString, "ABC", 1) Field(InLink.TheString[ABCpos+2,5], " ", 1, 1) I think it would return =TEST from first example as index will keep the first position. Is there any function to return last character of substring in stage variable? Else we need to a...

Hi Anyone have any thought on this? I want to retrieve a text from a column on below logic. Need to retrive the text start at position 2 characters after keyword "ABC=" till 5 byte or untill a space encountered e.g: SourceCol AHHHNSHHBDHHHSSSUSHUSUUSABC=TESTTTHHSHST output should be - STTT...

Can anyone put a quick light into it. Looked into existing entries but didnt really satisfy with those I am having an issue in below point of a join stage (warning below) XML stage ---> Transformer ---> Join stage In transformer: Preserver partitioning = clear In Output tab = Preserve sort order(Ena...

HariK wrote:Subrat is the column COL2 is of number type or it is of Character type.

if it is Char then try using COALESCE(COL2,'0') and of course change the derivation in Datastage for this column to have string value.

Incorporating withing quotes solved the problem. Thanks Guys

Post your SQL. Unfortunately, I don't know beans about DB2 - what is the equivalent to Oracle's NVL / "null value" function, something which allows you to specify what to convert a null value to in your SQL? After googling around it looks like the answer is NVL or NVL2. After googling I t...

I am using User defined Sql only. I am converting null to somevalue for data coming from source and trying to do same from DB2 stage but no luck so far.

@Craig: Can you let me know your thought on way of handeling same on DB2 (update) stage

Thanks

Can we update a record if where clause having a column which getting NULL from souce and having null as existing value in table for that record e.g UPDATE <TABLE> SET COLUMN3=ORCHESTRATE.COLUMN3 WHERE (COLUMN1=ORCHESTRATE.COLUMN1 AND COLUMN2=ORCHESTRATE.COLUMN2) Source COL1 COL2 COL3 1 NULL 200 Targ...

If we use Upsert, it wont throw any error though record is already present in target. It will reject that record instead

Let me re-write my point Lets there are some records coming from source which already exist in target table. I need only insert in the target table (not update).As DS dont have that feature to only insert so i used Write method as UPSERT and in Update sql doing something like "1=2" so that...