DSXchange

In Oracle SQL you could simply create a "derived" column in your Source OCI stage:

This is how to subtract 1 second:

(SYSDATE - (1/(1*24*60*60)))

This is a typical pre-process type of problem that is easily solved outside of DataStage. Too much emphasis is being placed on DataStage to do flat file manipulation. This can be much more easily done in Python or Perl and then the resulting file is your input for your DataStage job.

IF this is a flat file, it is usually better to pre-process the incoming flat file outside of datastage and create a new flat file. Yes, you can use DataStage by creating a Hash stage, etc. but the processing may be slower than a simple script (perl or python (I prefer python)) that will preprocess ...

Promoting from float to decimal only requires that you have the appropriated length and scale in the decimal column. No transformation is necessary.

When I import a scheduled job/batch into a project, the schedule portion disappears. I would like to retain that information and have DataStage not overwrite the schedule information.

You should manage this via user groups. Let Unix level admin persons take a group out of access, because as DataStage has ZERO functionality in this regard. The closest you have is to use Admin and revoke all of the groups with access. Then, you have to go back and add them again when you're finish...

1stpoint, you'll need to get the developers off the jobs when you want to export/import, and i believe the only way is to ask them to get off the server jobs (ok, perhaps not the only way). That is not exactly what I am requesting. What I would like to see is a lockout capability so that we can per...

Yes, I do have a trailing #. The correct format of my where clause is:

WHERE Year||Period Beween '#PriorPeriod#' and '#Year#'||'#Period#'

Actually the Job is aborting without any error. I modified the job control slightly: DEFFUN PeriodAdd(A, B) Calling "DSU.PeriodAdd" PriorPeriod=PeriodAdd(Year:Period, -1) I also added a Job Parameter PriorPeriod (String) because I wanted to use it in a transformer to show if it was being c...

I have a DataStage job with 2 Parameters: Year 2004 and Period 01 In the Job Control of the job I have a sentence that says: PriorPeriod=PeriodAdd(Year:Period, -1) In my first stage (Oracle) I would then reference the Parameters as: WHERE Period Beween '#PriorPeriod#' and '#Year#'||'#Period' This is...

Can you provide more specifics, like Db Connection (ODBC, etc). Your environment details as well and exactly what happens when it "freezes".

Maybe you can just pre-process (cat) the 2 sequential files together and then process them with a simpler job design.

Source Stage (OCI/ODBC) Select ... From SourceTable Where TimeColumn > (select max(LastExtracted) from staging_control_table) @DATE contains the date/time the job was started and will update the LastExtracted date when the job finishes. I would use an aggregator stage to save this value and an updat...

This is an InfoSource file and probably internal to SAP/BW and most likely a permissions issue.

Your post contains alot of *missing* information. We can best help you if you can further describe both server environments, database/network connections to<>from both, etc.

Our upgrade was painless and have been testing for about 4 weeks now with no problems whatsoever.