DSXchange

Amey Instead of one target OCI stage, Tyy to have 2 Target OCI stages. Make these stages identical in all respects One with the truncte before-SQL and one without. Regardless of whether you have rows or not both the links Before SQL will run. This solution will truncate the records for every run

Naveen

I agree with you but if it is in a job then it is more controlled. Once the code is compiled, tested and promoted to production then you don't need to worry about it. In manual approach there is always a danger on truncating other tables in production and there could be other security issues.

Or even create a separate job in datastage to truncate table and run it manually whenever you want to truncate table....

Make sure you are pointing to the right ORACLE_HOME, PATH which includes Libary PATH after migration.

Champa Use one Sequential file stage with a filter command the uses cat to load all the rows from all the files into a single stream You can use filter command inside your Sequential File Stage. By default it is not enabled. Go to the Stage tab inside Sequential File stage and tick "Stage uses ...

Kris The job is going to execute Before Command on every single run. It's important to give a valid SQL to your parameter. One way is to construct your SQL parameter as "Select 1 from Dual" make this as your default SQL to be executed every time. Whenever you want to refresh pass the value...

Hi

Your problem mostly releates to repository. Do a search on this forum there are number of posts covered for this problem.

Hi Ravi

Sort always has overhead while running job and depends on the volumes. Is there a specific need to sort the data before sending it to DB2.?

Hi

Your question is not clear enough to respond. Could you explain it futher with some example

Hi Sunshine

Migrating from Version 5 onwards to its next version is what recommened. But version prior to that as said by kcbland will take lots of effort. I guess there should be someone who had done this in the past and hope had the checklist of things to be done while migrating.

Somu

The IsValid function will verify whether it is of valid datatype decimal or integer but it won't check to see whether you got decimal(7,4) or not. If you want to do that then convert the decimal in String and separate the scale and verify.

Hi What you can do is have a job which runs the function and writes it to hashed file or sequential file. In your Oracle job create a new parameter which will be used in place of the function. Before running your Oracle job read the hashed or sequential file which has the value and pass it to the Or...

Somu

The easiest way is to convert your decimal to integer use AsInteger

Total(integer) = Total(integer)+AsInteger(Reclinenumber(decimal)).

Hi

If your format "Thu Jan 19 16:59:51 EST 2006" is like this I don't think there is a function to convert. You have to break the day, month and year part based on your source format and then finally concatenate

Well point Amey... It would be of great help if we get all these in next releases... That's the only document which developers can refer for datastage. Unfortunately there is no books available in book shelf for datastage.