DSXchange

Never seen it. How are your users authenticated - internal IIS, operating system or LDAP?

The amount of space occupied by DataStage on the "server" (engine tier) changes hardly at all. The only real increment is in the job logs. As noted in my earlier post, scratchdisk is consumed, but it is consumed temporarily, so anything you could do with a script would have to have the gre...

Why "using script"? And what do you mean by "space"? Space taken for data, space taken for Data Sets, space taken on scratch disk? Do you want to estimate data sizes in text files, in databases, in Data Sets, in File Sets, in memory, what? There are perfectly good utilities withi...

Assuming your database server supports it (which I doubt) you could declare an array size of 600000000.

There's nothing wrong with array size of 2000, it's quite efficient, particularly if the database server handles arrays correctly.

You posted the job type as server. That's what I answered. Within a parallel Transformer stage you will need to craft your own mechanism for translating from JJJ to MMDD. It's not really that difficult, but make sure your solution handles leap years. It's possibly worth the effort of encapsulating t...

Why not review the release notes for Fix Pack 1? They can be found at the IBM Information Center

Your OPENSEQ statement failed. You can work out why. Your OPENSEQ statement lacked ON ERROR and ELSE clauses to trap the possibilities. Your CLOSESEQ statement was given a variable that was not a valid file variable (because of the failure of OPENSEQ then because you used a constant) and it was this...

What Information Server product roles do you have? What DataStage project roles do you have?

The structures and models used in XMETA are deliberately undocumented.

CCYY is the same as YYYY (CC indicates "century"). JJJ is the ordinal number of the day in the year, a number between 001 and 366. The conversion is very straightforward. Oconv(Iconv(Left(InLink.TheString,7), "DYJ"), "DYMD[4,2,2]" : @VM : "MCN") If "they&...

You can create a file with any suffix you please, or even none. Comma-separated values (CSV) is a pure text format, which in fact is the default format for files written by the Sequential File stage. It is not possible to write a file in Microsoft Excel workbook format. On a UNIX machine it would no...

You will just have to wait till next time U (one of our posters) logs in.

The second person personal pronoun in English is spelled "you".

You're right. You're not. And you can probably verify that it's "first in wins" with the second attempt to insert the same row being rejected by Oracle.

There are no square brackets around the new data type. These are used only to show optional syntax.

Please format it properly, with each END on a separate line by itself. It's too hard to tell with what you've given us.

At first glance, though, I'd guess that there's no END for the THEN clause of the OPENSEQ statement.