DSXchange

Hi All, I am getting following error message in join stage of parallel job Operator of type "APT_TSortOperator": will partition despite the preserve-partitioning flag on the data set on input port 0. In join stage we are using the same partition, Before join stage aggregator we have used H...

Hi Kamal,
The below code is working fine, it gives the correct output "2011/07/13" .

Hi, Iam getting daily many files in unix (source directory). My requirement is to get the file received timestamp from unix and need to load in one of the db2 (target) table at column RCVD_TS. Currently we are handling the basic- routine but going forward we wont use server jobs and basic routines....

Hi,
you can use Aggregator stage. In Aggregator group by on field1 and find max(Amount).

Hi agpt,
My code is :
If count(loc,"-") > 0
Then
loc [3]
Else
loc.

Thanks Arun, " If Count(Column,'-') > 0 Then Column[3] Else Column" is also working fine.

i used dcount and field functions. Its working fine :D

Hi,
i have following requirement.
If the value contains "-" then use the last three characters of the string else use the whole string.

ex: 1) customer-usa output is usa ( corrected the delimiter)
2) india output is india.
Any one can help me to resolve for the same.

i applied the logic, but its giving wrong result.
Thanks for your response.

Hi,
i have following requirement.
If the value contains "-" then use the last three characters of the string else use the whole string.

ex: 1) customer_usa output is usa
2) india output is india.
Any one can help me to resolve for the same.

Hi, Use the follwing command in Unix to remove control (^M) characters in Source file. sed 's/'`echo "\015"`'//g' filename. To remove the warning "Missing record delimiter "\n", saw EOF instead" go to end of the last line of the source file give one Enter .It will remov...

Hi,
Check this command in Unix sed 's/'`echo "\015"`'//g' filename for removing control characters in your file.

Hi,
its not necessary that we have to select the key column in the ouput tab of a hashed file which was defined in the input tab? But It's necessary to have any key column .

Hi,
its not necessary that we have to select the key column in the ouput tab of a hashed file which was defined in the input tab? But It's necessary to have any key column .

Hi Suresh,
I'm sure that 7.5x2 will be supported in Windows XP.