DSXchange

No you don't. MONTH.LAST(TheDate) gives you the last day of the month in which the date occurs, in internal format. Therefore, (MONTH.LAST(TheDate) + 1) gives you the first day of the following month. Quarters are a little trickier, you probably do need a custom routine. Examine the supplied routine...

Can't take credit for that one, the big post therein is one of Ken's.

DataStage is no different from any other software development life cycle - at least not if managed correctly. What happened to the user acceptance testing phase? Anything that's likely to be different in the different environments should be parameterized. This includes things like DSNs, user IDs and...

Probably the easiest thing to do is to specify user-defined SQL. Then you can use your exact query; depending on your stage type the tab caption may change from "View SQL" to "Edit SQL". The other thing that must be borne in mind is that the columns in your design must agree absolutely with the numb...

Search the forum. As far as I am aware, Ascential has no plans along these lines. Why not ask them directly? Post this question on Ascential Developer Net

There are at least two ways to get partition parallelism in server jobs. But the description of what it is is to be found in the Parallel Job Developer's Guide . Please do read this, even though you aren't in a position to develop parallel jobs. It is merely an introduction to the concepts. You shou...

Welcome aboard! :D Don't worry too much about that yet. Get familiar with the graphical design metaphor. Big picure stuff; draw a picture of the ETL that you want to occur, and fill in the details to specify exactly where the data are. Take the training classes; they will guide you through building ...

Ascential run a series of training classes. Some of them are available for delivery via the Web. Check out Ascential Software web site for more information about Education (it's under Services). The training series runs "DataStage Essentials", "Advanced DataStage" then "DataStage Best Practices" tho...

Send your mail as HTML or XML and you can go completely crazy with tags. On the down side, YOU will have to put the tags in.

Welcome aboard! :D Please edit your profile, tell us a little more about yourself and how you're using Ascential products. This isn't a marketing site; it's a user community (your details are not used for any purpose). Ascential run a series of training classes. Some of them are available for delive...

Open the project properties. On the General tab there is a command button labelled Environment... This is where you need to be. New environment variables must be added as "user defined"; however PATH is in the General category. Make sure you include anything that's already in PATH when setting its n...

In the DataStage Administrator client you can set up "user defined environment variables" and create ORACLE_HOME (and any others that you may require, such as ORACLE_LIB, ORACLE_BIN, ORACLE_SID and so on, and any additions to PATH). You can alternatively go to Control Panel, System and set environme...

Well I hope at least a few others know (for example the Ascential engineers!). The UV_SCHEMA table is not where the host name is stored, but it wasn't a bad guess. When you create a project entries are placed in the SQL Catalog recording the existence of the schema, the EXAMPLE1 table and the DBA us...

I agree with Sumit's assessment. Thirty Char(1) columns requires hardly any processing at all. A column that is passed through a Transformer stage with no derivation requires zero machine cycles (and therefore has zero cost); inspect the code generated by compiling a Transformer stage to convince yo...

That's the documented behaviour of before/after subroutines.

However, in a Routine Activity you can specify custom triggers or triggers based on any return value. Having these overrides the default "activities that fail" rule.