Hi,
I am doing a project converting stored procedure to datastage. I am wondering whether you can use datastage to delete rows, here is the original sql statement.
DELETE FROM IN_PLAYER_MASTER
WHERE
Acct IN (Select Player_Acct_Num FROM EXD_PLAYER_MASTER )
I was trying to use user-defined SQL, but when I executed the job, I got bouch of warnings.
Any suggestions? Or using stored procedure is my only choice.
Thanks,
Yiming
Delete rows using datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Re: Delete rows using datastage
Hi Yiming,
What kind of database use???
Can you explain how is and work your job ???
What kind of database use???
Can you explain how is and work your job ???
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
Re: Delete rows using datastage
Oh. You were doing just one stage, I suspect?
Do this:
2 database stages:
[input] -> [output]
For Input: Select [field] from [table]
For output: Delete from [table] where [field] = [input column]
-T.J.
Do this:
2 database stages:
[input] -> [output]
For Input: Select [field] from [table]
For output: Delete from [table] where [field] = [input column]
-T.J.
Developer of DataStage Parallel Engine (Orchestrate).
Just run this as a sql script from either a BATCH job using DSExecute or from a command stage. Use the appropriate command line syntax for your unspecified database. If Informix, use dbaccess. If Oracle, use sqlplus. If SQL-Server or Sybase, use isql. If DB2, well, someone give that answer.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Re: Delete rows using datastage
Thanks, everybody. The problem has been resolved. I made a typo in the SQL statement.