DSXchange

mandyli wrote:Hi

I would like Trigger the Job whether job status 1 or 2.

What is actual expression for this ?

Thanks
Man

I guess it will be something like this:

JobActivity1.$JobStatus = DSJS.RUNOK Or JobActivity1.$JobStatus = DSJS.RUNWARN

JobActivity1 is the Job Activity Stage name.

The Job is reading data from Oracle Database in a parallel Job and its speed is 600 rows per second. Can anyone tell me as to should i increase the number of records read per minute. and how should i increase the number of nodes in parallel Job. Thanks Ashish Gupta +919922892057 I observed that Ora...

I am assuming that there are no constraints (primary/foreign/unique keys) except some checking constraints (e.g. some columns are non-nullable). In the Oracle Enterprise stage, did you specify the option DISABLE CONSTRAINTS to FALSE? If you set it to TRUE, Oracle will spend some time enabling the no...

what value did you assign to $APT_ORACLE_LOAD_OPTIONS? Is that table partitioned? Are there any constraints/indexes on that table and how did you maintain the indexes/constraints during loading? How many records are to be loaded and how many records exist in that table? =============================...

Have you ever tried to use DECIMAL(10), DECIMAL(5), DECIMAL(2) instead of NUMBERIC.

albasir wrote:
So, i am using the following datatypes in the DS job

NUMERIC (10)
NUMERIC(5)
NUMERIC(2)


Thanks

Is a job parameter better than an environment variable for this case?

Mhasan wrote:if we have many number of source systems ... is there anyway (or routine who can serve the purpose)

Set the value of the environment variables in your job to $PROJDEF, if the value of the environment variable is subsequently changed (e.g. you can change the value in DS Administrator), the job will pick up the new value without the need for recompiling. Not sure if this is what you are after. =====...

Well, in our project, the only reason that we want to do it in DataStage could be, I guess, we want to utilize the parallel processing capability of DataStage to handle huge volume of data. Database like Oracle does have parallel processing ability but it is not as flexible as DS. Exactly. So, why t...

Do you guys think a parallel routine could achieve this? I will have a similiar requirement in our project.

kduke wrote:We did it in DataStage by running a job over and over until it selected 0 rows. What a mess. It is sort like drilling down one level at a time.

Or if you can afford the cost of Basic Transformer, the server built-in routine MatchField does the trick:) If you can do this in UNIX or Oracle (Oracle supports regular expression), pattern matching may help. Or you could call shell commands in your job somehow, e.g. echo yourfield | grep -c -e &qu...

If you can do this in UNIX or Oracle (Oracle supports regular expression), pattern matching may help. Or you could call shell commands in your job somehow, e.g. echo yourfield | grep -c -e "word1|word2..." Or you could write a parallel routine to achieve this. Hi ArndW, I think this is not...

It may be an issue with the compiler/linker options. Are you using dynamic or static library? Anyway the object file optin will always work :) . I would recommend to use the same compiler options as DataStage (APT_COMPILEOPT) when you compile the C++ codes into the object file. I am trying to write ...

Did you set the environment variable APT_ORACLE_LOAD_DELIMITED in your job? Also are there any double quotes in the input data? What error did you get in the sqlldr log? Can you post the sqlldr log file? Sounds like there might be a bug when DataStage creates the load file and doesn't inherit the ex...

I would run a shell script as a backgroup process to check the existing of the file and then trigger the DataStage to run if detected. as i said earlier, a file is dropped in the folder by another program anytime of the day and i should 1st check if any file has come into the respective folder, if s...

Check the APT configuration file of your job and the scratch disk should be the location for Oracle sqlldr logs. Thanks for your reply I don't know where can i find this oracle log.. Please let me know if you have any idea.. Thanks. And what does the Oracle error log file contain? That will tell you...