DSXchange

hi, i am getting error while converting string to date . My job design DB2 stage.........xfm............peek stage the date field NEXT_PMT_DATE(VARCHAR(10) and i am using the following code If IsNull(select_stats.NEXT_PMT_DATE) then SetNull() Else If IsValidDate(StringToDate(select_stats.NEXT_PMT_DA...

Thanks chulett, I tried by giving leading and it works fine.

hi, i am getting column name acct_num as varchar(23) from source as DB2 stage and loading as it to target oracle table as acct_num varchar(30). my job design is DB2 STAGE.........xfm...............oracle stage the data i m getting like this 00000000000000000664373. i want to trim the leading zeros a...

hi, i am using DB2 stage as source and putting into sequntiql file as target but getting the error EDWSTG1_PAAS_MORTG,0: SQLFetch reported: SQLSTATE = 22007: Native Error Code = -180: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL0180N The syntax of the string representation of a datetime value is inco...

please find the SQL which the oracle stage generating

INSERT INTO DIM.STG_NAME(ASSIGNED_DATE) VALUES(:ASSIGNED_DATE).

IT doesn't include to_Date function for this field.

i am doing the same giving the timestamp datatype still storing the Date part only.

hi, i have design inserting from DB2 stage to oracle as target. The column RATE_DATE(TIMESTAMP) in DB2 STAGE and target is oracle having RATE_DATE(DATE) as datatype. i have tried by inserting the same timestamp to DATE datatype without any conversion and job work fine but i am not able to get the ti...

HI, i am reading columns CLOSE_DT AS DATE datatype from source(db2 stage) and inserting into oracle DB using oracle connector stage having datatype as DATE. The job design is as follows db2 stage....................tranformer.......................oracle connector stage. i have tried by using String...

i tried but no luck i tried with the follwing way also
but drppogn the records getting the error

Field MD_id is from input dateset '0' is null record dropped

Thanks Ray for reply,

So i have to take like this

IF IsNull(GEO_1) then -911 else MD_id.

please reply.

hi, i am doing look up between two databases one is DB2 and other is SQL. the column name GEO_1 is coming from DB2 database and doing look up with sourcesystem_value column with SQL database to get MD_id from SQL Database. The requirement is that if look up failed then MD_id is hardcoded -911.In oth...

adityavinay wrote:hargun,

If you are using version 8.5 or latest, try this way.

<snip>

This is not working, it will not increment the Group for different Phone number.

i done the follwoing changes for counter is it right.

stggroup:if DSLink24.keyChange='1' and stgprev='1' then 2 else stggroup +1

Your job esign would be: seqfile-> sort1-> sort2-> tsfr-> target logic would be: Sort1- Sort on ph no with Key change col=True--Asc Sort2- Sort on Ke change col, ph no-asc Tsfr- Create stgv1 stggroup, Stgv2 Stgfamily, Stgv3 stgprev(Default=1) stggroup= If keyChange =1 And Stgprev =1 Then 2 Else 1 S...

Can you help me what i have to define in stage variables .I appreciate.