DSXchange

I need to run a select statement and return the result ( the result is always a single value ), is there a way i can do it?

kduke wrote:The easiest way is to run a shell script which runs sqlplus or whatever.

Hi everyone,

is there anyway I can write a sql statement in a Datastage Basic routine?

Good morning everyone, Can I use a job parameter in Datastage SQL? for example, if I have a job parameter named process_date, and I want to get all the data from a table TBL_Transaction before process_date, can I write a sql like this select * from TBL_Transaction where Last_Update_Date<= #process_d...

Hi everyone, If I write data to a has file that already has data, is it going to delete existing data on the has file? or the new data will do an update or insert to the hash file, that is, if the key of the new data correspond to an entry on the hash file, then update, else insert the new data. You...

found out the problem. It is the function keymanagement.getnextvalue that causes the halt.

Hi everyone, my job halts for no reason, here is the symptoms: the job crashed earlier due to orcle table space problem. after extended the table space, I tried to restart the job, the job seems to be running, but numbers on all links are 0, and there is no error log. I tried so many ways, such as r...

No, only column 1 is the key. This is the user defined SQL UPDATE Dealer SET DEALER_DESC=:3 WHERE DEALER_CODE=:2; INSERT INTO Dealer (DEALER_KEY,DEALER_CODE,DEALER_DESC) VALUES (:1,:2,:3) There's your problem - all variables must be bound, so you can't get away with not mentioning :1 in your first S...

This is the SQL generated by Datastage notice that the DEALER_KEY is the primary key. It is an auto number, I generated it by using keymgt.getnextvalue. DEALER_CODE is the actual business code. UPDATE Dealer SET DEALER_CODE=:2,DEALER_DESC=:3 WHERE DEALER_KEY=:1; INSERT INTO Dealer (DEALER_KEY,DEALER...

Hello everyone, I got this problem when I tried to update an Oracle table. Here is the scenario: The primary key is an automated number. ( I generated it using keymgt.getnextvalue). There is a business key ( not nullalbe, but not a primay key ) on the table. If any new item has the same business key...

msg deleted