DSXchange

I am using transaction size as 100.The update query is working,Problem is its like 100 record updation/min which is too slow when i need to update 20 thousand record,this speed is not acceptable...... :cry: Try user defined query instead of generated query or else you can write a store proc for upd...

kcbland wrote:Does your procedure return any rows to DataStage? ...

No , it wont return any rows to datastage , the main objective is to run the procedure through datastage ,so that some tables are populated which are used in next level jobs

Hi , I am using an ODBC stage to call a store procedure with one paramater , whenever i am running the job it is not coming to finished state , it is in running state only till i abort it , but when i run procedure separately it is going fine . Can some one please tell me what cauld be reason for th...

DS_SUPPORT wrote:What is the DB stage you are using? In the DRS stage, we got this error , and we had applied a patch to resolve this.

I am using DB2 stage

Hi , I have a job in which in i am using three table all with same credentials. I parameterized one of those tables credentials and ran the job but that job is aborting at the parameterized table with other two tables running fine .The error is "DSCGetStrStageProp Value(???) of property (PASSWO...

I resolved it .Thanks for all

Hi ,

While i am running the master sequence , a job in subsequence aborted but master sequence didn't aborted and finished fine.Any solution will be appreciated.

Tried the same did not work...any other solution please Try the basic solutions listed below first. 1. Close and open the pallete. 2. Close the DS Designer and open it. 3. Restart the 3 DS services "Datastage Engine Resource Service", "Datastage Telnet Service", "DSRPC Servi...

hi

In sequences when i was trying to view the properties of any job activity it is not coming , and in palatee all stages are coming in a single block i.e,. no separate view for file stages , dataases , active stages .Please help me in finding the solution.

Thanks
major

HI ,

When i try to issue dsjob command from command line it is coming as "dsjob command is not in your VOC"
pls help me in resolving this

Hi,

You can use DateCurrentDateTime("1") function to get the current time and eliminate previous records using above

WoMaWil wrote:If your Server is Windows you can write a batch file for to do it. Look into the manual after the dsjob-command.

hi,
thanks for ur response, i am using windows sever,but i am new to datastage , can u please elaborate more on this?
thanks in advance

hi,

can we able to run jobs from command line in windows evironment?
if yes can someone please suggest me with the full commands of running the job and to get the log details of that job

thanks in advance

Hi,

is there any command to export all jobs log to a text file in windows environment?

Hi,

I want log files of all jobs to be written into a single sequential file without using Datastage Director in windows environment . Can someone please suggest me a good solution

Thanks and Regards
major