DSXchange

Hello: Can somebody help with the below query. It works fine. BUT shows ( ) - EXT if Null I need it to NOT SHOW ( ) - EXT if these fields are blank or null IF Isnull(Lnk_Cpy_Ds.Ph1) OR (Lnk_Cpy_Ds.Ph1) = '000' AND Isnull(Lnk_Cpy_Ds.Ph2) OR (Lnk_Cpy_Ds.Ph2) = '000' AND Isnull(Lnk_Cpy_Ds.Ph3) OR (Lnk_...

"ALNUM" is a datastage string function for checking if a field is all Numeric.

When I look at the data for this field I see that the first 3 one can expect to see Char fields and rest numbers.
So if only numbers come in then put spaces else extract the character.
Hence the need to check for All Numerics only....

Hello: Need help with what functions to use in Datastage to replace DB2 functions in the below query. DB2 query: SUBSTR ( TRANSLATE (COL, SUBSTR (COL, 5, 1), ' '), 5, 1) || SUBSTR (RIGHT ('0' || RTRIM ( CHAR ( LENGTH (RTRIM (COL)))), 2), 2, 1) || Ex: SUBSTR using LEFT TRANSLATE should I use CONVERT?...

Is the above correct?

Thanks

I tried to do the following in the stage variable: If NOT AlNum(LEFT(Lnk_Extract_Xrfm.MEMBNO,3)) then LEFT(Lnk_Extract_Xrfm.MEMBNO,3) Else If NOT AlNum(LEFT(Lnk_Extract_Xrfm.MEMBNO,2)) Then LEFT(Lnk_Extract_Xrfm.MEMBNO,2) ELSE IF NOT AlNum(LEFT(Lnk_Extract_Xrfm.MEMBNO,1)) Then LEFT(Lnk_Extract_Xrfm....

Thank you Ray.
I am using 8.7
However, I dont see the function under Type conversion as "IsValidInteger"
Currently I am getting IsValidInteger is not defined.

Thanks.

Appreciate your quick response.
However, can you please help write it.

Thanks.

Oh Sorry. This field MNO is a VARCHAR of length 15 and has no delimiters in it. It is a combination of Characters and Numbers. So if the first 3 fields are Character then we need to extract it to create a Prefix. Need to select Positions that are not Numeric. If all positions are numeric the Prefix ...

I was thinking to put this in stage variable and use the Field/Index function... but how to go about doing it is the question.
Could use someguidence on how to convert the above logic in Datastage.

Thanks

Hello: Need to Perform the following logic in Transformer: If NOT SUBSTR(MNO,1,1) BETWEEN ''0'' AND ''9'' AND NOT SUBSTR(MNO,2,1) BETWEEN ''0'' AND ''9'' AND NOT SUBSTR(MNO,3,1) BETWEEN ''0'' AND ''9'' THEN SUBSTR(MNO,1,3) WHEN NOT SUBSTR(MNO,1,1) BETWEEN ''0'' AND ''9'' AND NOT SUBSTR(MNO,2,1) BETW...

Hello Create 3 stage variables (no need of split and collect the data ) 1)if not(isnull(ColumnA1)) Then ColumnA1 Else if not(isnull(ColumnA2)) Then ColumnA2 Else ColumnA3 Else 0= StgA 2)if not(isnull(ColumnB1)) Then ColumnB1 Else if not(isnull(ColumnB2)) Then ColumnB2 Else ColumnB3 Else 0 = StgB 2)...

What is the mapping to each of the target columns? You're doing way too much work, but we need to know what has to go into each target column before being able to help further. The mapping to the Target col is: - Populate this element (COL_A) with either COL_A1, COL_A2,COL_A3 if the value is not nu...

Hello: I have a source table with 9 columns and Target table with 3 columns. These are date columns which are nullable columns. On source side they are Varchar and Target its a date field. So my SOURCE table has 9 Columns COL_A1, (NULLABLE) COL_A2, (NULLABLE) COL_A3, (NULLABLE) COL_B1, (NULLABLE) CO...