DSXchange

Hi...i have a job created for updating a column in the oracle table. The job got aborted in the middle while updating. Is it possible to update from the point where it got aborted?. The commit interval is for every 2000 rows. Not with a commit interval like that. You have to start from the beginnin...

Hi...i have a job created for updating a column in the oracle table. The job got aborted in the middle while updating. Is it possible to update from the point where it got aborted?. The commit interval is for every 2000 rows.

wesd wrote:Try and import through Manager.

Sounds to me like a DB connection issue.

i have tried with manager too...but its the same problem.

wesd wrote:Try and import through Manager.

Sounds to me like a DB connection issue.

if it is a DB connection issue, how can i see the tables....the prorblem is only when i press the IMPORT button

i am connecting to oracle, i was working with the database since past 10 days and never faced the problem..suddenly it happened.....i am checking it now but still getting hanged.

When i logon to designer, everything is fine when working with jobs. But when i want to import some table definitions the designer is not responding. I am able to connect through ODBC and filter the tables i need to import, but when i press the IMPORT button, it is a never ending process. Where does...

can any one tell if there any commands for killing a job from DSTOOLS on windows 2003 server instead of from graphical mode. I have a command for unix.


Thanks

i am reading SSN from all the 20 tables from an oracle database through oracle enterprise stage and need to update all the oracle tables with a new SSN. SSN is key in some tables and non key in some tables. they have given the list of tables and told me to transform the SSN to a dummy or some other ...

I have different columns that i need to transform in my project. For example i have SSN in around 20 tables that i need to transform to a different value. Is it possible to transform the SSN column in all these 20 tables in a single job? Currently i am coding one job per each table. Thanks in advance?

Thanks for your reply....we can check for the duplicte rowids before updating and if there are no duplicates then we can go ahead. Is that OK? and i think i dont have all the privilages to query the databse design! Only privileges that i have are in the list that we have in the parallel job develope...

Since ROWID of a table is always unique to that table, I am also selecting it in the input oracle stage and using it as primary key when updating the table. Is it a good idea?

I have a table that contains for example 10 columns. I have modified 3 columns and i need to update. the key that i use while updating is a timestamp column (on oracle side it shows as date column).

Can i use the key column as timestamp or should i typecast it to varchar?
and then run the update.

to be honest i haven't done this before. It would be helpful if you give me some idea. Do i need to write a procedure and use stored procedure stage?

Thanks

to be honest i haven't done this before. It would be helpful if you give me some idea. Do i need to write a procedure and use stored procedure stage?

Thanks

i have tried typecast it to varchar , but there is no use. i am getting different error

main_program: Internal Error: (colDesc):orautils.C: 1655: getColDesc failed.
Contents of phantom output file =>
DataStage Job 281 Phantom 9