DSXchange

when i was trying to run a server job in data stage 7.2x on windows xp platform i am getting error as

INTERNAL ERROR:(Debug)method '~' of object '~' failed

could anyone help me, Thanks in advance.

Yes we did that and working fine.

This job is working fine with the datastage version- 7.5.1X and is not working in the 7.5.1A version of datastage, both these versions are using the same database. I have checked the parent table and the key column exists in the parent table.

I am getting the following database error . It is a simple auto generated sql query for upset. This job has been succesfully running before but has been failing from last week onwards. Is there any perticular reason this might happen to an existing job??? My other concern is for some reason I dought...

chulett wrote:And there's a little trick you can play with a Transformer as a source when your lookup comes first.

Can u please reveal the trick

Thanks
RR

asarat wrote:Hi,
Does anyone know how to view a datastage table definition export in MS excel/access?

Try using the tool called Repoting Assistant,
By using Reporting you can read the metadata to Excel.

HTH
Neena

Hi Its not the question that which will run fast.. Its a question of which one is more effiecient way.. As my knowedge first one is easy to debug and easy to understand. When ever you are building some logic .. keep it more simple... and more effective.. easy to understand by some others and easy to...

If this is the message then your job is already released by Unix. Try the job now. If the problem still there then check the pid of it again and go to unix use kill -9 pid HTH Thanks Neena Hi, When I go to Unix and issue the command kill 9261 I get a message " Specifed Process doesnot exist&quo...

Go to Unix box .. if you have permissions and Kill the PID 9261(if you are using UNX . Kill command )
If its windows it will take some time to kill the process.
Thanks
Neena

Hi, This problem is not with your settings. DB2 behaves as the same way. You cannot update a single table with 6 jobs at one time. You have to run the jobs sequentially. one after the other.. If you have same data structure from all the 6 jobs then write the outout to 6 sequential files and concat t...

Sorry sonia,
I thought something else..
The scenario i gave you doesn't work for you..
Hope you got your solution already...
Thanks
Neena

Hi Sonia,
You can also use a Exec sh or Exec dos commands and give the pamareter as "rm file.xls" this will run before the your job runs and deletes that file using OS.
HTH
Thanks
Neena

Try Aggrigator stage ...
HTH
Neena

Check your ODBC connectivity parameteres.. Your connect string DSN is not pointing to RIGHT direction

Thanks
Neena

We use to use this in my last project in Dallas. We use to connect to client's servers in CO throgh VPN and then logon to the datastage server that is reciding in clients place. We have only DS client with us and SERVER is at remote location. First we connect to that server by establishing a contact...