DSXchange

As per our project restriction,we can't use script.

sqlplus #p_UserId#/#p_Passwd#@#p_DSN# @#p_SQLDir#/#p_SQLFile#.sql =============================================== Job log =============================================== Server:DLXKSDSTG8 Project:loyalty Job No:189 Job name:test Invocation: Event Number:4 Event type:Info User:mdas Timestamp:12/28/20...

This is my Job Sequence. Execute command Activity--->Notification activity. 1.A sql file is getting excuted in Execute command Activity stage. 2.The log is sent by Notification activity stage. I want this Job Sequence to fail when there is any sort of error like "Opening the sql file" &quo...

A job is reading multiple files using File Pattern. Let my input files are A1.txt,A2.txt,A3.txt,A4.txt,A5.txt. Input file pattern is A*.txt. I want to have exact file name corresponding to each record read from that source file. Output should be COL1aa,COL2aa,A2.txt (comment:COL1aa,COL2aa read from ...

The Before and After job subroutines will only accept 1 parameter. But it is a simple matter to concatenate strings with separators into the one parameter and then parse out those elements in your rou ... But I am able to pass two job parameters in the called unix script in after job sub routine. I...

How to pass job parameters to the called script in after subroutine?

I want to pass 2 job parameters to a unix script,which is being called in after job subroutine.

ray.wurlod wrote:Insufficient information. Can you prove your assertions? What is the job doing? Try not to put too much faith in rows/sec as a meaningful metric (search the forum for reasons why not). ...

Its doing some those extraction,hash file look up,error entries in hash file.

ray.wurlod wrote:If they are extracte as VarChar and coming out like that, then that's how they are in that particular source file. NO conversion takes place for VarChar. Your problem is with your data. ...

No same data extracted correctly in DS6.0 ver for same job.

Job is running fine in DS6.0.

Same job is getting stucked at transformer stages.
The row/sec also getting decreased as the time passes.

But some times same job is running successfully also.

ray.wurlod wrote:JD Edwards has an idiosyncratic way to store dates. Extract them as VarChar and convert them within your job. Search the forum for examples. ...

It is extracted as varchar.

Point is that same job with different source file is working fine.

There are many fields which are getting extracted from JDE.

But all fields except two date & time fields are exteacted as 00-00-0000 & 00:00:00.

All other fields are getting exatrcted correctly throgh that same job.

A job was running in Unix.
The specific process corresponding to that job was killed to stop that job.

Process got killed.
But its still showing Status as Running.

Job even can't be compile.
Please suggest.