DSXchange

Kim: I did not remove anything, yet. My first step is to be sure that I'm retrieving the correct values from the Universe tables (or files). The second step is to use my routine, which gets the status for a given job, with name and invocation id. I built this routine with the help of this forum. If ...

Kim: Here is my code. JobName is a parameter to the job, and its supplied value for the run is "MasterJob". --------------------------------------------------------------------- $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF * OPEN "DS_JOBS" TO DsJobs ELSE STOP; READ...

Kenneth: Thank you for your answer. I have already implemented the logic that you described in your note, but I couldn't believe that having the button, I had to check for the existence of a file, and so on... I appreciate your comments, and anyway, I will be eating a sandwich without pressing the u...

[:)][:)][:)][:)][:)] Hi my friends. During a running of a job, I pressed the "Stop" button (to cancel the job) and nothing happened. The job continued running. The question is: 1) Why nothing happened ? 2) Is there any BASIC sentence that doesn't obey the "Stop" button ? Just in ...

[:)][:)][:)][:)][:)] Hi again. Today I'm working hard....[:D] From a MasterJob a job (let's call it BB), and job BB access to SAP R/3 via the plug in. Sometimes the conection is not up, and the job aborts. Is there a way to check the connection with SAP, without executing a job and waiting the end o...

Thank you, Kim.

Now that I can get the status of a job (from within a BASIC job), what is the name of the API that I have to invoke in order to delete it from the system ? Does it exist ?


Guillermo P. Barsky
Buenos Aires - Argentina

Thank you, Michael and Craig.

I changed the DSLogInfo call and it worked fine.

The question is: why the compiler did not send me an error message, if the sentence I put is: "call dsloginfo(....." and this is not recognized as a valid call ?


Guillermo P. Barsky
Buenos Aires - Argentina

Hi there. I took the following code from one topic within this forum. $INCLUDE DSINCLUDE JOBCONTROL.H JobName = "MasterJob.p1111111111"; RunHandle = DSAttachJob(JobName, DSJ.ERRNONE) JStat = DSGetJobInfo(RunHandle, DSJ.JOBSTATUS) ContinueFlag = @true begin case case JStat = 0 JobStatus = &...

[:)][:)][:)][:)][:)] Hi my friends [:)]. I'm happy to contact you. I would like to know: 1) Are hash files supported by Universe tables, in the DataStage engine ? 2) Are hash files accessible using a UniVerse stage ? 3) Does it exist a way to generate a temporary file, without having the must of del...

Dear friend: Here you have a small routine, which receives several parameters and sends the mail. Parameters are: pmSendTo pmSubject pmImportancia pmL1 pmL2 .... pmL20 You have to contact your administrator in order to see the xServer and xFrom variables how to fill them in. pmL1 to pmL20 are to pos...

[:)][:)][:)][:)][:)] Michael: Thank you. You was very clear. The only way that I found to avoid this is run a job for checking if there are at least one record matching the criteria, previous to run the definitely job. If so, then the job that I want is run. Thank to all of you by your comments and ...

Ray: Yes. This is the case, and I already have the Omit Last NewLine on the Inputs tab check, checked. This is cause I don't understand why the file is being generated yet. Do you know ? Is there any other option in DataStage to select when the files should being generated, when the files has 0 byte...

[:)][:)][:)][:)][:)] Hi my friends. First of all, I want to specially thank to Kim and Ray who answered my previous questions about the invocations ids and the TCl for retrieving them. I am analyzing that, and when I have a conclusion I will post all the results. I have a big problem with files, bec...

[:)][:)][:)][:)][:)] Kim: Thanks for your explanation. Listing the DS_JOBS table, I cannot see the invocation id in the Jobname column. For making the deal, I need to have the estimations (in USD). You can send this to gbarsky@osde.com.ar. Besides, with this work I want all the structure of the tabl...

Kim:

Thank you for your response.

I got the code, but I didn't see the part for the handling of the invocation ids. Can this be done ?

Thanks again.


Guillermo P. Barsky
Buenos Aires - Argentina