DSXchange

Hi David, The generated sql for table1 was SELECT PS_CUST_CONVER_HDR.SETID,PS_CUST_CONVER_HDR.CUST_ID,TO_CHAR(PS_CUST_CONVER_HDR.CONVER_DTTM_INIT, 'YYYY-MM-DD HH24:MI:SS'),TO_CHAR(PS_CUST_CONVER_HDR.CONVER_DT, 'YYYY-MM-DD HH24:MI:SS'),PS_CUST_CONVER_HDR.CONVER_SUBJECT,PS_CUST_CONVER_HDR.CONVER_SUB_T...

Hi, When I sent one of the tables through a hash file and then did the join, I was able to join the timestamp fields without any errors. The output is also as desired. Table1-Transformer-Table1 Table2-Transformer-Hash File-Table2 Then Table1 and Table 2 are joined. I am not sure how it worked. Just ...

Its an SQL server database. I am using DRS stages with only generated SQL. In the generated sql, the cast is TO_CHAR(FIELD, "YYYY-MM-DD HH24:MI:SS")I need to take fields from TABLE1 AND TABLE2 and input into TABLE1 based on certain conditions. One of the conditions is that the SETID, CUST_...

Hi, Thanks for the response. When I join the timestamp field in the two tables, I get an error saying 'Invalid character value for cast specification'. The SQL Type is a timestamp field of length 23 and scale 3. I am not sure why this is happening since the sqltype of input and output fields are the...

Hi, I am joining two tables in order to modify the data in one of the tables. For this I need to compare a timestamp field[yyyy-mm-dd 00:00:00.000] in these tables. Can you please let me know how to go about this. I did try using the ICONV expression but it returns a null value. (ICONV(FIELD(DSLink2...

Hi,
Thanks a lot for the quick response. I did change the derivation as mentioned and used the GROUP BY clause in the Selection tab's Other Clauses field to make it work. The map is working fine.
Have a good one,
Deepa

Hi, I am new to Datastage. I need to retreive Maximum(EFFDT) value based on a condition for my update statement. I have read the earlier messages about using an aggregator stage or input MAX(EFFDT) in the selection tab of input stage. Is there any other way to do it without using either the aggregat...

Hi, I am new to DataStage. I am required to do multiple updates on a single table. Each update statement is pretty complex with multiple joins to other tables. I am not sure how to proceed with this. I did read the messages in the forum on using the JOIN stage. But I cannot find this stage in the de...