DSXchange

i want to try the example in the link: http://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ds.stages.xml.core.usage.doc/topics/example4_create_job.html but does not have source file used in external source stage.could anybody help on this where to get source file? [Note - tit...

The source is Oracle and this is source for Job A: col1,col2,Indicator 1,a,J 2,b,J 3,c,H 4,d,H For first two records (where Indicator=J) I need to trigger 3 jobs A, B and C and for last two records (where Indicator=H) I need to trigger 2 jobs A and C. How to do above requirement in job sequence? Tri...

I can create batch script to run sql server agent Job.That batch script is on my local system.My datastage server is different environment not sure how to call batch script since datastage will not recognize my local system file

How to call sql serveragent job from datastage?

1)where to place the print statement present in below url.Is it in datastage or outside of datastage or where to execute it?

http://ds851.blogspot.in/2014/02/iconv-oconv.html

Awesome, thanks for the input everybody!!! It helped a ton. I solved it by sorting it in the funnel as suggested. And added 2 extra columns to sort it correctly. I added the Product# to all the links and sorted it, then a dummy column to keep the links in the correct order, "A", "B&q...

Well, there is some gap in your understanding. 19982.2776 is rounded to 19982.28 as 76 is more than 50 19982.2776 is floored to 19982.27 and -19982.2776 will be floored to -19982.28 and similarly -19982.2876 will be ceiled to -19982.287 and +19982.2876 will be ceiled to +19982.289 if you can't make...

you can use Isvalid function to identify the invalid dates

Please see my example and correct me where I am wrong. Source is one field is varchar(11) 1)Input column, output column 19982.2776, 19982.27 output column type and derivation:(decimal 7,2) and derivation:StringToDecimal(Trim(Ln_Ext_Inp_File_Data.col1), "floor") clarification:I excepted 199...

Thanks a lot for Input. I tried with different values to understand each functionality but not able to understand below things. Source is one field is varchar(11) 1)Input column, output column 19982.2 7 76, 19982.27 output column type and derivation:(decimal 7,2) and derivation:StringToDecimal(Trim(...

1)can anybody elaborate on below quote.Do we need to consider entire number or part of a number for ceiling? 2)StringToDecimal("19982.2276", "ceil") converted to Decimal(7,2) which 2 we need to consider for ceiling ceil - means always round the last usable digit UP! So in your ex...

I have gone through StringToDecimal function in below link but still have below clarifications. https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.parjob.dev.doc/topics/r_deeref_Type_Conversion_Functions.html 1)StringToDecimal("19982.22") converted to Decima...

chulett wrote:The "trick" to preventing substring matches has been posted here many times: include the delimiter in the search.

i am not able to find any post for the thing highlighed in bold letters and anybody help on this

My Datastage admin is not willing to give the information.I have access to Datastage administrator for my project and where can i check DSODB database details?

Thanks for reply. We are using operation console. Where can I run queries in operation console?