DSXchange

qutesanju

I assume by clicking on otherwise/log will include otherwise /log rows
And it has reject link also,

so not sure about your post (@ray.wurlod )

please correct me

qutesanju

so can someone shows correct function with arguments?

qutesanju

Yes in link ordering I can see order as

Code: Select all

link label                    link name
output1                       lnk_insert1
output2                       lnk_insert2
output3                       lnk_insert3
output4                       lnk_insert4
unnamed1 reject               lnk_reject_final

qutesanju

I tried alternative approach which is

lnk_xfmr_target.DIR ='IN' AND lnk_xfmr_target.CD_FLAG ='D'
AND Index('|ARC|PPD|CCD|CTX|COR|DNE|','|':lnk_xfmr_target.CLASS:'|') < 1

but it shows
not enough arguments to function index

qutesanju

Otherwise/Log dosent catch reject I defined few expression in transformer and I clicked on Otherwise/Log,however after runnning a job reject link dosent shows any rejected rows. So i checked in source lets say 100 rows are coming and in target only 80 rows matched to expression given in transformer,...

qutesanju

perfect james i m thinking which one is correct in below two 1) lnk_xfmr_target.DIR ='IN' AND lnk_xfmr_target.CD_FLAG ='D' AND (lnk_xfmr_target.CLASS <> 'ARC' and lnk_xfmr_target.CLASS <> 'PPD' and lnk_xfmr_target.CLASS <> 'CCD' and lnk_xfmr_target.CLASS <> 'CTX' and lnk_xfmr_target.CLASS <> 'COR' a...

qutesanju

there is a SQL query select * from table1 where DIR ='IN' AND CD_FLAG ='D' AND CLASS NOT IN ( 'ARC','PPD','CCD','CTX','COR','DNE') so i'm trying to implement above query in datastage and i implemented it in transformer as lnk_xfmr_target.DIR ='IN' AND lnk_xfmr_target.CD_FLAG ='D' AND (lnk_xfmr_targe...

qutesanju

Its resolved i corrected metadata and selected equal length at both side,however my assumption is that lookup should work for varchar datatype for both sides of data

qutesanju

Hi I am using DB2 Connectore stage for lookup and source as oracle reject file in lookup is a sequential file stage. i wrote a user defined query in lookup as SELECT I_BK_SWIFT_ABA, N_BK, I_BK_CITY, I_BK_ST, I_BK_CNTRY FROM #DBR_PARAM.$DB2_SCHEMA#.SWIFT_ABA_AC WHERE F_SWIFT = 'N' but here after job ...

qutesanju

This issue is resolved,actually query was having wrong table names,
thanks MT/Michel for rectifying this

qutesanju

how to verify this query?
is there any db2 query tool ? that i can see and can check its working ?

qutesanju

I have an extraction job from DB2. The query is as below SELECT I_AC_AML as I_AC_AML, N_AC as N_AC, RIGHT('00000000000000000000000'||RTRIM(I_AC_AML_SH),23) as I_AC_AML_SH, I_SRC_SYS as I_SRC_SYS FROM #AML_ACH_DBR_PARAM.$AML_DB2_SCHEMA#.NTS.AML_AC AML_AC.AML_AC WHERE I_UAF_SEQ <>8330000 It works fine...

qutesanju

When i tried to run the one seq job, it aborted with an error The connector could not establish a connection to DB2 database DSNBDB using user zdsamlt. i checked db2 user id and password ,they worked well before few days just wondering what would have happened or is there any place i can check in da...

qutesanju

I removed few coding from routine which was not needed, but its giving a warning saying-- Assignment to variable Total_Data_Record_Count on line 19 will modify an input argument. If input link column variables are used as arguments to this routine then DataStage runtime may fail. what does this mean...

qutesanju

how to comment out code in DS routine?

does it #
or /*.....*/
or //

?
please suggest?

DSXchange

Search found 370 matches

Otherwise/Log dosent catch reject

NOT IN in datastage

numeric argument of built-in string function is out of range

Invalid property value DB2

connector could not establish a connection to DB2 database

routine Warning

Comment in DS routine?