DSXchange

Hi all, I have routine which connects to database and gets the result. My output from the routine looks like: Ans = SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jun 18 06:43:41 2008 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Releas...

Andw, whatever you have said makes sense and acceptable. But all other jobs with same types of job designs with lesser validations are compiling with in the expected timelines. But only two Jobs with this functionality taking Too much time. At a same time, same datastage UserId is being used by two ...

Hi all, I am have Job Design where i am using Two Stage Variables In transformer stage.I am Validating data Format for Decimal and Integer Values ,Both stage Variables has got almost 150 and 35 'AND' Clauses respectively.But whole design is Taking Too much time for Compilation almost nearly 2-3 hour...

Hi all, In one of my code,i need to perform Number of validations.Henceforth i am going with usage Number of stage variables.So what would be the Maximum number of stage Variables ideally one can have, in a code.My StageVariables involve IsNull() function also for many times.Will Nullability check i...

I too have faced same issue with STP Stage once.
So by that time i was not having enough time to do any workarounds R&D work.
please give us some inputs regading the same,who have implemented this scenario before.So that i too can come to know what the mistake i have done before.

Thanks,

I have searched all the posts,those all point to sequential file stage. But i am getting this error in Database stage.so the solution will be same for all the stages.

Thanks,
aquilis..

Hi, i am not using any sequential file stage.But i am getting "sequential operator cannot preserve partitioning" error for the oracle database stage(DRS Stage). I am doing 'Hash partitioning' in transformer stage and then loading data into Oracle Database through DRS stage. Is it necessary...

when i reset the Job,i do get status changed to 'Job has been Reset'. The code i am using is as follows: *Reset the Job if the job is not in the Runnable State. ResetJobName = JobName gosub ResetJob: hJob3 = DSAttachJob(JobName, DSJ.ERRWARN) If NOT(hJob3) Then ----- ----- ----- ----- ----- Goto Exit...

Even though the job is in aborted state and if we try to reset it knowing that we dont have c++ compilers not installed,will it get reset and will execute properly ? But in this regard, When i try to reset the aborted job ,I am facing the Error Messsage as : " Unable to run job----2 " But ...

Jobs are executed through a JobControl and which itself does the Resetting and invocation of the parallel Jobs.So when we dont have the compilers installed on the environment and previous execution status of the jobs are Aborted,then JC will try to reset it and Run.so will it succeed in resetting an...

all, Is Values treated as Repeating Elements in XML Output stage wont allow Null values or these always should be Unique values. I have mentioned two Columns as Repeating elements In Xml Output stage and I am assigning values for the same columns from the functions DSGetJobInfo(hJob1,DSJ.JOBELAPSED)...

Hi all, I am working on PX Edition, but In my Environment i dont have C++ compilers got installed.Whenever a parallel job gets aborted i try to reset it through user defined Routine before its execution.If a job gets aborted,i know that without a C++ compilers its impossible to compile the jobs invo...

Except the Base Jobs,all other instances of these jobs should not list in the Director Log.That's what my question is ?.
Is there any option in DS to Hide all executing and executed instances of jobs from director list.

Hi all, I have Multiple Instance JobControl Code which Executes again 4 Multiple Instances Jobs.I can't guess how many multiple instances of job control can be invoked at a time,It may vary from 10 to 20 Instances at a time.So which will inturn invoke more number of multi instance jobs involved in i...

Just to verify the New environment ,i built a simple job without transformer stage in it and executed and it was executed sucessfully. Again i built one more job using transformer in it,but this time i was unable to compile my job over here.i end up with the same above mentioned error i.e. ##I TUTL ...