DSXchange

Hi Abu,

Thanks for the reply,below is my exact reqrmnt:

if the value of the ColumnA = 'dsx' then populate TARCOL1,if this is blank THEN populate TARCOL2.if this column also blank then populate TARCOL3.

Could you please advise on this?

Sorry for the confusion..

HiAll ,

In my requirement i need to use 2 else statements..

if the value of the ColumnA = 'dsx' then populate TARCOL1,if this is blank THEN populate TARCOL2.if this column also blank then populate TARCOL3.

any Advises please?

Hi,

I am looking for simple IF-THEN-ELSE Logic for my below reqrment...

Could any one help me on this please..

if column1 = 'DSX' Then 'Datastage' Else 'Dstage' Else 'Ascential'

how do i keep im if then else in transformer?

Thanks all!

Thanks for the reply Ray,


I tried to run the qry like below using my SQLAdvantage tool in my sybase database:

where DTTTM = 'Dec 31 3999 12:00AM'

but i am wondering will this work on datastage?

any suggestions--

Hi All, I am using Sybase as my source database tables and datasets are my target files. In one of my sybase table column like'DTTM' and the value for this column like: 'Dec 31 3999 12:00AM' 'Jan 23 2015 09:00 AM' 'Feb 28 2010 10:00 AM' 'Dec 31 3999 12:00AM' But i need to extract records where DTTTM...

Hi All, I got the solution for this issue,actually one of my column in my sybase table is having datatype as 'float-8',but i am extracting this column as 'decimal',this was giving the issue, when i tried extracting the column with datatype as 'double' ,it is extracting all the records now. I dont un...

Hi,

there are no warning/error messages in the log,about this perticular sybase source stage.

And I have checked imported metadata,and As Arnd suggested added some records to the current table and the issue is remaining same.

any thoughts?

Thanks Maveric it resolved...

Can any one faced before this kind of issue?

Help me on this..

Hi, I am still facing same issue...? SELECT * FROM xxx WHERE LST_UPDT_DTTM<= "#To_Date_Parm#" AND LST_UPDT_DTTM>"#From_Date_Parm#" and the values of To_Date and From_Date parameters i am passing same values which are in my parameterfile when i run qry in database. when i run data...

Hi All, I am trying to populate one of my target column by using below logic: If (DUE_STLMT_DT + 2415021) > JulianDayFromDate(CurrentDate()) Then 'U' Else If (DUE_STLMT_DT + 2415021)<=JulianDayFromDate(CurrentDate()) Then 'S' Else '' But the problem with above code is: when the job runs midnight it ...

No Ray, when i tried to see the process of records by clicking'show performance statstics' it is displaying records as 10000. and i am getting in my target file also as 10000 records only. my job is like: sybasestage----->transformer---->dataset sybase stage transferring only 10000records instead of...

Thanks Ray...

Hi, I have 2 source fields: AAA, BBB my target field name is: XXX The logic to populate XXX target column like below: if AAA = 255 ( BBB<0 THEN populate XXX= LOSS,but IF BBB >0 then populate XXX=PROFIT) Else other than AAA=255 VALUES leave it blank. Can any one help me to apply this in IF-THEN-ELSE ...

Hi All, I am using Sybase database table as my Source table and i have a user defined query in my source sybase stage. When i fire the query to dabase i am getting like 20,000 records .but in my datastage i am getting 10000 records. Can any one have any idea on this. the query which i fire on my dat...