DSXchange

So what is the resolution. I have the same requirement ; running multi instance job N times simultaneously based on the job parameter N.

Is it possible to do it with a job sequence? or it has to be a job control job?

So what is the resolution. I have the same requirement ; running multi instance job N times simultaneously based on the job parameter N.

Is it possible to do it with a job sequence? or it has to be a job control job?

ray.wurlod wrote:Right click in the columns grid of the table definition you have already in DataStage and choose Save As to save as a schema file. ...

I can't find this feature on my table definitions, I am using 9.1 Parallel job. Am I doing something wrong? I want to create schema files from many database tables

Hi, I am getting the following run time error in test environment while the job ran fine many times in dev environment ( same box different project) Xml1,0: sh: dbx: not found The above message is logged as warning and the next thing in the log is the error with the following message Xml1,0: Operato...

Thanks again Ray, We have SunOS so I could not find the environment folder under /etc (or my userid does not allow me to see it.) The interesintg thing is that when I login to my unix account via shell and do echo $USER it shows my userid, however if I create a dummy parallel job and use the same co...

Nope, I asked the admin and checked together it was not the same.

Hi Ray, yes, sorry I guess I wasn't clear on my previous post. "ISUSER" shows who ran the job. But "USER" does not. I just wanted to understand why value for "USER" is same for all job logs.

Thanks

Thanks Ray, I guess it can be set to any value and it can not be trusted ( do not mean much). Because in our case, the value of the USER is same for all the job logs, no matter who runs it ( the ISUSER shows that information). it is also not the person who started the DataStage engine, it is not the...

Hi Everybody, I was wondering if anyone knows what does the "USER=XXXXX" in the directory second log entry mean? in my log, it just appear just before the environment variable "WHO" which represent the project name. I could not find what it represent, it does not represent who ra...

Never mind , We found the issue, For those who are curious, it was the oracle connector stage which we think was somehow corrupted, We replaced it with a new one and it worked.

Thanks

Hi Everybody, Did anyone come accross that the Oracle connector stage is not recognizing the custom SQL when used in server job. I just created a simple job that reads from oracle through oracle connector and write to a sequential file. The interesting part is that I can view the data. Here is exact...

That is exactly waht I do NOT want. I did not intend to treat it as two fields, I intend it to treat one field. It is coming as one field and I want it to leave the transformer as one field. I just want the incoming field enclosed in double quoted, that's all. I think that is the definition of this ...

Have any of you guys experienced that the DQuote function is not working properly inside a parallel transformer? here "is not working properly" means that it is introducing extra escape characters. For example mylink.mycolumn value is ABC"",""EFG when I use Dquote(mylin...

thanks Franklin,

ok you convinced me that it is an important concern, but I did not really understand the solution. All I think is to put Nested condition stage to the beginning of a sequence as a first stage and check the parameters if there are empty or not and go from there.

any other ideas?

Hi All, I was wondering if it is possible to make some or all of the job (sequence) parameters mandatory to fill it in, otherwise the job should not proceed, ( abort as soon as it runs). The reason I need this, our QA testers are testing the jobs by clearing out some of the default parameters and se...