DSXchange

Hi All, Tried many ways. I think I am missing something in my Query. These are the following i have taken care. 1 . Selected User Defined Query 2. 2 fields has key fields(If i use only 1 field,getting the perfect result) 3. Used the following query SELECT CUSTDBA.TPOL_CLNT_ADDR.ASCO_NO, CUSTDBA.TPOL...

Hi All, I am doing Lookup using ODBC Stage and I am getting the following error msg. Even though i got match ,i couldn't retrieve the data from Table. The error is **************************** SQLSTATE=HY000, DBMS.CODE=-302 DSD.BCIGetByKey call to SQLExecute failed. ********* [DataStage][SQL Client]...

Bala, I tried to do with ODBC and DB2 Stage. I am getting only 1 row through ODBC Stage. If i use DB2 Stage, I am retrieving 3 rows but only 1 row is matched. The following warning msg wil display. FCdb2test2..TFc1_CSearch1: Reference lookup generated 3 rows. Only the last row was used. ------------...

Hi All,

I have 1 input record with 6 key fields in fileand I am doing Lookup in table .

In Table i have 3 records matched for the recod in file. I need to retrieve 3 records from Table and write to output file.

At present I am getting only 1 record.

Thanks in Advance
Jay

Vaidya,

Thought in that way but we can't use INROWNUM as HASHKEY in HASH FILE.

There is no @INROWNUM for HASH FILE in System Variable.

Thanks & Regards,

jayaram

ameyvaidya wrote:Recommend using the row number(@INROWNUM) as the hash key.

Hi Everyone, I have 1 record which i will split into 2 records and the 2 Records(Policy Details & Address Details) will follow different path. I am doing the process for Policy Details and Address Details Simultaneously. At the end of the Process, I want to Merge the 2 records into a single reco...

Hi, I am comparing the Inbound Data to an Table. Initially I am converting the Inbound Data as If the Field is Character If IsNull(Input.Div13AccountNo) then ' ' else Input.Div13AccountNo and I am doing for all Character Fields If the Field is Numeric If IsNull(Input.ProfitUnit) then 0 else Input.Pr...

Ray, When i tried to use Stage Variable field, getting the result. For the fields having spaces in both inbound field and also space in DB2 Table, I couldn't match. I am using COALESCE(Field,' ') to convert for a null value but the field is already having space, so i am getting space. For the inboun...

Hi, When i tried to compare the Inbound record with the existing record(table) for 4 fields(primary key), I could retrieve the record. Actually I have 74 inbound fields which has to be compared with Existing Columns(Table), I am getting Deadlock condition if i use the DB2 Stage as lookup. Which is t...

Hi Everyone, I have a record in File having valid Address in Address1 and Spaces in Address2 and Address3. IN FILE I am using the function to set the Address2 and Address3 to Null for having spaces. If (IsNull(Input.InsuredAddress2) or Len(trim(Input.InsuredAddress2)) = 0) then @NULL else trim(Input...