DSXchange

Thanks for the responses guys. DecimalToDecimal Worked.

Hello all, my input is decimal 4,2 and my output is smallint. So I am using Ceil func to get the closest value.

What I am expecting is

Ceil (7.04) =7

ceil(7.94)=8

But in both cases above, the output I am getting is 8. Let me know if there is another way around.

Thanks for the input folks. $APT_DATE_CENTURY_BREAK_YEAR did the trick. Guess its added in 8.7

I have this situation. Source is a csv file. I am reading everything as varchar and trying to load to Teradata. There is a column which has dates, from the source. In the transfomer I am doing a StringToDate(IP,'yyyy-mm-dd'). Issue is for 01/01/01 it is loading as 1901-01-01 instead of 2001-01-01. I...

Folks, I am trying to calculate number of months since from a given date.
I know Datastage has DaysSinceFromDate and I can do either
days/30 or (days/365)*12. The second one is much accurate. Please let me know if there is a better way. Appreciate your help.

Guys, when I am running the job from client, the job is running as 'dsadm'. But when I am running the job from cmd line with dsjob -run, the job is running with my user id. Is there a setting I can change so that the job runs as myself even from the client or is it something that was during the inst...

I am positive that I exhausted those options but I will try again tomorrow and will let you guys Know. Thanks

Thanks a lot guys for the responses. Yes I know I have to qualify the new ports but that is where I am not able to work it out. I haven't yet installed 8.7. It will be installed 2 weeks after. I am just trying to get the right syntax. My simple command that works is dsjob -run projectname jobname No...

Hello all, We have IIS 8.1 right now in our environment and soon in about a month we will be installing 8.7 with out uninstalling 8.1. So we will have 2 Engines for atleast 2 to 3 months. Obviously I will be installing 8.7 on new ports. Lets assume my new dsengine is on 31540 instead of the defualt ...

We have a Datastage job which loads Runtime statistics of any functional job. We call it Framework Job. This job runs around 500 to 600 times everyday depending on the functional jobs we have. We are having issues with this framework job on somedays, frmwork job getting aborted for no known reason. ...

We have a very strange situation in our production instance. There are very few jobs in PROD around 15. Occasionally they are causing a failover on our cluster and switching to secondary. There are a lot more number of jobs in test running without any noise. When we asked our Systems team, they are ...

Hi all
Is there a way to find if a job is Multi instance or not, from the command line. I am guessing if dsjob -jobinvocationid would work. But dont know what will it return, if the job is not multi instance.

Any advice is really appreciated.

Are you retiring? or just wanted to re collect good times?

I am trying into import Table Defnitions from DB2 using ODBC connectivity and I am getting the below error. Not sure if its a DB2 issue or Datastage issue. I am new to DB2. DSR.MetaGeta(GET.DSNINFO)(SQLConnect('DB','userid')) : BCI Error : SQLSTATE=S1000,CODE=-567,[DataStage][SQL Client][ODBC][IBM(D...

How to use a STP Stage in DataStage Parallel Extender.