DSXchange

Hi Ray, U might be right on the even , odd digit on the preceeding digit.But I need ouput of 10690164.245 as 10690164.25 As in oracle rouding is getting to 10690164.245 as 10690164.25 not in datastage .My Unit testing is failing because of this.Is there anything we can do for this In Datastage It is...

I Have an issue here . My values I want to have like this 10690164.245 as 10690164.25 -2374823.085 as 2374823.09 But When I do the below options I am getting results not as expected Doing a DecimalToDecimal(Column," "). Any Suggestions is appreciated round_inf 10690164.245 10690164.24 -237...

Well, I Tried with 1999 and it worked .. Thanks

Hi Ray ,
your suggestion worked for me but it created a new problem

for year 00 its giving 2100 instead of 2000

for others 01,02 it did worked from 1901,1902 to 2001 ,2002 etc


Is there anything that can be done to solve 00 apart from xfm

Thanks
Jagadam

HI I have the following data coming from file 2/2/01 0:00:00. I have specified in Typedafaults under timestamp as %m/%dd/%yy %h:%nn:%ss ..I have to get result as 2001-02-02 00:00:00 but instead I am getting 1901-02-02 00:00:00as this ... Any idea what can be done on this

Quick reply is appreciated

Hello,

Issue got resolved by changing source datatype from Varchar to Decimal.

Thanks

Hi, In one of my job, iam extracting data from SAP using ABAP Extract stage and writing into Oracle database(Target). One of the source field is defined as Varchar which contains -ve values ( like 12.17-). Target field is defined as decimal (19,2). Could you any one help me how to get the -ve values...

Hi chullet, I want the following jobs to be run based on the result(return code) of the routine. As the routine is giving the rowcount as the result it is throwing a warning message(which I have posted) in my previous response. Ray, I tried to do this using the $UserStatus. It seems its working but ...

Hi Ray, I tried this and its working fine.But,Iam getting warnings in the job sequence This is the warning.. "JobName..JobControl (@Routine_Activity_9): Routine DSU.GetJobRowCount did not finish OK, return code = '564'" Here 564 is the record count. When I didn't check the option "Log...

Hi Ray,

Did you get a chance to look into this.

If not, could you please look into this when you get a chance.


Thanks

Hi Chulett,

Thanks for the response.

Hey Ray will be waiting for your response.

Thanks

hi chullet, Yes I mentioned is as use got it."<JobActivityStageName>.$JobName Here are the stages that Iam using in the jobs. Job 1 db2-->xfm-->ds job2 ds-->xml(o/p)-->seq job3 rowgenerattor-->xfm-->seq jobsequence jobactivity1-->routineactivity-->uservariable-->uservariable-->jobactivity2(for ...

Hi chullet, as you guessed jobname in the string "jobname.$JobName" is the name of the first job. I am checking the trigger expressions in the routine activity.like if return value>0 then job2 otherwise job3. I will try to put in the DSLoginfo(). And coming to the stage i tried with the OD...

Hi All, I four jobs 1) Extracting the data from the table 2) Creating an xml file. 3) Creating an xml file with empty tags. 4) Squence which kicks off all the above jobs My requirement is that based on the number of rows returned from job1 job 2 or job 3 should run. for example if there are zero rec...

Hi All, I have a question on ..what is the difference between running the job sequentially vs running it parallely.(mainly on the space vise) For example if I run a parallel job sequencially does there be any difference in the space allocation of the data sets..(I set the data set to run sequentiall...