DSXchange

Hi Everyone... We have a BUG ... Surprise ?!?! Its make me crazy ... the problem look like in a Routine. Here is the routine : ObtainInformation( Field1, Field2) In a TransformerStage, we call this routine with this value : ObtainInformation(@NULL, "ELEMENT") The BUG, the Field1 (in the routine) isn...

You must start listener and process metabroker if you want capture the data, I suggest you to start listener and process metabroker not from services but from the StartService.bat that you found in the directory of MetaStage. Bye. Salvatore -----Original Message----- From: Kamal, Zahid [mailto:Zahid...

We are in development for one of our project. And would like to test process metadata (generated by the DataStage jobs). I have some test jobs in DataStage and MetaStage in running in Proxy mode. Would we be able to capture process metadata this way?

Thanks...Kamal

I have heard that it is better to set the timeout value to "9999" than to use the "do not time out" flag. fyi, Doug -----Original Message----- From: Rui Soares [mailto:rui.soares@novabase.pt] Sent: Monday, November 11, 2002 9:25 AM To: datastage-users@oliver.com Subject: Timeout - unirpcservices Hi ...

Hi Kamal, you have only to be a little tricky and like experiments. Mayby you can copy your metadatafile directly from Word to ACCESS. If you have DataStage for Windows you can read out then the metadata to the manager and use it with your flat file format. If you have DataStage for Unix you can tra...

Ray, I am also trying to find the answer to this question? What should we do in this situation? -----Original Message----- From: Ray Wurlod [mailto:rayw@mindless.com] Sent: Friday, November 08, 2002 5:12 PM To: datastage-users@oliver.com Subject: Re: Starting a new project It really depends on whats...

Hello Rui, How much time does the job run? There is a timeuot of conexion with client and another one of conexion of a job(API). In version 5r2 there is only one timeout but in previous version there is more that one. With your unirpcservices file I suppouse you are in version previous 5r2. For a co...

Another mechanism, if the number of characters is fixed (for example there are three characters in "567"), is to use substrings. Then a constraint expression might have the form: empno[1,3] = "567" or Left(empno,3) = "567" For longer strings this will be more efficient than Matches operator. ----- O...

The operator in DataStage is Matches. You need to construct a pattern that uses either "..." or "0X" as the wildcard (see the BASIC manual on MATCHES for more information). For example, a constraint expression in DataStage might be: empno Matches "5670X" or empno Matches "567..." Either of these exp...

Hi ppl We had a problem with the dsjob that returned the message > Status code = 81002 > Return Code = 106 81002 is reference as timeout error, so we changed the inactive timeout to "Do not timeout" But we still have the same problem We check the file $dshome/../unishared/unirpc/unirpcservices uvnet...

Hi all, Can we have a global variable defined for a couple of jobs? The first staging load job will extract a value from the database and store it in a global variable so that all the subsequent jobs can use that variable for loading the detail tables. Best regards, Wilcy With luv n thots Wilcy

Hi all, Can we have a global variable defined for a couple of jobs? The first staging load job will extract a value from the database and store it in a global variable so that all the subsequent jobs can use that variable for loading the detail tables. Best regards, Wilcy With luv n thots Wilcy

In a sequence, drop in a RoutineActivity that logs a fatal error message, such as should be in sdkUtilityUtilityAbortToLog. If executed this will cause the sequence to abort. Then point to it from a JobActivity with a link whose trigger with condition "Failed". The routine will be executed if the pr...

Hi all, I have a simple problem with DS 5.2 on Solaris. I have two sequences A and B. A third sequence C runs first A then B. What I want is this: When a job in sequence A aborts I want A to abort, and then C to abort (and _not_ run B). However, what happens is that when a job aborts in sequence A, ...

Will string not work? -----Original Message----- From: Manivannan_Shanmugam@singaporeair.com.sg [mailto:Manivannan_Shanmugam@singaporeair.com.sg] Sent: 11 November 2002 01:35 To: datastage-users@oliver.com Subject: Re: like operator Just wondering whether u can have this condition in your SQL itself...