DSXchange

Hi All, I just wanted to know that: Is there any utility or tool avilable to make the code review and cross check the naming standars or other checks in job ,which allows in automated way. For ex: if I have 1000 jobs running in prod/dev and now as part of the COE i decided to check whether all those...

Hi Every one, My jobs are getting aborted due to the following fatal error messages that are displayed in director. buffer(0),1: Fatal Error: Cannot find protocol entry for tcp protocol! buffer(1),1: getprotobyname for 'tcp' failed with error 0 (Error 0) buffer(1),1: Failure during execution of oper...

Hi Sun,

Could u Just explain the group how u implemented this?

thanks,
sampath

Thanks for the reply Naveen,

But I am looking to get this done through datastage px.

Any ideas..

Hello all,

May be this is a silly one,but I am just wondering how to convert an .xls file to .csv format using DSPXversion.

Thanks in advance

Hi ArndW,

Is there any function available in 7.5.1. version to similar 'DateToJulianDay' is available in DS8.0?

Hi All, I have a sequence job which calls 3 parallel jobs one after another. In the very first job i have a filter criteria(constraint in the transformer stage).If the records are not found for that filter,i need to send a stop request to sequence.Do not generate/run any further. How to implement th...

Hi aceflyer,

Have u got the solution for this,if u remeber just tell me how did u achieve this?since i am having same issue..

can any one give me some idea to acheive this ?

yes those are:

Dec 10 2007
Jan 10 2006
Feb 12 2008

My source is Sybase tables.

I need them in my out put as:

10/12/2007
10/01/2006
12/02/2008

I have values in my julian date format like:

39424,
38725
39488

thanks

Hi ,

Can some one help me to convert an julian date to DD/MM/YYYY format?


Thanks,

All,

I resolved this by using Trim function.

i.e Trim(DecimalToString(column,"suppress_zero"), "0", "L")

Now it working fine....

Thanks

Hi, I am conevrting one of my input column from decimal to string. Using DecimalToString function,and getting the values like: 0 .3456 1.889907 0 .78654 etc,etc.. but the requirement is like ,whenever the values are like '0.',then should not display the 0(zero)in value. for ex: in my above sample da...

hi, I have sybase views are as my source database and i am loading in the file in my jobs. The value for one of the column in sybase view is coming up like exponentials. i.e. "1.0000000000010001e-006" but i need this value to be populated as "0.00",instead of exponentials. can an...