DSXchange

Have you imported the table definition for this source? I guess you must have. What are the defined data types for these columns.

In your design make CITY a VarChar with Unicode extended property enabled.

Are you really connecting the the source you THINK you're connecting to?

Sequential File stage actually uses STREAMS I/O, so should not be much of a bottleneck in the export operator. As noted, the problem may be in your disk system itself.

Server jobs have a Folder stage that does this. You could use one of those in a server Shared Container in a parallel job, or maybe do all of your processing in a server job.

The fact that you can use View Data to see data in the hashed file but no rows are returned on the reference link (output from the Hashed File stage) can suggest only one thing - none of the key values is being found in the hashed file. Check your reference key definition thoroughly.

Further, you posted your question in a DataStage forum.

This looks like a simple variant of vertical pivot, which you can achieve with the PXPivot stage.

Can you show us what your data DO look like?

Hmm... Ctrl+Z is Char(26), or code point 0x1A. This is the DOS end-of-file character. Might the problem be related to ASCII transfer of text files from Windows to Unix at some point in their history? Or copy/paste from a Windows application into a DB2 application? (Just clutching at another straw he...

phanikumar wrote:...it should prompt me with ten different values during run time.

DataStage jobs run as background processes - they do not prompt "during run time". Parameter values are resolved/supplied when a job run request is submitted.

And the user has to have sufficient privilege in the database to create and drop tables.

Ordinarily databases allow all privileges on owned tables - and I believe that this is the case with MySQL.

This kind of information is available by taking the Advanced DataStage class.

IA has many out-of-the-box reports. One of the Column Analysis reports will probably achieve what you want. And reports can be output in a number of formats.

Ten parameters.