DSXchange

Hi Iwin,

Why dont you read the values as individual columns using SQL and then merge all the three columns into one big column in a transformer?

Hi Titto,

I believe that, it is as easy as it gets, to meet your requirement.

Hi Benny,

I think that rumu meant Routines/Custom, further the routine AddMonthsToCurrentMonth seems like a custom routine which they developed themselves. Therfore you will not find it.

Your best bet would be to implement your own logic using the combination of Iconv and Oconv functions.

Hi ccatania, If you dont know ahead of time which field you want to test for non-numeric, then apply the Num test to all the columns that shouldn't have any non-numeric values Output link Num(InputLink.ColumnName1) And Num(InputLink.ColumnName2) and in the Reject link Not(Num(InputLink.ColumnName1))...

Hi Craig,

That was a nice little trick . Can't we use the Real function in this scenario?

Hi Titto,

Use the below transformation and see whether it works for you

cool :D . Best of Luck.

Hi,

This topic has been covered several times in this forum. Please use the search facility.

Here is one sample post viewtopic.php?t=94921&highlight=mutliple+instance

Hi Koojo, I think that you really meant to ask "How do we call a SAP function module from Datastage ?" You can not do this using ABAP extract pack, However there is another stage called PACK_for_SAP_R_3_BAPI which can be used to invoke the SAP function module using RFC. Hope that helps.

Hi Fernando, The solution has already been mentioned several times in this forum. Please use the search facility. Any Date Conversion has two go through two steps 1) First it has to be converted into the required format using Iconv, which will give the output in the internal format. This internal fo...

Hi NaveenD, As far as I know, there is no such in built GUI function in server jobs that lets you skip blank rows. Therefore, I think that you need to use some sort of constraint to achieve it. There are a lot of ways you can achieve this, one way to do it is to check the length of a key column afte...

Hi Paul,

I tried this method in a server job, as I dont have access to parallel job right now and it works well. I wonder if its different in parallel jobs

Hi Shashi,

I dont think that creating custom stages is possible in server jobs.

Moreover you have posted in wrong section(Looking for Talent Section). Please post it in the correct Server Jobs section

Hi Paul,

If all you want to do is simple division, then you can use in your tranformer and it will work correctly

My guess is that when you do , the Div function treats the arguments as string and it expects a number.

Hi Srini, First, you need to convert the numeric values into string type. Then use any combination of the below tranformations. You can remove the leading zeroes by using the below tranformation for each field. Trim(InLink.Incol1,"0","L") You can remove the trailing zeroes by usi...