DSXchange

Try searching the forum and on-line help. For example you will learn that there is a Surrogate Key Generator stage in DS EE. There are many other techniques within DS, which your search will uncover. It mainly boils down to two questions for me. One is whether other agencies are likely to be updatin...

Reporting Assistant has been documented as deprecated in favour of MetaStage since version 7.0.

I think you should have installed Visual Studio .Net Before you install DataStage. I think parallel extender server is mostly loaded in Unix OS, Installing .net in Unix is how much reality, I do not know. This option does not hold good If I'm wrong do correct me The OP specified a Windows server. T...

Obvious. Make sure your configuration file path is correctly set.

I must suppose that the data set management utilities check that the nodes in the control file match the nodes in the configuration file. Probably overkill, unless the node information is abbreviated in the control file.

I have a bulletproof routine for doing that. Anyone who engages my professional services for DataStage is entitled to the suite, which includes AddDays, AddWeeks, AddMonths and AddYears (both to dates and to timestamps), fully documented and tested. Essentially the algorithm is to add the months, ad...

After has no real advantages for the ETL process. But that should not preclude ongoing data quality audits of the DW to ensure that processes are not out of control. It is much better to address data quality issues before or during ETL. That way you are much more likely to load "good" data and handl...

The configuration file should be irrelevant to Data Set management. Information about the location of the files making up a persistent Data Set is contained in the Data Set's control file. When you use orchadmin -rm name.ds you specify the name of the Data Set's control file from which the location ...

D'accord, please ignore my post which was based on an incorrect assumption. I can only suggest that you report this as a bug.

Stop pushing. We post as and when we can. Read the post I recommended. Right now I am posting during a break in a training class that I'm running, when I could be eating snacks and drinking coffee. As far as I am aware/concerned, there is no such thing as an "AS/400 database". From one point of view...

I would never put a sql function into a column derivation, simply because it doesn't work. You can certainly use job paramter values in column derivations (I'm assuming that we're in a Transformer stage here). It's the SQL functions that you can't have. On the other hand, if you have an ADD_MONTHS a...

N parallel streams of job activities in job sequence.

Get the run times of each job from previous run and try to get each stream such that the total run time is as close to the same as each other stream as possible.

Park it anywhere from the routine, for example the job's user status area. This is readily accessed as an "activity variable" in a job sequence. But you could just as easily write it (the filename) into a text file or a database table or hashed file. SUBROUTINE ChangeFileName(InputArg, ErrorCode...

The source is a string, so you can use Trim() or Convert() to remove characters. Convert them to zero-length strings ("") and they disappear from consideration.

Search

You are not the first to ask this. Many words of wisdom have been posted. All you have to do is to find them!

Welcome aboard! :D Start by reviewing Transforms such as MONTH.LAST, MONTH.FIRST and so on. Then search the forum for suggestions. Get back if you're still struggling. Adding weeks is easy. It's adding (7 * days). Since dates are stored internally as days (search for Iconv() function), this is simpl...