DSXchange

HAs anyone else done regulerexpression repleacement in DS PX? Please let me know.

Well the reguler expressions need to be replaced by '-' would be like below.

\bDAMN\s?|FART|----(ED|ER|ING|ME|S)\b
\b(HELL|HORNY|J(AC|ER)K-OFF|JI(SM|Z(M)?))\b
\b(MOTHA|MOTHER)?----(ER(S)?|IN(G)?)?\b

I am not familair with ereplace,going to try now.

We have a requirement to strip some bad words from the input - replace the bad words with a '-'. for bad words, we have a list of reguler expressions - We need to substitute these reguler expressions with a '-'. Currently I have implemented a demo of it using external filterstage. But I was looking ...

We have job where the output of a stored proc is getting truncated. The column in question contains an XML document of length - 1073741823 characters. We have used longvarchar as the data type for this column and have not provided any length for it. Please let me know if there is some way we can ext...

This character exists in the target chracter set.
this was one of the first things I tested, by manually inserting the record in the DB through a query.

Thanks Chulett.
Is there some way we can ensure that all such > 80H characters get loaded properly in oracle. (through ODBC would be preferable)

Thanks for pitcing in with your experience. hink getting the session killed is the best way to deal with this.

We have a job updating an Oracle DB Table, through ODBC Stage. Whenever this job is stopped (Manually through Director), the target table gets locked. What can be done to ensure that when the job is aborted, the table does not get locked. -- i.e. lock is released when the DS job aborts. Thanks in ad...

With the new architecture in place, Metedata Repository has to be set up, which also needs DB (DB2/Oracle/SQL Server). Plan for these components also.

Thanks Ray, I just verified after removing the MS_IDENT. The job is still hanging after 30% processing. I even ran it on a single node configuration table, but the job still hangs. But when I load this data to an empty table, it loads well and then a server job is able to append to the existing larg...

Missed a detail.

We are using ODBC Stage for the target table.

Hi All, We have PX job which loads data into a SQL Server2000 DB. We have an identity column defined in the table, but we have set identity insert as off, because some other processes will also load into the table. When this job tries to load into empty table, load is successful. But on attempting l...

yes the blog is very informative.

IBM DS Release notes are also good.

Hi, We are evaluating DS8.0 with QS 8.0 Got some queries 1. Will QS 8.0 come already integrated in DS 8.0 ( 6 QS Stages - I read somewhere). 2. IS QS better integrated wit DS 8.0 that DS 7.5? Detials of integration. 3. Would it be better to have the the DS and QS servers setup on the same box. 4. If...

Done