DSXchange

Kim:

Thanks for your answer.

My DataStage 5.2 is over a Windows platform. And I don't understand what you said me about "...work with quotes around it as well...".

Can you explain me ?

Thanks, again.


Guillermo P. Barsky
Buenos Aires - Argentina

Hi forumers. I am building a .bat file, in order to invoke (via dsjob) a Start job. This Start job has several parameters, and one of them is a path. As every path, it has several "" within the string. I this way, I got an error message, saying that invalid parameters were passed. The Star...

Ray: Let me explain that the test was not a procedure. It was just a test in our development environment in order to prevent the same situation in production environment. You know that the "stop" button in the Director screen sometimes works and other not. It's a good idea to put something...

Hi. I made the following test: 1) Start my jobs in order to check if there are transaction to process. 2) Stop DS services. The jobs continue executing. In the server, there are several tasks like "uvsh.exe" (I guess that really these tasks are the running jobs). 3) I test the functionalit...

Thanks to all for your cooperation. What about using a list instead an array ? As I could see, I can pass a list, and I can address a specific element of the list. As far as I know, I have the following elements to handle a list: 1) To populate the list, I use namelist = code of bank, and this will ...

Ken: I need an array because this array has codes for 44 credit cards, and about of 55 codes for banks (codes and descriptions). Another way to solve this is to make a read of the array inside the MasterJob. But I wanted to avoid this, because this loading will be executing in every MasterJob that s...

Ken: Glad of answering you. My process consists of a job (CHKSAP) that checks in a SAP table (orders for ETL) if there is something to execute. If so, then the CHKSAP triggers the MasterJob job, which has the logic to process the orders. These orders are created in SAP by a SAP user. And for each or...

Hi.

I need to know if I can pass an array as a parameter (from job to another job), and how.

The answer will be very appreciated.

Thanks in advance.

Guillermo P. Barsky
Buenos Aires - Argentina

Hi my friends.

I would like to know if there is a way to compile a job from within a job. Of course that the compiled job wil be different from the caller one.

I accept suggestions.

Thanks.


Guillermo P. Barsky
Buenos Aires - Argentina

Kim:

Thanks. I tried the solution of the Trim() function, but it didn't work.

Any other idea of what's happening ?

Thanks again.


Guillermo P. Barsky
Buenos Aires - Argentina

Hi. Can anybody tell me where is the problem in the next constraint ? (Trim(DatosAFiltrar.SOCIEDAD) = pmSociedad Or pmSociedad = "*") And (Trim(DatosAFiltrar.FILIAL) = pmFilial Or pmFilial = "*") And (Trim(DatosAFiltrar.VIAPAGO) = pmViapago Or pmViapago = "*") And (pmTa...

Ken:

I'll be happy to read the documentation. So, let me know where it is and I will download it.

Thanks.


Guillermo P. Barsky
Buenos Aires - Argentina

Ken:

Thanks for your explanation.

Previous to ask you your product, I would like to read a complete list of the features that it offers to me, pre-requisites, etc.. Could you send me a document with the full description ?

And thank you again.


Guillermo P. Barsky
Buenos Aires - Argentina

Hi. When I had this case, I had to build two server jobs: one for the first time, with the "overwrite data" check in the seq. stage checked. The other job for the next times, had this check not checked, and instead of this I had the "append data" check checked. I had to do this i...

Hi there. I would like to know if there is any problem on using an array as a job handler. Supose the following code: DIMENSION jobs(10) ... i = i + 1 jobs(i) = DSAttachJob("StartCobranzas.221", DSJ.ERRFATAL) IF NOT(jobs(i)) THEN Call DSLogFatal ..... END ELSE * set parameters * run the jo...