DSXchange

Thanks for your reply. Could you please, tell me. How to get the job names I got this in the forum : "Code: Call DSExecute("UV","SELECT NAME FMT '60R' FROM DS_JOBS WHERE NAME NOT LIKE '%\%';",output,sysretcode) Your output variable "output" will contain a multivalu...

Hi Kumar thanks, I will do it the same way. Ray, its the same i need to create. But I have naming conventions in our jobs. But all the link name are different for each an every job. If the input link, the output link and reject link should have the same name, then i can change it in each an every jo...

Thanks titto for the routines. Since I haven't used routines. Could you please tell me how to create a job to use this routines. I know how to use it inside the transformer. But what will be my first stage to get the job name. I have also seen a routine to get the jobname. I have searched a forum, a...

The table has enough space to have a months data. And it is only a staging table. SO it ok for now.

Once the DBA makes a backup, she will delete the logs.

Thanks for the reply.

We haven't cleared the log yet. But to take care of it, I have created a Unix Script calling a empty file and replacing the table with it.

I have to load a table and not to a notification activity as of now.

Iam trying to do it within a DS job. Could you please tell me the functions to be used for those.

Indu

Hi,
I tried to search the forum, but I didn't get it.
Iam trying it with DSJ.

1. How can I find out that the job is running and finished.
2. Is it possible to get the log files that is created and how
3. And to find the stop time of the job and the elapsed time.

Thanks
Indu

Iam getting this warning,

The transaction log for the database is full. SQLSTATE=57011

SQLExecDirect: Error executing statement 'DELETE FROM S.SMRD'. See following DB2 message for details.

Hi,
I trying to clear the table and then insert the row in my job. But the deleted records get accumalated in the log files in the database.

Is there a way in DS to delete the table without getting accumalated in the log file of the DB.

Thanks
Indu

Please let me know to stop the job. When I made a count on the table. Iam not able to ge the counts.

[quote="Indrani"]Hi, I would like to delete datas from a table with a condition. I got the data from the table and then transformed it and want to delete it from the same table. Since it took a long time for just 4000 rows. I stopped it and compiled it. But I see the job seems to be runnin...

Hi yamini, Thanks for the reply. So Get the data that needs to be deleted into a hash file(Just the key alone) in one job and then in the next job, you bring the data(Key column alone) from the hash file and delete from table(With no transformer). Based on the key I need to delete. Only 2 stages in ...

The performance is slow. Can you please suggest a different method


Thanks
Indrani[/quote]

Hi, I would like to delete datas from a table with a condition. I got the data from the table and then transformed it and want to delete it from the same table. Since it took a long time for just 4000 rows. I stopped it and compiled it. But I see the job seems to be running. How is it possible. Is t...