DSXchange

hi andrw: i want to update some columns in a table and if the job aborts in the middle i dont want to commit anything, i want want to leave as it is as before the job started. Only if job runs successfully i want to commit. Where can i set this in the datastage.

some jobs are already running without any problem, but the new jobs that i am trying to run gets aborted. Our server has 4 nodes. Does that means that the 4 nodes are occupied with the jobs already running and unable to accomadate new job? Please let me know. i am also planning to create sequencer ...

some jobs are already running without any problem, but the new jobs that i am trying to run gets aborted. Our server has 4 nodes. Does that means that the 4 nodes are occupied with the jobs already running and unable to accomadate new job? Please let me know.

can anyone tell me what following error means: main_program: conductor node FTWS1LSDMA0#1# E uT#nF#k#P#nEMEo wn0TT 0FFPM 00Pv01Mi04 a150 4 0g5 0e111t774h::5o02 s0:1t257b:3(y5:0n300a(00m200e:));5 3<<h(mm_00aer0iar)nin _no<_p mpr= roa0ogi grnrama_>mp cr>on odcguorcnatomdr nou>de c ctFoor TndWnuSoc1dtL...

i have created different jobs for each columns to update...is it a good approach or does it creates extra overhead compared to all the columns with separate links in single job

ray: i am doing in your way...like i created 4 links from the transformer along with key columns for each column to update, instead of single link for all columns. The job starts without any problem and in the middle it is just hanging ...showing the lines in the blue color and nothing is happening....

i have created a job like following: i/p stage (oracle) ---> transformer--->dataset (job1) dataset -->Transformer-->o/p oracle stage (job2) in the job1 for example i have columns ssn, address, city, postal, state i transform them to some value and writes to a dataset. Then i use this dataset to upda...

we cannot change any properties on the database side, is that anything i can do from datastage side?

is it enough that we change the definition on the datastage side or do we need to do on the database side too?

thanks

they are marked as not nullable

Hi, I have this following scenario, I am updating 5 columns using a key column in a single update statement. While one column has the values in all the rows and the other 4 columns has values sparsely. While updating it is looking for values in all the 5 columns of a particular row and if it doesn't...

Can anybody tell how to overcome this issue. I think there is nothing wrong from the database side. So doesn't make any sense to keep on bugging the DBA I have oracle 9i client on my PC and on Datastage server and connected to oracle 11g database. When i try to execute the same query from both syste...

I am running a datastage job against an oracle table which contains 9 rows.
Due to some reasons the job is never finishing and still showing as RUNNING in the director. Can you please let me know how to kill this job? This is on windows 2003 server

but you dont have a command in windows to grep phantom and kill it, like it is in unix?

As wesd said i tried Plug in Meta data extraction, and that too is hanging. The DBA said that they hadn't done any changes. I was working till last evening and today suddenly it is creating problems. please give me some clues...