DSXchange

Hi Pxlearn, i have also faced a similar problem.At last I found that the problem is not with the Datastage. Changing the NLS map won't solve your problem. Tell me which server OS you are using. You check these things at your end. 1.while loading from Seq File to OCI Stage You should able to see all ...

Hi Friends,

I have Given Computer Name in host place and for username and password, i have given os username and password.

Now it was working fine without any LAN connection.

Thank You for your valuable suggestions.

Hi All, I have installed Data Stage in laptop which is not connected to lan and not having internet connection. Both Server and Client are installed on windows Xp OS. when logging into Administrator it is giving error not able to connect to local host. While Logging in i am using computer name as ho...

Hi,

Than You fro your response.Can You Please Expalin to Me in Breif how to use Aggregator Stage.

Hi All, while loading data from input file to ODBC i want to select rows basing on distinct values from a column. In oracle data base if we want to select the records from a data base we will use "SELECT DISTINCT COLUMN_NAME FROM TABLE_NAME". how can i apply this logic while loading data f...

Hi ray.wurlod, i have changed oracle nls_lang setting on the client side, now i want to change the solaris settings. could you please tell me what settings i have to do, since i don't know unix much. hai please assist me in this . waiting for your reply. i am using oci driver in data stage for conne...

hi Friends, we have solved the polish character problem in data stage to a maximum extent. now we are facing problem only whlie reading data from either odbc driver or oci driver. is there any nls setings i have to set at server end so that the data will be read by drivers properly. we are using Sol...

Hi ray.wurlod Thank You for your advice. i ahve tried what you said. what i have tried writing from sequential file to sequential file The data is coming neatly. writing from odbc to sequential file the data is written with some special symbols in the output file. i hope the problem is coming when i...

Hi All, Here i am giving a Some Sample Polish Words Please try this at your end let me know if it is working correctly. The Words are "Pielęgniarka", "Proszę ", "Jak się masz", "Tęsknię za Tobą ", "Nie mogę bez Ciebie żyć ", "Wesołych Świąt Wiel...

In the Columns grid on the link(s) where this column appears, what are the SQL Data Type and Precision settings? ... Hi, In the Column Grid on link the sql data type was varchar and the length was 1500. Other than this i have not given anything extra. Please let me know if any extra information is ...

Hi Guys, Here i am giving a little bit clarification to what i have tried. The input file: Unicode format(utf8) while opening the file r u able to see the special charecters "Yes" How did you convert the file from utf8 to ascii "By Data Stage one to one mapping " when you convert...

Hi chulett, Let me explain my problem clearly to you. In the oracle data base the column was declared as"VARCHAR2(1500 CHAR)," I am using ODBC Stage for connecting to the oracle data base. while importing definations for that column i have given it as varchar(1500). While executing the ser...

Hi All, i am having some problem with the column while loading data into data base using data stage.The column length on oracle data base was varchar(1500 char) and it cannot be changed. but in data stage varchar of length greater than 500 is not supported. while running the server job i am getting ...

Hi ashwin,

i have tried with what you said,but it is not working in my case.

Hi anyone please help me find a way out of this problem.

Waiting for your responses.

Hi Friends, I am facing a real problem While loading polish data using Data Stage . i am using Server jobs and teh server is unix OS. The oracle data base is using AL32UTF8 settings. Coming to Data stage i am using Server locale as pl_polish but there was no server maps available to support the pols...