DSXchange

In Job properties, make the job parameter default value as $PROJDEF If you set the PASSWORD as Encrypted,. I hope it works. I have installed Datastage 7.5 server on AIX 5.3. I am using Datastage 7.5 with peoplesoft EPM8.9. After installing DS server when I run any job I get an error as follows Unkno...

Convert your input format "MM/DD/YY" into Internal format(using IConv) and then convert that internal to Julian format which gives "MM/DD/YYY hh:mm:ss" format. Hi All, I need to convert date from"MM/DD/YY" to "MM/DD/YYY hh:mm:ss" format. Thanks in Advance.

Hi,

Can we Format a Null value to certail length?.
I need to assign a Null value to one of my fileds which is having length of 10.
Any input would be appreciated.
Thanks.

But, the no of filenames is unknown.
How would I approach?.

Thanks in advance.

ArndW wrote:My fault in misinterpreting, each job activity stage will wait until it's job has completed before continuing. You would need use a sequencer and have parallel streams within the look.

Hi,
How can i make the job activity should start parallel without waiting for the job completion?.
Which property do i need to set?.

Thanks in advance.

ArndW wrote:make sure the job activity doesn't wait for job completion and you will have things running in parallel.

Hi, I have a sequence job with StartLoop and EndLoop activities.In between these two iam calling two more multi instance sequence jobs.In the startLoop activity iam getting string of filenames with 'comma' delimited.I want to process all the files parallel.How can i trigger the multi instance job? t...

So when do we use $ENV?. as you said " $ENV picks up the default value from the user's environment.". where do we set the defaut values in user's environment. could you explain me bit more please. Thanks. You're misled/confused. When the job starts the values of job parameters are read, an...

So by using the $ENV, I can change the value during the runtime from the Director. Is that right?. Correct me if iam wrong. Thanks. $ENV picks up the default value from the user's environment. $PROJDEF picks up the default value from the project; that is, the values set in the Administrator client a...

What is the diff between $ENV and $PROJDEF?.

Thanks.

ray.wurlod wrote:$UNSET specifically unsets the environment variable. So that, when time comes to check it, it is not found and the default is used. Perhaps you want to set its value to LOAD explicitly.

Function GetStatus(JobName) $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF If JobName = DSGetJobInfo(DSJ.ME, DSJ.JOBNAME) Then hJob = DSJ.ME Else hJob = DSAttachJob(JobName,DSJ.ERRNONE) Ans = DSGetJobInfo(hJob, DSJ.JOBSTATUS) ErrCode = DSDetachJob(hJob) ; * this is a vital step! Return(...

Hi Arnd, As per your suggession i have changed the code to Function GetStatus(JobName) $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF If JobName = DSGetJobInfo(DSJ.ME, DSJ.JOBNAME) Then End Else hJob = DSAttachJob((JobName), DSJ.ERRNONE) JName = DSGetJobInfo(hJob, DSJ.JOBNAME) End If JN...

Now its working fine after changing the SQL. Iam not taking the current job name. with the above code, when i compile the routine it gives one warning message: WARNING: Assignment to variable JobName on line 7 will modify an input argument. If input link column variables are used as arguments to thi...

I am using the UV stage as source with SELECT NAME FROM DS_JOBS WHERE NAME NOT LIKE '%\%'.I have written a TransformFunction with the above code.I am passing the NAME as parameter to the Function.It works fine,but takes lot time.(It has only 15 names, it took 25 min). what could be the reason?. Than...

In the above code hJob = DSAttachJob((JobName), DSJ.ERRNONE) JobName = DSGetJobInfo(hJob) Is this the correct or JobName = DSGetJobInfo(hJob,DSJ.JOBNAME) Thanks, Look at the code. It returns -1 if the job can not be attached - that is, if the job name can not be found. The routine works as documente...

Hi, When iam passing the JobName as Trim(JobName), the job is aborting. When iam passing the JobName as JobName,The job is running but it gives the status as -1. Any clues please. Thanks. DSJS.JOBSTATUS does not exist. The -1 you're getting is an error code meaning "bad handle", that is yo...