DSXchange

Hi all, I developed a job that extract the data from source and loads into target without any transformation logic.But i used RCP in my job.After successful completion,I got the following warning message "Writing the WVARCHAR column into a VARCHAR database column can cause data loss or corrupti...

Hi all, I am using Datastage 8.7,platform -windows I am loading data from dataset to netezza using netezza enterprise stage(nz load), Data gets inserted but the job aborts due to following error: Error: Error occured while opening data file Error: Load Failed, records not inserted. I have browsed to...

That will work but my concern is to get it done through table creation such that there will no modification required in all the jobs.

so u mean to say that we will not be able to do through table creation scripts

This issue persists with respect to environment and persists across all the jobs in different environment, I tested in local environment it works fine. But in client environment it throws the above warning Locally i faced this issue but was solved by appending utf 8 to create table, but the same doe...

Hi all, I created job that extracts the data from DB2 and loads into Mysql using IBM Data Direct Driver.After successfully completion ,i got the following error message "Writing the WVARCHAR column ... into a VARCHAR database column can cause data loss or corruption due to character set convers...

Hi all, I have job that extracts data from DB2 and loads into MySQL using IBM Data Direct ODBC Driver.After successful completion of the job,I got the following error message: "Writing the WVARCHAR column into a VARCHAR database column can cause data loss or corruption due to character set conv...

found a work around - if i use ODBC stage instead of ODBC connector, it works fine

sorry for the delay after using -x option in ( "orchadmin -rm [-x]") command i got the following error : ##I IIS-DSEE-TFCN-00006 10:23:24(001) <main_program> conductor uname: -s=Linux; -r=2.6.32-220.el6.x86_64; -v=#1 SMP Wed Nov 9 08:03:13 EST 2011; -n=athos.lucidtechsol.com; -m=x86_64 ##I...

Very true.., can i get an approach to solve the above problem!

Yes i am aware of that but i am not able to delete all the dataset files from the folder in windows environment so took an approach with respect to server routine.

Can u just brief what u mean by command (execute)..

Yes,I am calling a server routine to delete dataset (orchadmin -rm ...)

Ran the job Changing the length and NLS and also used cast function but same result..

I am getting only the first character in the output.

Please find the content of the Configuration file below: { node "node1" { fastname "athos.techsol.com" pools "" resource disk "/opt/IBM/InformationServer/Server/Datasets" {pools ""} resource scratchdisk "/opt/IBM/InformationServer/Server/Scratch...

Hello all I am using datastage v- 8.7 ,Linux environment In a sequence job i am using a server routine to delete dataset, while using it in the sequence job,job aborts due to the below fatal error: "The configuration does not contain the invoking node fastname" I am sure that the code is f...