DSXchange

In a word, Pivot

Find the help topic "MC conversion".

If the import fails you can not expect View Data to work. Your first piece of detective work is to identify why there is a problem with ODBC stage in the project. The easiest way to do this is to create a job that uses an ODBC stage; does this work OK? If so, the stage type in the project is probabl...

What's wrong with Print To File from Director's Project menu?

Yes, if you have a licensed ODBC driver for Excel that runs on UNIX, and your Excel workbook is in clean tabular format with column headings. You can then use the BCI functions. Search the forum for information on these.

Is it really necessary to collect the rows together before inserting into DB2 table? Why not have three parallel streams loading DB2? If the keys are unique (which they will be if you've partitioned on the key column) there will be no contention for locks.

Alpha(Left(InLink.TheString,1)) will return 1 if the first character is alphabetic, or 0 otherwise. Num(Left(InLink.TheString,1)) will return 1 if the first character is numeric or 0 otherwise. You can combine the logic with the Boolean operator Or to get the test expression you seek. Alpha(Left...

If you're doing this in DataStage surely the form you require is Select * from EMP where EMP_ID = :1 However, this does not traverse a hierarchy; it merely performs a lookup based on the current value for EMP_ID as supplied from the job's stream of data or some expression based on that. DataStage it...

Theoretically all DataStage versions (to 7.5.1 at least) are backwards-compatible to version 1.0. Therefore I would make sure of a good backup of the 3.0 projects and of a good export of each 3.0 projects, and try a direct upgrade. If it fails, the backups will allow resumption of normal service (un...

Reindex merely rebuilds the database indexes on your Repository database.

I take it you have multiple -param ParamName=Value options on your script command line also. That's the only way the correct syntax would be picked up through $*.

But, yes, you must solve the cd problem first.

All DataStage manuals are installed with your DataStage client software in a sub-folder called Docs. By default C:\Ascential\DataStage\Docs. You can also get there (which is what Craig was suggesting) from the Start menu on your client machine. Start > All Programs > Ascential DataStage > Online Man...

Depends whose book you read. It's arguable (and I would) that there's only one type, and that's a dimension table; a table with a surrogate key which is a foreign key to one or more fact tables in which the measures of the business are stored. That answers the question in the body of your post, but ...

COMMON remains active while you're connected. Hence the error about changing its size. You need to disconnect your DataStage client and establish a new connection for the changed COMMON to be legal.

If you're on Windows XP, then you don't need dsenv. It's only for UNIX. If in a cmd shell you set your PATH to include the DataStage Engine's bin folder, you can execute dsjob directly. Otherwise you will need to specify its entire pathname, for example C:\Ascential\DataStage\Engine\bin\dsjob Entere...