DSXchange

I believe that you might have seperate reject folder and all you reject files might come to it. I have not tried this, but i thought this may work for you. Every day when your new ject files are created try to put them into a new folder (like .../reject_folder/reject_folder_current_date) and try to ...

Hi I have situation. I have several jobs that need to update a control table once it completes. For example job1 after completion ---> JobRC(update run_control_table). right now im using the following logic to accomplish this in the job activity (job1) $JobStatus = DSJS.RUNWARN Or $JobStatus = DSJS....

Hi, If I understand you correctly, 'You want to send one email with all the rejected files, provided if they have any records in them'. In this case you can directly use the notification activity stage and in the attachement space list all the file names (with path / parameter). i think is would fix...

modify the shel script, so that it will send the email only if the reject file has any records. May be you can do a count lines (wc -l) to count the number of lines in the file, and if the number of lines is more than 1 (assuming that the first line is column names) then send email else ignor it. le...

chulett wrote:Well... that "comples" in the subject is a typo and should say "complete" not "compile", but I would wager you knew that.

Im Sorry about that. Next time I will make sure this dosent happen.

Thank you so much, i will go through the pdf guides.

Hi We have nearly 200 to 250 jobs (server jobs and parallel jobs) that run everyday, ymy question is, is there any way we can create a job that will identify the jobs (job names) that completed with status Finished / Finished with warning / Aborted and load them in a table or send a report as email....

Hi the issue is resolved now. the source database has a NLS setting of US7ASCII and the target DB has UTF8, and the column width is only 3 in both DB's. So i was not able to insert the data, by using the following cinversion function this was fixed select convert(Col1, 'US7ASCII', 'UTF8') FROM table...

Hi Im in the process of converting server jobs to parallel job. In server job we have simple job (ODBC source ---> Transformer ---> Oracle target). no transformations in between, its just a direct pull. I have column in the source and in target (say COL1- varchar2(20)). When i checked in oracle for ...

Just write a normal select query with where clause (do not include orchestrate. in this) you should be fine. let me know if this dosent work.

Your question is not clear, but to my understanding you are trying to do a look up and in the loop up oracle stage you are writing a query... if i understand you...

In this case you can write a normal select query without where clause. if im worng please give more detail.

If you want to unlock the jobs based on process id, then use this.

In DS Admin

Ds.tools
Choose option 4 (Administer processes/locks)
Choose option 4 (List All Locks)
Note the PIDs
Choose option 7 and enter PID

Use this,

list.readu

then select the user, and use this command to unlock

unlock user <specify user number> all

this will release/unlock all jobs for that particular user.

After you create the file use the after job subroutine to rename/ move the file with a new file name. Use the following command to rename with date or date and time Example file name: New.txt mv New.txt New_`date '+%Y%m%d%` this will rename the file with the date ----------- If you want to add times...

the job log says it all. you need to Check for the delimiter. try to specify your own delimiter and test it. I use a Pipe symbol (|)