DSXchange

The same software will not install on both Windows and Linux. Are you trying to do this, or do you have a Linux version of DataStage that you are installing?

Holidays?!! Luxury!!

Instead of Floor() use Int() in server jobs.

There is no equivalent for Months_Between in the product, but some have been posted in this forum.

Last_Day() is probably best replaced with the MONTH.LAST Transform.

Depending on the database, transaction isolation level may be implemented using locks. Lower isolation levels tend to use record-level locks, while higher isolation levels may well take table-level locks.

Job sequences generate BASIC code. That's not going to change any time soon. You can inspect the code on the Job Control tab of the job sequence's job properties window.

The guidance we have is that policy is unchanged from Ascential's - an evaluation (time limited) licence will only be provided if there is a strong chance of a sale - and it's they who assess the likelihood.

The DS Admin probably won't be able to allocate more space - you need to talk to a UNIX Admin, or just find another file system to which you can write and which has plenty of free space. The other question is hijacking the thread. Please start a new thread for it. Searching might even find an answer...

Make sure everyone always disconnects cleanly.

No space left on device usually refers to your disk - specifically in this case the disk where your Sequential File stage (the only stage type that exposes the ds_seqput() function) is trying to write. Check for disk full situation there.

My earlier answer without the WHERE clause would do the Cartesian product thing, and DISTINCT would hopefully restrict the result to a sensible number of rows.

It is provable that A LEFT OUTER JOIN B is the same as B RIGHT OUTER JOIN A - on this basis some query tools either don't bother to provide right outer join functionality, or transparently rewrite right outer joins as left outer joins. And why not? So heed the advice about swapping your driver and p...

CNAME (both syntaxes) definitely exists in Prime INFORMATION.

Let's see... wasn't Trigger the name of Roy Rogers's horse? Seriously, your question does not contain enough information even to begin to be able to provide an answer. What is your context? Where are you finding "a Trigger column"? Are you referring to triggers on columns in databases? Are you refer...

I don't seen any convert functions in that SQL - do you?