DSXchange

DB2 Enterprise stage is not correct choice for performance wise, better to use DB2 Connector stagte. It gives very good performance.

From transformer stage you can generate surrogate keys. First create surrogate key file by using surrogate key stage and use that .sk file in transformer surrogatekey tab file option. give path and file name which you have initialized, in output link assign nextsurrogatekey() then it will generate u...

Hi jwiles,

Thanks for your response.
Could you please give me an example with any two conversions in one specification..

I am not able to do any two conversions in one Specification.

Thanks in Advance.

Hi All, Please clarify my doubt regarding Modify stage, i am using two modify conversions in one specification like NEW_COLUMN = COLUMN_A; COLUMN_C = handle_null(COLUMN_C,0); Reason for using like this is, i will parameterize the specification and pass that at run time. i have 100 jobs with differen...

Hi Team, Please tell me how to do for my below questions. I have column COLUMN_A datatype is string(10), i want to convert it into Decimal(10,2). One more column COLUMN_B datatype is string(10), i want to convert it into Integer(10). One more column COLUMN_C datatype is string(10), i want to convert...

My job is like Dataset ---->Transformer--->Dataset At run time for parameter first time i will give like EMP_ID=123 Or EMP_ID=234 Or EMP_ID=456 when i run second time i will give like EMP_NAME='AAA' when i run thirs time i will give like GRADE='AA' depends on the requiremnt i will pass at run time. ...

Hi All,

My requirement is I want to pass column name with some value as parameter (Lnk_In.EMP_ID=1234)in transformer constraint.
When I tried with that job is completed successfully, but no records are passing to output.

Could you please help me.

Do you need sharp signs around Rtn_Ext_Fdate.$ReturnValue ? ... Yes ..we have to give...otherwise it is giving syntax problem. Now my problem is solved. Below is the way to give in query: "Select a.SE_NO, Case when to_date(\'" : Rtn_Ext_Fdate.$ReturnValue : "\', \'YYYY-MM-DD\') betwe...

Hi, My requirement is "get the data from one db2 source and load into other db2 target table by using RCP" My job is like DB2 connector-->Transfomrer-->DB2 connector It is RCP enabled. Source db2 query is "Select a.SE_NO, case when(select f_dt from stg_filedt) between a.EFF_DT AND a.E...

Hi, I am facing runtime error while using range lookup as " Lookup_56,1: Operator terminated abnormally: received signal SIGSEGV [processmgr/rtpexecutil.C:199]" . My requirement is as below: --> Main link has 4 columns(EMP_ID, EMP_NAME, START_DATE,END_DATE) 12, ABC, 2010-12-11, 2010-12-23 ...

Ravi.K wrote:Use Index Function

Thanks Ravi...Its working...

chulett wrote:Probably better suited to the 'matches' function. ...

Hi chulette, Could you please explain more about 'matches' function.i dont have any idea about that.

Hi All,

My requirement is to convert like operator logic into datastage.
below is my requirement

Input_colname like '%F%G%E%Z%'

Please help me out, Thanks in advance.

I want a generic job for file movement from Mainframe to UNIX box.
This is not only for any specific file. This is for any file.
How can i design a job?

Please help me!!!

Hi Guys,
Please give me the Difernce between Resource disk and Resource Scratch disk in configuration file