DSXchange

Thanks, but what I really need is to hace a job running, and each 5 minutes to look at the list of executed jobs, to analyze if some of them is in Aborted status. This should be done automatically by a job running in background, and when an Aborted job is detected, a note should be sent to me. What ...

Hola mis amigos.... I need to know how can I do to get (by means of e job) the executed jobs listed in the Director screen. Take into account that my application uses the invocation id, so, there are several occurrences of the same job in the Director screen (JOBA.ID1, JOBA.ID2, etc.). Any help will...

Hola mis amigos ...... :D

Are there any "standards" for programming in DS that can be shared ?

Thanks, but I have not the option for deleting rows. I'm using the ODBC stage.

Hi, my friends... :D

Given a file which is composed by keys of a table, I need to delete the rows of the table corresponding to the keys of the file. I mean, for each record of the file, I need to delete the rows of the table.

How can I do this ?

Thanks in advance.

Thanks a lot to everybody. I used the last given solution, which I consider the easiest. But, I had to convert in the following order: 1) Replace the decimal "." for a "-". 2) Replace all "," for the ".". 3) Replace "-" for the ",". EREPLAC...

Hi my friends... I need to convert a number which represents an import, and instead of showing $9,876.54 I need to show $9.876,54. I mean, I ant my decimal point to be the comma ',', and the thousand separator to be the dot '.'. I am using the Oconv function with the format MD2,$, but I'm getting th...

Ok Guru.

I'll try what you are saying, but I'm not understanding why I cannot use the DSWaitForFile activity of the sequencer to check the existence of a file within a loop activity.

Thanks again, and have a good day.

Let me clarify, if I can. The DS process should be up from Monday to Friday, and it should be waiting for a file comming from SAP. The process of this file depends on the user decision. May be some days there's no file, and another days may be more than one file to process. So, what I really need is...

My StartLoop activity is working from 1 to 500. But in the middle, I need to check the existence of the files. If just PROCESSFILE.TXT exists, a job is invoked and then I have to continue with the loop. If ENDFILE.TXT exists, I need to force the endloop activity, setting the $Counter variable to 501...

Hola mis amigos...... I am building a sequencer, which is controlled by the appearance of two files: PROCESSFILE.TXT indicates that the loop in the sequencer should invoke a batch job. ENDFILE.TXT indicates that the loop should end, and the sequencer also should end in a normal mode. Any idea on how...

Thanks, Craig.

We will try the option of loading a temp table, and then make a join.

Really, I love this forum because you answer me faster than the consultants here in Argentina.

You are so great.....

Have a nice day.

Thanks, but the table may have about 3,500,000 records, and the file about 20,000 records.

The process is a daily process, and I think that this can take an important time to load the table.

Thanks anyway.

Hello my friends..... :D I have a seq file with fields KEY1 + KEY2. This file has several records. For each of the records in the file, I need to access a SQL table with the exact value of KEY1 + KEY2. How can I do this in a server job ? I don't know how to use fields KEY1 + KEY2 of the file, and in...

Hola mis amigos.....

I'm trying to execute a DSWaitForFile with something like *.TXT as parameter to the function.

Is this possible ? Is there any special hint to take into account to have this working ?

Thanks in advance.