DSXchange

I do have such result printing statements but routine never ending the execution of the statement "DSExecute(...)" which is calling SQLPLUS.

Hi, calling sql query from a routine using sqlplus. routine run never ending. Code: Statement = "SELECT count(*) FROM TableName;" Command = "sqlplus -S ": pSrcDBUser : "/" : pSrcDBPwd : pConString : char(10) : "SELECT count(*) FROM TableName;" : char(10) : &qu...

hi, guess you've only two fields, col1 and col2. then do the following.. source->sort>transformer->R.Duplicate->target. (in transforer take stage variables and define as below) stg_var1=col1 str_var2=col2 stg_var3=stg_var4 (this is final string to populate in target) stg_var4= if stg_var1=stg_var5 t...