DSXchange

What problems are you having? In particular what (exact) error messages are being thrown?

Quite simply there IS a difference and you have to find it.

Does "hai" at the beginning of your question mean that you understand?

The operating system only allows one writer at a time to a file. Given that fact, you can figure out the answer to your question.

The first thing you need to establish is whether this character is even capable of being represented in EBCDIC (which has fewer characters than ASCII). Get an EBCDIC code table and inspect it.

To find out about any environment variable in this dialog click on Variable Help button.

Prove that the "external C routine" is efficient (not the bottleneck).

How do you define "performance" in an ETL context?

Input port 1 is the (first) reference input to the Lookup stage. Go to the properties of the stage at the other end of that link, and set preserve partitioning to Clear there.

Pravenai wrote:You said SQL does not support a CASE statement.

I did not.

I said that DataStage/SQL (a particular query language, akin to UniVerse/SQL) does not support a CASE statement.

Who mentioned a Folder stage?

If this is a different problem, you must start a different thread. Otherwise future searchers will be confused.

Search - this exact question has been answered a bazillion times.

Here's an even weirder variant. This is called a "substitution conversion".

Which method did you use when you tried to import the table definition?
That is, which option did you choose after Import > Table Definition >?

No, because DataStage processes do not pick up the requesting user's .profile, so re-starting the machine won't do you any good at all. You could put them in the global profile (/etc/profile) but the preferred method is to put them into the project via the Administrator client. These are stored in a...

FileName: .\NUL
Filter Command: TYPE D:\Karthik\apl_*.txt

Can you search?

http://www.ibm.com/certify would be a good starting point.

http://www-03.ibm.com/certify/tests/ovr415.shtml
http://www-03.ibm.com/certify/tests/ovr416.shtml
http://www-03.ibm.com/certify/tests/ovr417.shtml
http://www-03.ibm.com/certify/tests/ovr418.shtml