DSXchange

How "bad" would it be to put a BASIC transform stage in your parallel job or do this particular job as a server one? The function "OCONV(In.BinaryCCNumber,'MX0C')" does this for you, but doesn't exist in PX jobs.

As Ray has already stated, are you sure that your selected character sets are correct? Is the arabic data in your source perhaps already stored correctly and by trying to convert from Russian to Arabic you are actually corrrupting the data?

And what value was that character (again in HEX) in the source?

0x20 3F isUndertie in Unicode.

kpsita - welcome to DSXChange. "Urgent" problems should be directed to your support provider. This is an all-volunteer site and usually posts titled "Urgent" or "Immediate help required" or similar are ignored for a while before being responded to. The condition "I...

The function Index(In.HIST_ID HISTORY ,"H",1) will return a 0 if there is no "H" in the string or the starting position if it exists. No errors are returned.

Set your NLS_LANG to "AMERICAN_AMERICA.WE8ISO8859P1"

With "ls -f" you get a long string returned, each file name separated by commas. The BASIC function 'DCOUNT(string,",")' gives you the total number of fields in the string, then you iterate through the numbers and do 'FIELD(string,",",iteration) to extract the appropria...

Identify which UNIX process is running the sequence and, while it is "hanging" use the UNIX "truss" command to see what, if anything, it might be doing. This generates a lot of output, but important is to see if it is actually doing stuff (like seeks) or waiting (sleep).

Don't redirect your errors to /dev/null, redirect them to a file and see if any messages are in that file after the run.

Best use a tool which shows you the hex values for each character. "?" could be either a real question mark or it could mean an undisplayable character (using the session's NLS settings). What is the HEX or Decimal value of the first '?' character in the string?

userasif wrote:...If I use NONE for NLS Mapping for source stage then job finished is OK but data is not in Arabic form...

Just to be certain, how do you determine that the output isn't correct? Do not use the "view data" functionality to do this.

Debug your job and find exactly 1 value which is being used for a lookup and manually check wether this key exists in the hashed file. Remember, this is case sensitive and space sensitive (i.e. "Hi there" is not identical to "Hi there ").

I should be more explicit, since this is part of the crux of the matter. Can you do a "view data" in the Designer on the DB2 source stage and see sample data? If yes, then the problem lies on your output stage, writing to SQL server. If you replace your ODBC output stage with a dummy seqeu...

I cannot think of such a scenario. The .xml format was most likely implemented so that DataStage could boast being "open" and that it uses a common interchangeable format.

...Connect failed: ORA-12541: TNS:no listener This means that the SID name used is not correctly specified in your tnsnames.ora file. Before trying to test with datastage, use the UNIX sqlplus command to connect to the Oracle database, once that works you should not have problems within DataStage.