DSXchange

As noted, I sincerely doubt the patch will help with that but you should apply it regardless. I never pick job or routine names from inside an Activity stage any more. Not once I found out all you had to do was click and drag the job or routine onto the Sequence canvas from the Repository window and...

Ooo... a free post.

Please mark this topic as Resolved! Thanks.

Don't recall ever seeing the last reply in that thread. For what it's worth, never had any sql that specifically referenced ROWID and we haven't seen the error again since upgrading to 7.5.1A. Coincidence? [shrug]

Perhaps as a workaround you could pass it out with some other delimiting character? Then replace them with '\' before actual use.

You've already got it in the folder stage, yes? Just pass it through all the way to the Sequential stage. Anything in an XML stage without an XPath expression in the Description column is such a 'pass through' value and will be propogated out the other side. The only other issue might be if the Fold...

You don't want to introduce a LONG datatype into the equation if you can help it, besides it's usually no trivial matter to get a table definition changed. And dropping the size of the constraint shouldn't help as Oracle will happily take 4000 into a VARCHAR2 field unless we're talking about a 7.x v...

You certainly didn't wait very long before you decided no-one was going to reply. And you don't need to invoke me by name, anyone can answer questions here. I just meant a normal regular filesystem / disk backup, like you would do to tape or some other removable media on a Windows system. This would...

What kind of 'processing' did you have in mind? Not sure how much information you can get from a BLOB* but you could probably load it like any other LOB. DataStage really isn't the tool for that, however.

* Other than what planet it came from, of course, and why it was here.

praneeth wrote:The dataType for the field is Varchar in Job and TargetDatabase

Can't be or you wouldn't be seeing that Oracle error. Double-check, please. Or perhaps... what size have you declared the Varchar in DataStage?

Datatype of the field in your job? Datatype of the target field in the database?

If your datatype in the job is LongVarchar, make it Varchar and see if that helps.

ps. What's the name of the source stage? QWERT?

Come on... you are expecting help from us, no matter the tool you are having issues with? Puh-leese. Seek help from the people you work with when you have questions like that.

Bah... you want one of these.

They already have a working prototype of the interface seen in the movie Minority Report. Actually, most of the author's (Phillip K. Dick) works involve future technology and made interesting movies: A Scanner Darkly Paycheck Minority Report Imposter Total Recall Blade Runner Cool stuffs... :D ps. I...

Exactly... neither question was answered.

Have we established what exactly this 'CDC process' is? We're in the Server Forum in a Server post where there is no CDC stage to be discussing. So... Are we talking CDC stage in a PX job? CDC directly built into the database? Third party log farming tool? Triggers? Or is it really CDD in the ETL to...