DSXchange

Welcome aboard. On DSXchange we encourage posters to Search for solutions; typically you are not the first with any particular question. Secondly, we discourage hijacking other people's threads. You need to start a new thread (assuming that your search is unsuccessful) on how to invoke the DataStage...

You have two tasks to perform; to detect that there is a zero-byte file and to insert a row in the table. The easiest solution uses two jobs and a controller (or a command/routine to detect the zero size). The nice thing about the controller is that you can choose to do something else if the file si...

But you can put quotes around the column name, either in the Derivation column of the Columns grid or in user-defined SQL.

But it won't

srai wrote:capture the reference data which is not matching with the master data set

There is no way to do what you seek to do in Director.

Nothing is different. The job will process zero rows.

That's regular ODBC rules/restrictions. It's possible you can enclose the column name in double quotes.

Changing the table definition in DataStage will not help you to read the data.

Is the Folder stage in a server shared container?

There is no such thing as a Folder stage in parallel jobs.

Why not Search DSXchange for other approaches? There are some to be found.

Thai characters can be read satisfactorily if the correct NLS maps are set consistently across all software layers.

At the moment I am working at a non-NLS site, so can't recall what these are - from memory it's TIS620 in DataStage server and code page 874 in Windows environments.

ODBC driver for Excel requires that the worksheet has column headings and reports these as the "column names" of the "table" represented by the worksheet. So you don't have to worry about skipping column headings - it happens automatically. You can rename any table definition in ...

Are you in the same team as mandyli or have you just hijacked this thread with an unrelated question?

Has it stopped running (can you see it in the process list)? Maybe it was killed, and did not get the chance to update its log file. Maybe it really is running. The dsdlockd process runs as dsdlockd, so filtering on dsapi won't find it. You will need to filter on dsdlockd or some subset thereof. Do ...

No.

DataStage administrator role is defined in Web Console for Information Server (in version 8 and later). It is unrelated to UNIX groups. UNIX groups govern who can do what to UNIX file system objects.

Server routines can be called from server jobs, from sequences, from BASIC Transformer stages in parallel jobs and from server Transformer stages in server shared containers in parallel jobs.

Parallel routines can only be called from Transformer or certain custom stage types in parallel jobs.

There is no such thing as maximum scratch space - you can add file systems to your configuration file as much as you like. If you can justify having more disk, then more disk must be obtained. Somewhere, whether in the source database or in ETL processing, this work simply has to be done.