DSXchange

We included NLS_LANG as User Defined Environment variable and included the same in our jobs. The above resolution works fine is I am extraction data from different databases (say Oracle for example) having different character sets and dumping the same into a dataset or flat file. Then read this data...

The issue was solved thanks for your timely help.

Thanks for your prompt reply... Would appreciate if you can help us in the below issue. Please let us know if more information is required. Issue: The problem is we are working on different database systems with different NLS setting done at the database level. Say for example, one of the source dat...

Hi All, The datastage is installed in hp itanium server.we are getting sources from different source systems, each one having different NLS setting for each source database. We have arabic data that needs to be loaded to our DWH system,so we need to change the NLS setting at runtime.Please let us kn...

Dear Chulett,

For Testing , we got the Dsx from the Production and import in to the Testing server, For all the OCI stage in the project, i am getting this error.

Thanks,
Sundar

Dear All, My job design Look like this Odbc-----------------Xfm-----------------Oracle (Sql Server) when i tried to view data from oracle oci stage i am getting the following error pin 1 not initialized DSLink1:DSP.Close Error - 100 in $DSP.Close Please help me in resolving this. Thanks & Regard...

Hi all, My source database is oracle and the column key_1 datatype is number(10), I am able to view the records in the source. In Datastage it is decimal 38,10 when i run the job,i am getting the following warning SrcTltr: Column KEY_1 floating point decimal is not fully supported; adjusting the sca...

Hi Ray,

Thank you for Replying.

SrcMCustomerMasterFileView,0: Invalid character conversion found converting to ISO-8859-1, substituting

Above is the entire warning message, from the Director.

Please help.

Thanks
Sundar

Hi , I am getting the following Warning for each record when i am running the job. SrcMCustomerMasterFileView,0: Invalid character conversion found converting to ISO-8859-1, substituting I had imported the Table definition from sql server through ODBC with the NLS ISO-8859-1 Please help me in solvin...

Hi , I am not able to open the job activity properties in the job sequence. when i right click on the job activity stage, it is not displaying the properties,instead the Link and the becomes black. My client is installed in windows XP professional please help me to solve this. Thanks Sundar

Hi, A sequence is stopped/aborted while running it under master sequence although that individual sequence is running fine if we run it separately. The logs against the problem is as follows: Project:NCBBASEL2v1 (hpw2k3etl01) Job name:Basel_Master_sequence Event #:634 Timestamp:8/12/2007 10:13:15 PM...

Hi

Thanks to Everyone.

Datatype for the Column MESSAGE in database is TEXT.

In Datastage i typed varchar 2000 for this column,but it is throwing the same error.

ERROR CALLING SUBROUTINE:DSD.Browse (Action = 3): check

Datastage is setup correctly in project

Thanks
Sundar

Hi, My Database is SQL Server. I am able to import table definition from the database. when i try to view data from the ODBC stage, i am getting the error CHECK DATASTAGE IS SETUP CORRECTLY. when I delete this column MESSAGE LONGVARCHAR of length 2147483647 from column definition, i am able to view ...

ArndW wrote:poonamgoyal, you have just posted to a thread last updated in May 2005.

Are you having the same problem?

No, this is different one and is explained in her previous post, we are having the issue, please help to resolve the problem

Hi I am getting the following error when i try to run the job. In our Job, we are trying to load data from sequential file to DB2(On Solaris 64 Bit) using DB2UDB enterprise (our datastage server is on AIX machine and we are using client on windows) main_program: Error loading "orchdb2op": ...