DSXchange

If you wish to use the DIRECTOR to monitor the jobs, then you are going to have to limited the view using the View -> Filter (or Ctrl-T) menu. You can view only jobs with a certain pattern to their name or perhaps in your case you would limit the view to jobs that are currently running.

Did you go into your /staging directory and delete the files? If they are there, does the user you are calling orchadmin have owner or delete rights? Can you view the data or access the descriptor from the datastage client?

Saad, you are still doing something wrong. The "1" you are seeing is the LENgth of the string, not the SEQ value of that character, since that would be a SOH (start-of-heading). I am sorry, but this step is the easiest part of the process and should take no more than a minute to write, compile &...

saadmirza,

I cannot get the SEQ(<1-char-string>) to output a blank, so I think that something is going wrong with your output. Have you tried it with another, non-German, character such as a space and gotten the expected value of 32 back?

The data has all columns , in first row only fist column is filled , the remaining columns are empty , for other rows every thingi s perfect .Still I am facing the same issue . Can you tell us how many columns you have defined in your stage and how many commas you have in each line in the text file...

Nripendra,

as you rightly wish to do, the warnings you are getting should be removed. In order to do so you will have to tell us what the warnings are and in which stage they are occurring.

Please add a LEN(link.Firstname) to the output columns so you are 100% sure that it only contains one character.

Put in 000, just using one 0 tells it that the "0" character is the separator.

saadmirza, in order for us to figure out what is happening we need to know what the output value is -> that way we can backtrack to see the conversion or mapping that was used and, using that information, analyze what has occurred. Please check and fix your SEQ statement - it does only one character...

saadmirza, in order for us to figure out what is happening we need to know what the output value is -> that way we can backtrack to see the conversion or mapping that was used and, using that information, analyze what has occurred. Please check and fix your SEQ statement - it does only one character...

Luk, edit the code setting right at the beginning of the .DSX file and you will be able to import it.

Saad,

so what number character value is DataStage converting an umlaut character to?

Saadmirza,

add in a column to your output which is derived from SEQ(Y=<YourString[3,1]) to get the ASCII value of the o-umlaut coming into to DataStage. The square box is typical for a character that cannot be displayed in a given editor. Which method did you use to display this string?

The Hash file key must be different from what you've stated, but the general command for the hash file SELECT would read

SELECT HF BY Col1 BREAK.ON Col1 DET.SUP

The variable @LOGNAME will give you that value.