DSXchange

Before processing to the stage variable stage, sort the incoming records based on your requirement. For example you can sort based on the key value.. Then declare the four stage variable(ST1,ST2,ST3,ST4) in the transformer stage.Pass the first record into third stage variable,2 nd record into second...

Both versions are giving different set of logs for the same set of codes. The job is running successfully in 7.5.1 but it is producing warning in 7.5.2. This is the warning i am getting " Conversion error calling conversion routine timestamp_from_string data may have been lost" while i am ...

We have different versions in dev,production.The job is running fine in 7.5.1.While running the same job in 7.5.2, we are getting the error "Conversion error calling conversion routine timestamp_from_string data may have been lost". But the same job is running fine in 7.5.1 for different s...

While we are loading data into seqential file,it is padding with some special char(may be null).I want to remove the special char from file.I tried with padding option in column(field properties).. still some of the records are padding with null char .. If anyone already handled this problem, help me

The same requirement is there in our system.Just try with comma,it should work in abc@mail.com,cde@mail.com in receipients email address in notification tab.

Thanks

I think you could have missed some columns in the output field... make sure that all the values in the output should undergo any one either group or calculation...

First run the SQL query in Toad or SQL navigator and check whether the query is returning the rows or not.
You could have missed some comma operator in the SQL query.
Then copy the same query from TOAD and paste it in Datastage Oracle stage.

Actually i am loading the data to sybase from oracle. This is the warning i am getting(Conversion error calling conversion routine timestamp_from_string data may have been lost)... But the same job is running in different environment... What is the cause of this warning.... If anyone came across thi...

we are passing value from the reurned value from the routine to one of the sequencer. In that job, there is one job activity,Routine and master sequencer. If i am running the job activity and routine alone,it is running fine.But if i am running the full job,it is throwing an error. This is the error...

I am getting the error error calling DSsetparm(column_name) code=-4 while running the sequencer.The sequencer consists of job activity,routine and sequencer.Could you please give some valuable input to handle this error

Hi, i am calling sybase stored procedure.In syntax tab, i am not able to add sybase stored procedure name.The procedure is in X schema under B database.When i am trying to access the X schema through Datastage which is saying no procedures available in this DB.How can i access particular procedure i...

I need to subtarct two date values. (i.e Reading date column(date1) from file and we need to subtract with current date). (current_date()-(Date1)