DSXchange

[:)][:)][:)][:)][:)] Hi my friends. In the first topic I didn't wanted to start a discussion about if DataStage engine is good or bad, or any other thing. I just want to access the DS engine tables, in order to build a process that lets me clear the director screen. In the director screen, I hace a ...

[:)][:)][:)][:)][:)] Hi my friends. I am working with DataStage since a few months ago. I don't know anything about Universe, and the structure of the tables supporting DS. What I would like is to have the complete structure of the Universe database supporting DataStage, and a manual (or a document)...

[:)][:)][:)][:)][:)] Hi friends. I want to insist in the fact that what I really need is to DELETE the executed jobs, and ended Ok. I want to see no line for these jobs. If in the Director screen you have something like this: Jobname Status A.1 Finished A.2 Finished A.3 Aborted A.4 Aborted A.5 Finis...

[:)][:)][:)][:)][:)] Hi my friends. I think that really, the best solution that I'm searching is to access the DataStage tables, and retrieve the status of each job. Based on this, I will decide which job will be deleted or which will not. But I don't know the structure of these tables, and I don't ...

Kenneth: Thank you for your response. But in the director screen I could have: JOB STATUS ...... A.1 Finished A.2 Finished A.3 Finished A.4 Finished A.5 Finished A.6 Finished A.7 Aborted A.8 Finished A.9 Aborted A.10 Finished A.11 Finished In this case, jobs A.7 and A.9 should not be cleared for fur...

[:)][:)][:)][:)][:)] Hola, mis amigos... When I run the jobs of my application, every one has an invocation id, and several copies of the same job my be running at the same time. At last, the Director screen will have a long list of executed jobs (some finished fine and other aborted), and I need to...

[:)][:)][:)][:)][:)] Hello my friends. I want to thank all of you, because your advices are very usefull for me. I have the routine working now. Finally, I created a distribution list in my Notes and I send all mails to that distribution list. Thank you again. And have a very good day. [:)][:)][:)][...

Thank you Emma [:I]

But the thing is that I have not a Unix system, I have an NT system. And what is DWFindFile ?

Thanks again [;)]


Guillermo P. Barsky
Buenos Aires - Argentina

[:)][:)][:)][:)][:)] Hi. Can anybody tell me what's wrong in the code this ROUTINE ? * * Envio de notas * Ans = ""; Deffun DSX.DSSendMail(A); * xFrom = "From:notificacion-etl@osde.com.ar"; xTo = "To:":pmSendTo; xSubject = "Subject:":pmSubject; xServer = "...

[:)][:)][:)][:)][:)] Hi there. I need to know how can I send a note to several users, from within DataStage using DSSendMail sentence. I put several values sepparated by commas, semicolons, but always I got errors. Can anybody help me please ? Thanks in advance. [:)][:)][:)][:)][:)] Guillermo P. Bar...

[:)][:)][:)][:)][:)] Hi, my friends. Here the problem is that, within a BASIC code, I am generating a seq. file using WriteSeq sentence. At the end of the line, a CRLF character is written. Then, when I send the file to Unix this last character is not confortable for my user.[:(] Does anybody know h...

[:)] [:)] [:)] [:)] [:)] Hi there. I need to know if there is an application to handle the different versions of a job. I have three main projects (Development, Testing, Production). Once the development is finished and tested, I want to automate the movement of components to Testing project, and on...

Ray:

RecordString is the name of the record in the READ.... sentence, or is a function ?

And thank you for answering me.

Guillermo P. Barsky
Buenos Aires - Argentina

Tony:

You understood perfectly well. And that is exactly what I needed.

Thank you very much.

Guillermo P. Barsky
Buenos Aires - Argentina

Hi there. Within a BASIC job, I am reading a sequential file, which was generated by a server job. The file is a comma separated file. I am reading fine each record of the file, but when I want to assign the content of the fields, I cannot. I am using the following formula: AuxField = RecordField; w...