DSXchange

chulett wrote:Unless they mean the first three business days, or the first three weekdays of the month. ...

It should be first three weekdays of the month....

Hi Friends, I need to populate null values for a column on every month 1,2 & 3. Except the first 3 days it should go with some value on other days. Please let me know Is there any function available in datastage to meet this requirement? I just want to know the function used to calculate the fir...

Hi,

I am clearing the logs job by job manually.Please let me know whether it will keep only 7 days old logs which is mentioned at admin level from the next run.


Thanks
Virupan

Thanks a lot for your valuable suggestions..

I am working in Prod environment,SoI cannot delete the jobs and re-import them.If I start clearing the job logs maunally then I will take several hours for me.Is there any other option through which I can purge job logs for all jobs at once.

Hi Friends, I have 100+ datastage jobs with 2 months old previous logs. Earlier I did not define Auto purging in Administrator.I need only 3 days old data for all jobs.I tried setting the 'Auto purge' option in Administartor. But still I am seeing all 2 months old previous logs. Please let me know t...

Hi All,

The scenario here is: I need to extract SAP data from SAP tables using datastage ABAP stage as a Background process.
Your quick response is highly appreciated.


Thanks in advance
Shreya

Hi All,

Whenever I run a sequence ,I am getting error like "Process id failed".
Pls help me out...Appreciate your quick response.



Thanks in advance

Hi All, I am facing a strange error while running a datastage job.Please find below the fatal error: "Contents of phantom output file =>14474 Segmentation Fault - core dumped". I am really not getting how to get rid of this error. Any suggestions are highly appreciated. Thanks in Advance S...

Only 1 job..

I checked the parameters all are mapped correctly..

Hi, I am facing a peculiar problem when I trigger a sequnce.The error I am getting is "Incorrect -dboptions option list; it failed on Expected value for property "user" Expected value for property "password"." When I re-trigger the same job after resetting,Its going fin...

Hi, the posted info insufficient for the analysis, can u place some more info on abort message or logs. thanks Hi, Please find below the error : ABAP_EINA_EINE_MARC_MBEW_A017_KONP: When processing argument -outlinkpropsWhen processing output link property list: { CONNECTION_NAME='#$SAP_CONNECTION#'...

Hi All, I have SAP ABAP stage as source and sequential file as target.I gave all SAP logon credentials.The job was running fine.I renamed the job according to my requirement,I did not do any changes in code level.The job is getting aborted.I tried hardcoding the SAP credentials but still I am not ab...

Try to resolve your warnings first. Do you get any rows in your target table ? Ask your DBA to monitor the load and check for any hanging or defunct process in Oracle (especially if they are sti ... Target table is loaded with 1.2 million records out of 1.8 million.....other records get rejected be...

Let us just do one issue at a time. What sort of warnings are you seeing? Please cut-and-paste a sample to the thread. ... Warnings are due to datatype conversions...One more thing..there will be so many warnings that most of the times when I try to open the log for this job...datastage server will...