DSXchange

Please confirm that :
(a) Y:\fld1\fld2\fld3\fld4\xyz exists.
(b) Y: is the currently logged drive for DataStage processes.

It was nice of you to share that with us. How do you propose to go about satisfying your requirement?

You're doing this on a Windows-based server? Is there a top level folder called fld1 on whichever is the current drive for DataStage processes? Does the indicated sub-folder structure exist? The ExecCommand activity in a job sequence does not require the sh -c command to prefix it. However, if you d...

The fact that YOU know it doesn't help DataStage!

It could be a calculation or a lookup.

For example

What we are actually asking is for the value of your PATH environment variable, not whether C:\Windows\System32 exists. In a CMD shell execute the command

However, DataStage BASIC functions are not available in DataStage TX maps (the forum in which you posted) or in DataStage parallel jobs (your alleged job type). Please be more careful about posting in the correct forum.

The Oracle Enterprise stage uses either direct read or SQL via the Oracle client interface (OCI) to retrieve data, and either the Oracle bulk loader (sqlldr) or SQL via the OCI to send data to an Oracle table. An ODBC stage uses an ODBC driver, ODBC protocols and ODBC API calls to retrieve or put da...

It really depends on how many distinct values of the keys exist in the data. The hash table that is built in memory has one row per distinct value. If you have many distinct values (small counts) then I would recommend Group Method = Sort. 1 lakh of records is not a large quantity for the Sort stage...

If you use ETLstats to capture them, then you can see them for as many runs as you wish.

Is the change visible on all machines in your cluster/grid?

Ensure that the Windows SYSTEM32 directory is in the PATH.

Note also that Windows XP is not a supported operating system, in particular that in will not install at all on Windows XP Home.

Which characters are "weird" and why?

Only in a separate job (or routine or command) that identifies the name and passes it to the main job as a parameter value.

Are the data sorted?

Moderator: please move to QualityStage forum

The answer is "probably". Check that you have write permission to the target directory on the server.