DSXchange

If the Field Width is, for example, 10, then supply 10 space characters.

If you created the hashed file in a directory you will need to create a pointer to it, using the SETFILE command. Search the forum for details.

NO !!! Yes, of course you can, but without understanding the ramifications of so doing, you will only make things worse. Much worse. And your support provider will justifiably tell you that you're on your own. There are many things that interact, other system tables, hidden entries and the like. I ...

What directory do you believe the Execute Command activity is executing in? What directory is the file in? Are these the same?

Always use full pathnames in commands executed from DataStage.

Is this generated or user-defined SQL? Is it a stream input link or a reference input link?
What is the order of the column names in the Columns grid?

OLE = Object Linking and Embedding. There is UniObjects for ActiveX, which the manual you appear to have read, and UniObjects for Java, which has its own manual. DataStage Objects follows the same conventions. I can not recall whether there are eleven or 13 objects; maybe the 2 derives from the fact...

Take a thorough look at WEEK.TAG. When you want "week number in year" what is your business rule that decides which is week #1 (assuming that you require every week to contain 7 days for roll-up purposes). Ultimately, though, the best solution is to build a time dimension table with daily granularity.

DS_AUDIT does not report backups, only creation, modification and deletion of objects/components.

If a previously-existing object is overwritten from an import, it has its PREVDTD and PREVDELETOR then DTC and CREATOR information updated in DS_AUDIT.

1. How the whole Database management system(UniVerse/DataStage/UniData) can be picturized through its each element. 2. Whether the definion of DataStage can be that it is Powerful tool written in UniVerse BASIC to perform all ETL operations? 1. Tell you what. You create a discourse telling how any ...

Can you get into any other project? If so check the system tables from there. SELECT * FROM UV_TABLES; SET-FILE UV UV.ACCOUNT UV.ACCOUNT SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT; Don't be concerned if the SET-FILE command informs you that UV.ACCOUNT already exists in the VOC file.

Version Control use the same connection dialog as all other clients except Administrator. You specify the host name as part of that dialog.

Use the right number of blanks.

That's not pertinent in the current thread.

What is the File property value you are using in the Sequential File stage?

Welcome aboard.

Sparse lookup is only available when the reference input to a Lookup stage is serviced by an Oracle Enterprise stage or a DB2/UDB Enterprise stage. In these cases a Sparse Lookup checkbox appears and should be checked to enable "sparse" lookup capability.

The Date and Time properties in the header of the export file will tell you when the export was initially taken. If the file has been appended to you will need to scan through it for a COMMENT that indicates the date/time of lines being appended. No information is recorded about who took the backup ...