DSXchange

Hi all, In this case,we have hunders of jobs.And every day each job will create hunders of instances.So we must clear instance every two days.Or it is very slow to open datastage director. We can't clear instance by compiling job because dataStage server does not have job designs. Can I clear hunder...

Hi , I have two jobs. My first job output is a DATE. I want to pass this date as a parameter to my second job to a oracle stage . In the second job oracle stage i have a user defined query "select * from the XYZtable where the date ='#date_Param#'". I tried various options 1.Iam working i...

firstly,make sure rsh service has been started.
secondly,add .rhosts file into dsadm home directory on each machine, and add user dsadm in .rhosts file.
thirdly, test rsh whether connected or not.

Job succeeded when executing at local job,but failed at remote server.I change data type to Numeric at remote server.Error persisted.
At remote server all other data type are ok except decimal.I'm very puzzled.

Hi All, I have this new error for all my jobs which contain DB2 API Stage: Job 1 main_program: Fatal Error: Not a v1.1 type: decimal[12,2]. Job 2 main_program: Fatal Error: Not a v1.1 type: decimal[20,0]. Job3 main_program: Fatal Error: Not a v1.1 type: decimal[14,2]. I create a Job which reads data...

Hello ArndW,
User-defined SQL as follows, it is very easy:
DELETE FROM testtb WHERE (Col1='aaaaaaaaaa')

Hello guys,
While Deleting Data by DB2 EE Stage,Error as follows:
DB2_UDB_Enterprise_1: Unable to convert the adapter spec ostrstream object with a value of `' to ustring.
DB2 is remote DB.It's normal while insert,update,select.If any one ever resovled similar problem, please help me.

Thanks

I also can't use DB2 Load Stage with same error in Parallel Job.But I can use it in server job.I think it is may be a bug.

Hi roy,
Thank you for your help.I have resolved problem.I download a new client 2.9-32bit.And successfully connect to informix.

Hi all, It's my first time to connect Informix Server.OS:AIX 5.2 Informix:9.3 Datastage EE:7.5 I added environment variables in $DSHOME/dsenv as follows: INFORMIXDIR=/home/inf930FC5; export INFORMIXDIR PATH=$PATH:$INFORMIXDIR/bin; export PATH INFORMIXSERVER=udi_etl_kf_tcp; export INFORMIXSERVER ONCO...

I create a new project and the error disapeared.So strange!Thanks for your help!

Hi all, Job always aborted when it contain Transformer Stage.Log as follows, Transformer_2: Failed to load the library "V0S2_testtran_Transformer_2.o". Either the directory containing the library file is not on the library search path, or the library was compiled on a system that is incomp...

Thank you

Hi All,
When running a job in command line,it will return a status code.Who can tell me the mean of each status code? Thanks

Yes , Target data always has same columns.