DSXchange

<soapenv:Envelope xmlns:soapenv= "http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="urn:xxx/xx/ecbs/object/" xmlns:quer="urn:xxx/xx/ecbs/object/Query"> <soapenv:Header/> <soapenv:Body> <ns:operation_Input> <quer:ListOfContact pagesize="100" startrownum=&quo...

I did search the topic but I couldn't solve the issue. I did check my env from command prompt and I didn't see my dsenv or dshome there. How do I see dsenv,dshome on windows?
Please advice

ASBHome=D:\IBM\InformationServer\ASBServer ASBNode=D:\IBM\InformationServer\ASBNode PATH=$ASBHOME/jre/bin/sovvm ;$ASBNode/apps/jre/bin; DSHOME=D:\IBM\InformationServer\Server\DSEngine DATASTAGE_JRE=$ASBNode/apps/jre These varaiables I defined in the DSADMIN. I am using the webservices stage for the ...

I am extracting data using webservices client stage.The job aborts with "Unable to create Java virtual machine". I added environment variables in DSADMIN as DATASTAGE_JRE=$ASBNode/apps/jre DSHOME=C:\IBM\InformationServer\Server\DSEngine LIBPATH=$ASBHOME/jre/bin/sovvm;$ASBNode/apps/jre/bin ...

I mean to say that we have 70GB of space in D:/ .70GB of space includes all parent and child folders. Do we need to have space in the "Dataset" folder?. Please advice.

I am having a lookup problem in my job. The reference lookup file contains about 30,000 records.This jobs works fine for few thousands.When the file size is increased the job is getting aborted.I tried to put the data from file to a table and did sparse looup.That didn't work too. This is the error ...

When I specify the column datatype as Date.I am getting the following error.I cannot read the file
Data string '02/07/2010' does not match format '%yyyy-%mm-%dd': the value for tag %yyyy has fewer characters than expected.

I have Invalid dates in my Input file such as 00/00/0000 02/29/2009(Invalid date,not a leap year) I am using the below logic to convert the date DateToString(StringToDate(Inputcolum,'%mm/%dd/%yyyy'),'%yyyy%mm%dd') This logic works fine for Valid dates.where ever there are invalid dates the output is...

Hi The data looks in a file looks like this Acct_No Site 111 1000 111 1100 111 1200 111 1300 222 1100 222 1300 333 1300 444 1000 444 1300 555 1000 555 1100 I have to check if Acct_No exists in all the 4 sites 1000,1100,1200,1300 . ex 111 is there in all Sites so I dont want this record in my out put...

Thank you for the explanation.

yes I have multiple records.The datastage Directors log shows 2664 records are update but when I run a query I get only 2605. The same thing happens on the SQL server manager studio too if I run an update query it shows 2664 records updated when I run a query I get 2605 records.

My requirement is to insert 3306 records from a FILE A in to table A and update these records in Table A from another FILE B which has 2642 on key match. These two files have 2642 common records.I am inserting 3306 records in to SQL server Table A. Later I am updating Table A with 2642 records.When ...

I kept the data in a file and used a lookup stage .

I am having 5 columns in all these files.In one of the file 2 columsn have no value.so I set the NULL FEILD VALUE for these columns as '' .And I am able to read these files.

Thanks for responding.

I am using Sequential file stage .This is a parallel job.