DSXchange

I'm assuming that your table has 3 columns with name col1, col2 and col3. Here is a generic query that meets your requirement... SELECT col1, col2, col3, count(*) as Count FROM tab_name GROUP BY col1, col2, col3 HAVING COUNT(*)>1 In the Database stage in your DS job, define four columns - col1, col2...

Pls post what is your Database.
Btw, you could also google for the command

Assuming that 'databases' mean 'tables' from your statement "i hav 2 databases...".
You can find the duplicate records without actually relating (e.g. join) the two tables, by firing the appropriate SQL statement against the table that has duplicate rows.

To run this (dsrecords) command on Unix prompt, you need to set the environment as following: 1> PATH=$PATH:$APT_ORCHHOME/bin:$DSHOME/bin:$DSHOME/lib 2> export PATH 3> . $DSHOME/dsenv 4> LIBPATH=$APT_ORCHHOME/lib:$LIBPATH; 5> export LIBPATH 6> $dsrecords <dataset dir/>dataset_name

Hello All I'm trying to fire the following RUNSTATS command from SQL>After in DB2 API stage: RUNSTATS on BKH.CNTAC with distribution and sampled detailed indexes all allow write access; Same command executes successfully when fired from DB2 client. But it's throwing warnings when run from DataStage:...

Ray, Thanks for the information!

Hello All,

I tried to search in the documents (PDFs) but couldn't find anything being pubilshed by IBM/Ascential about the alogrithm used for password encryption. Is anybody aware of the same? Is it mentioned in any of the documents?

Thanks!

Following derivation logic works when used in Transformer: TimestampToDate(TimestampFromSecondsSince(-(GetEnvironment('prmServerTimeZone')-GetEnvironment('prmCountryTimeZone'))*3600, CurrentTimestamp())) Forgot to mention that the given parameters have been defined as Environment variables, hence us...

Sorry if I was unable to express my requirement clearly.

Yes, I don't need to figure out the time difference. I just want capture the current date of a country with the help of it's given timezone (GMT+/-n).

Hi Craig,

I'm unable to find a way to subtract hours from Date
Suppose, if the current timestamp of server is 2007-11-14-01.09.50.384917, then the desired output should be a Date field with value 2007-11-13, for the given example.

Thanks!

Hello All I have a requirement to find out current date for a country by having it's Time zone info. Am trying to explain my requirement through the following example.. DS server has been installed in Hong Kong and I need to find out current date in India. I'm thinking to introduce two parameters (e...

Hi We have a job sequencer containing 10 jobs in row. If a job finishes successfully, its successor job kicks off and there are no other triggers defined between the jobs. Earlier, the sum of Elapsed time of individual jobs was quite near to the total elapsed time of the job sequence. Now, DS takes ...

There are 7 reference links in the lookup stage. For one link, the "Lookup Failure" condition was set to DROP while for others it was CONTINUE. When I changed DROP to CONTINUE, the job got compiled successfully. The job complained even when I tried to change DROP to REJECT! Is there any ru...

Hi I'm getting the following compilation error from a Parallel job. As per my understanding it's been caused by the lookup stage Lookup_119. I checked and couldn't find anything wrong in terms of column mapping and data type definition. Especially, there is no duplication of the field IP_ID_CUST as ...

seq_rej: When checking operator: A sequential operator cannot preserve the partitioning of the parallel data set on input port 0. I see. Got confused because the OP mentioned about the Seq file stage used as a target. I believe what you just explained is applicable to seq file stages used as source...