DSXchange

Can you use CURRENT_DATE, or SYSDATE, or whatever it is, in your SQL or load script?
If that's the wrong data type, you're deep in the brown stuff!
Or, similar, make the default value for that column CURRENT_DATE or whatever.

The "for Dummies" series is published by a company that owns the rights to the title concept. However, I would argue against "DataStage for Dummies". It is really too complex a product for this kind of treatment. All you could cover is how to drive the tools. Allow me to share one of my favourite qu...

Jane works out of Singapore, but does cover India. Peter Zeglis recently came on board for Ascential to manage education and professional services in Asia-Pacific; he is based in Sydney but, like all of us, is on the road a lot. He was in Kuala Lumpur yesterday, for example. I posted earlier that he...

I suspect the question is about determining the ASCII value of a character. The function for this is SEQ() - provided that you only want to process single-byte characters. For example, SEQ("A") returns 65, and CHAR(65) returns "A". If you need to process multi-byte characters, then the functions you...

Getting buy-in for the staging area isn't too difficult give clients who are prepared to listen intelligently to rational argument. In essence there must be two (minimum) weapons in the consultant's armoury here; a few horror stories about where it went pear-shaped, and why (none of these examples h...

Sandyha originally sent me a private message. When I replied to that I highlighted the advantage of making questions available to more potential answerers, and of sharing those answers, by posting on the Forum. As a new poster Sandhya may not have gotten as far as the FAQ. Maybe be we need a "read m...

... or even a query (for example, for one side of the difference):

For extraction, VERY similar, provided the database and client software and connectivity components are properly set up (like I said, VERY similar). There are a few things that are syntacticaly different for user-defined SQL; Oracle, for example, has an idiosyncratic way to represent an outer join i...

Is there any way to do this with an Oracle table? A hashed file is a table in the UniVerse database (aka the DataStage Engine database). If the answer is no in one, it's no in the other. If you want to access rows in a hashed file, you use the correct query languages, just like you would with other ...

chulett wrote:the specs came to me on Monday and it goes into "production" tomorrow. Ha!

Bets?

Very easy. Export from one, import on the other.
About the only things you need to look out for are:

ODBC driver setup
pathnames (less of a problem if parameterized)
calls to ExecDOS (replace with ExecSH, fix commands)
calls to DSExecute() with Shell argument of "NT"

IsNull() is appropriate on the key value for the lookup (since keys must be NOT NULL) but not on non-key columns, which might return null even if their row is found. Personally I have never had a problem with the NOTFOUND link variable, but all (well, at least 99%) of my lookups are to local hashed ...

It's a design issue. You have to make sure that your logic allows the last row to be processed (yours currently doesn't, unless the trigger column changes value in the final input row). Or you need to append a dummy row to the input file. Search this forum for ideas on how to do that.

Which version of the ORABULK stage are you using? Actually it won't matter very much, all versions are very old, and not written to the DataStage plug-in API. In fact the first version was written in DataStage BASIC - may still be (I haven't checked lately). It probably is due for an overhaul; Ascen...

The JOBNO gives you a job number. The directory you need is RT_BPnn where nn is the job number.