DSXchange

Can anybody tell me how to install the NLS for parallel jobs?

If i see in my administrator, NLS, i can see NLS loaded for server maps and server locales. There is nothing under parallel maps and parallel locales. It is taking some default values as ISO-8859-1.

I have a mix of columns with character and numeric. How can i proceed then?

can u tell me the rules for CSV for numeric values?

I am taking a table from db2 database into a sequential file. In the db2 table there are two double (data type) columns. The data looks like follow: 3.87675610000000006E+01 for both the columns. When i set the format as double quote (") for sequential file, iam getting the doublequotes for all ...

i have a sequential file with final delimiter "end" and i have some junk values in it. to get rid of them i am using hex editor . after i remove those junk and when i save it.....iam getting the whole data in a single row. I no longer see the file in the format that is before editing. plea...

previoulsy i have used delimiter none, i think that is the reason data is comming in a single row. but now i changed to delimiter=end and i am getting the error Field "WFAC_PASSWORD" with 'delim=end' did not consume entire input, at offset: 227 Personnel,0: Field "WFAC_PASSWORD" ...

sorry i have the data...but iam getting the whole data into a single row. It doesnot look like the one before replacement. Is there any way to keep it like that.

I have replaced the squares with space from HEX editor, but after i save from the editor the data is missing in the file, but it is showing file size correctly. Is there anything to save the file correctly.

when i opened the file with ultraedit, iam seeing only spaces instead of those squares. I am not able to find how to see the HEX value there.

i have some thousands of such small squares in my file. Is there any way to replace all with a space in one go with HEXEDITOR?

sam.....as i have already mentioned the character is see here looks like a small square box. these is no information about these characters in your link.
i appreciate if you give me some clues regarding this.

source system? i am using a sequential file as an input in which the data is from db2

my OS is window 2003 server.

it is not working. I can understand that i have some junk values in the column. I want to get rid of them and replace the junk values with some other value. does anybody has a clue?

In the file there is a character that looks like small square, whereever i have this character iam not able to replace with values. Other than that iam able to replace with the following statement.

If DSLink3.SSN = 'NULL' OR len(DSLink3.SSN)= '' then "123-12-0000" else DSLink3.SSN