DSXchange

Hi, I got the following error when i wrote a constraint in Transformer stage: "Error in constraint expression for link DSLink5. Invalid conversion requested from a timestamp to a int64". Its a parallel job. The constraint is: eff_dt<term_dt<rnst_dt Or (eff_dt<=term_dt And last_dt<=term_dt)...

Hi udan,

How u had removed the dead locks.

Thanks
Sam

udankar wrote:Thanks mate,

The select query runs properly. Actually it was the Dead lock who was the culprit. Removed the locks on the table and now the job is running fine.

Thanks and regards

Udankar.

Be curious if that's the case. Even though it wasn't said, I was working under the assumption that the SQL "runs fine in TOAD" or whatever the equivalent is for Sybase, and this was specifically a User-Defined SQL issue. :? Hi chu, I changed it to generated SQL and now it is working fine ...

Hi all, Here is something unusual with me.I am working on Sybase OC to pull data from database and just making a straight move into a seq file. Here is my SQl, whenever i am using this in the user-defined query in syabase OC,I am getting this warning.Can anybody help me with this. SQL: SELECT DISTIN...

hey there is nothing like examples in this field but if u like to gain knowledge in this field first go through student guide then try something if u find any prob post ur queries here.

sam

Hi , I am new to datastage.I have table A.I dumped it in target as Table B.Now i got new data in Table A.now i want to dump it in Table B only the new and updated rows.How will i implement it using datasatge . can any one explain me the stages step by step. thanks KK Hi, U can solve it in a simples...