DSXchange

Thank you Hulett

For the debug purpose. i ran the separate job only particular piece DB2 source table with same SQL script write in to seq file . This is working fine.

Why specifically creating problems when i ran whole job.



Thanks
SReddy

Thank Ray Here is the DB2 Admin reply: You are getting below error message. DSNT408I SQLCODE = -514, ERROR: THE CURSOR SQL_CURSH200C4 IS NOT IN A PREPARED STATE DSNT418I SQLSTATE = 26501 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXERT2 SQL PROCEDURE DETECTING ERROR Explanation: The application progr...

Hi My job is aborted due to blew mentioned problem. MF_READ_VNR_LVW,0: Fatal Error: Fatal: [IBM][CLI Driver] SQL0902C A system error (reason code = "18") occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005 [IBM][CLI Driver] SQL30081N A communication error has been detec...

No coversion

same in the source. trim is not working.

000000001

Hi My source data is like this. 000000001 000008753 000026843 000000084 I need the out put data as 1 8753 26843 84 i want to trim leading 0 . how can i do it. At present i am applying the trim like this, it is not working. Lnk1.VEND_NUM = Trim(Lnk1.VEND_NUM, "0", "F") Please corr...

Source1 : Sequential File contains two columns ( A, B ) -- Reference Data Source2 : DB2 Table contains 4 columns ( A1,B1,C1,D1 ) Lookup: Source.A = Source1.A1 ( Condition Not Met : Continue Lookup Failure : Reject ) Source1 : Integer type data 67219 -- Reference Data Source2 : Char type data contain...

Thank you Ray I tried by enabling Multiple rows returend from link . Still i am getting same. I tried the same job using Join stage. But data is same. --------------------------------- 69613---1---0003---4---14 69613---1---0006---8---14 69613---1---0007---6---14 Please help me what i have to do. Tha...

Hi I have job like this Source1: ODBC stage extracting data . Reference: ODBC Stage feching some data. LookuStage: Condition Not met: Fail Lookup Failure: Drop Target: ODBC Stage ( Deleting records out put from source after lookup ) Job is running almost 4 hrs. I run the job first on 4 node system. ...

Hi I have a job like this. Source1 : Sequential File contains two columns ( A, B ) Source2 : DB2 Table contains 4 columns ( A1,B1,C1,D1 ) Lookup: Source.A = Source1.A1 ( Condition Not Met : Continue Lookup Failure : Reject ) Source1 : Integer type data 67219 Source2 : Char type data contains Numbers...

Thank you Hulett Below is the warning. Still job is running. Lkp_VEN: When checking operator: On output data set 0: When binding output schema variable "outputData": When binding output interface field "LAWSON_VEND_NUM" to field "LAWSON_VEND_NUM": Implicit conversion fr...

Can you please send me your version of conversion script.

StringtoDecimal()

source is char 000000001

first Trim the zeros from source data with that result we have to convert the data according to lookup data type integer.

i am waiting for your reply.

Thanks
SReddy

Thank you both of you

My source data is in Char data type just like below format ( 9 characters)
000000001
000000012
000000120
that is why i used Trim the Zeros.

But my lookup data is integer data type
87654
98653
34765

Help me with related function script StringtoDecimal()

Thanks
SReddy

Job status is Abort.

Can you please check below conversion.

StringToDecimal(In_VEN_Ven.LAWSON_VEND_NUM,'Trim(In_VEN_Ven.LAWSON_VEND_NUM, "0", "F")')

Thank you Hulett

Can you check this convertion.

StringToDecimal(In_VEN_Ven.LAWSON_VEND_NUM,'Trim(In_VEN_Ven.LAWSON_VEND_NUM, "0", "F")')

When i used this job is aborting.

Hi My source is Char and lookup data is Integer. I am getting below warning while i am runnig. Every thing is fine. Lkp_VEN,0: When binding input interface field "LAWSON_VEND_NUM" to field "LAWSON_VEND_NUM": Implicit conversion from source type "string[9]" to result typ...