DSXchange

You have to do at least three things to select components for export to your Reporting Assistant database (doc_tool.mdb if you haven't altered the default). On the Options tab, make sure the ODBC data source name is set correctly (for the default it should be DSReporting ). On the Selection tab, mak...

About the only choice you have is to get Oracle to "decompress" them back into XML or text message strings (I take it there's a function there for doing that - if not, get one created). DataStage can't really process binary data, except in passive stages such as the complex flat file stage. (How wou...

Check the quote character in your Format tab on the Sequential File stage. If this is set, and missing from the data, then unquoted strings are treated as numeric. (These are the CSV "rules", if you like.) Change the quote character to 000 and try it again. Also, make sure that the data type is set ...

Basically there are two choices. One is to use user-defined SQL, with the appropriate constant for the current date (SYSDATE, CURRENT_DATE and so on - it's different in each database - so much for standards!). The other is to use DataStage system variables or functions. The @DATE and @TIME system va...

You can research here and discover that job parameter values are set when the job starts, and can not be changed subsequently. Therefore you need to capture your initial value in a predecessor job, pick up that value in the job controller (which might be a job sequence), and set the parameter value ...

The product has a command for creating the VOC pointer. It's called SETFILE and has been discussed here before. SETFILE pathname VOCname [ OVERWRITING ] If that's too difficult, just enter SETFILE alone; it will prompt for the information it requires! (Naturally you need to be in an interactive envi...

If it's not installed, you install the Pivot stage (or any other optional ("plug-in") stage using the Package Installer, which is on the server. You will need your DataStage CD; the software is in a directory called Packages. There may also be a client component, which you install on your client mac...

I believe it's not possible to install a plug-in to the Template, which initially appears to be a regular project until you determine that it lacks a VOC (which would be vital for any install process). Reinstalling the server with re-selected options will cause the plug-in stage to be directly insta...

Get to TCL and type HELP . This will bring up a list of commands and other topics which, if your terminal type is set properly, you can navigate with arrow keys. Press Esc to get out of the list. Press Enter to invoke the currently selected help topic. Read UniVerse manuals, including: UniVerse User...

Depends where you work.
Saturday is a work day in India, for example.
Every day is a work day for self-employed folks, if there's reward.

1. Change your configuration so that the EXACTNUMERIC parameter is rather more than 20. It can be as high as 57. 2. Use the Compare function. Look for it in on-line help or in the BASIC manual or in TCL-level help ( HELP BASIC COMPARE ). 3. Use subtraction and check for a zero result. 4. Use string-...

Not certain, but I believe so for current version. There is a list of platforms somewhere in the UniVerse manuals for which 64-bit files are supported; I guess you could compare this to the list of supported platforms for DataStage. Some of the older versions of DataStage and operating systems may n...

Whatever you like, depending on design. The dummy line on the end of the input file. The last line of the output file (tail -1 outputfile). The Aggregator stage featuring a "Last" aggregate function. (Over)Write to hashed file with constant key value. Replace row in table. @OUTROWNUM = previously-kn...

We are not running on HAL 9000's here, where the software can guess your intent and rewrite the model and ETL code so that inspite of the architect the best solution is arrived at.

Why not?!!!

Did you import the table definitions through an ODBC stage, an OCI stage, a metabroker, or some other method? All yield slightly different results.