DSXchange

You could take a look at the QUARTER.TAG Transform, but this is not quite what you want. It expects a slightly different (again!) input date format, and returns yyyyQn.

You could, however, use this and the expression earlier as the definition for a new Transform that does exactly what you want.

There are a lot of clever tricks built in to the Sequential File stage, including read-ahead and write-ahead buffers. This means that there will be some time before you will see any rows actually appear. It seems to be 1000 rows before any rows are sync'ed. These buffers can not be accessed or confi...

My lookup doesnt have any matching condition. In that case, in a server job, you don't have a lookup. It's as simple as that. On the other hand, what you are possibly asking is that, for some rows, your lookup does not succeed. In this case you want to capture those rows, and direct them to another...

For some reason (ISP?) my posts are taking a long time to appear today.

Umm... it's just a word in my vocabulary. Possibly from long exposure to Latin - the root verb is parcere (to spare, as in to be sparing with).

QualityStage server is needed on the machine where you execute your jobs. It runs a process called qsserv . QualityStage designer is a Windows-based tool where you design your jobs. QualityStage DataStage Plug-In is the package that contains stage types that allow you to invoke QualityStage componen...

I can't find the file yousucks.h on my installation, and find it almost inconceivable that an error message would be reported on a header file, or even that a header file would contain more than 10000 lines.

Unfortunately, I've had to have some vigorous discussions with clients who wanted to go with the cheapest they could obtain.

It's a bad approach; you spend that much on the software, and want to be parsimonious with the hardware?

Derivation expressions in the Transformer stage are just that; expressions. You specified that your derivation expression was OutLink.Quarter = OCONV(ICONV(InLink.InDate,"D4/MDY"),"DQ") In fact, you only need the right-hand side. OCONV(ICONV(InLink.InDate,...

You're probably at the wrong command line. And it's not an interpreter - it's compiled BASIC. The command line where you need to be is that of dssh . Before you invoke this shell, make sure you are attached to your DataStage project directory. If ever you see the question "This directory is not an a...

VarChar - or a variant thereof - is about the only data type supported by DataStage for passing a hyperlink (as a string).

I prefer Oconv(@DATE, "DYMD[4,2,2]" : @VM : "MCN") as I said very recently.

Arguably one should be able to use "" as the separator character, for example Oconv(@DATE, "D''YMD[4,2,2]"), but this does not work.

I prefer The first piece is the date conversion, while an "MCN" conversion keeps only the numeric characters.
Read the on-line help about "MC" conversions in Oconv.

In a Transformer stage initialize a stage variable - let's call it svTotal - to 0. The derivation for the stage variable (which is executed as each row is processed through the Transformer stage) is of the form If InLink.Column[26,1] = 'c' Then svTotal + 1 Else svTotal This increments only if the va...

"Clear" means "reset", that is reset to job/project defaults.