DSXchange

You don't need a 'custom function' to use CRC32. And no, CDC is not part of the Server product, so you'll need to do CDD - which is where the CRC32 routine comes in. Search for it and you'll find plenty of discussions on the subject. On the 'how do I do it' front - put some thought into it. What are...

Yes, but the question is - will it fire if the job processes zero rows? I don't believe so.

However, the answer is a definitely 'yes' if you make it an after job routine.

Welcome aboard! :D Is it possible to access Oracle 10g database through DynamicRDBMS stage? Yes, certainly. If yes, is there any constraints compared to Oracle stage? Hmm... not sure there are any constraints, per se, but then I don't see any advantages. The reason the DRS stage was 'invented', AFAI...

You sure this is a function ? Oracle stored functions are not called, they are selected just like any other field. First suggestion would be to forget about the function and encapsulate the function's logic into a DataStage job and then run that. Otherwise, you'll need an OCI stage to run a query ag...

Is this a question, reply, some kind of graffiti or... oh, I see - a spirit guide for the OP, returned to let us know all is well almost 11 months later.

Someone needs to learn how to quote more better. That or just use the Reply to Topic button.

Hex 20 is a space, btw. So this works on the original file? Any issues with the 'missing' column or is all good there as well?

I tried to read with delimiter 009 and quote character ". The result was that entire input record moved into a single output column.. It also says invalid quotes. Is this a problem with Metadata? or soemthing else. Metadata - meaning the settings you've used in the stage do not match what it finds ...

I tried removing Quotes for the fields. I removed them. But when I am trying to read the file, the entire record is coming in the firsr field only. Now the i/p record is : asia 211 FY2001 890.00 987.0 78.90 Delimiter: 009 Quote: 000 In Output, the entire record is fitted into the first column only....

Yes Craig. It is compaining for each and every record. i deleted few records and tested it, but it was of no use . For the unequal number of columns, I am handling it by using "REPLACE" option in Incomplete Column field. Only few fields in each record has quote character. The amount fields are not ...

Does it complain about every record or only some of the records? All it takes is one stray character in one record to give you that message. The error should also have told you which field had the problem. Setting the quote character to " doesn't mean every field needs to be surrounded by those part...

Thanks a lot. Where can we get that code information from. Any ASCII chart, there are tons of sites on the web - take your pick. Note that you'll see the TAB character referred to as HT or Horizontal Tab on some sites, same thing. I am facing with one more issue. My data is having some other fields...

The TAB character is '009' and that's how you represent it in the stage.

No... and don't confuse the Merge stage in the Server product with the stage of the same name in the PX product. The Merge being discussed here is the Server Merge stage.

Same way you'd do it in any other version. First step would be to document the logical steps involved, then implement them in a job. It doesn't take anything fancy, just 'normal' DataStage techniques... and not really all that hard to work out. You might want to explain what this is supposed to mean...

Am I on the right track here? Yup. One job to fetch the value and stash it somewhere. Simplest place seems to be in the USERSTATUS area each job has. Then a Sequence can auto-fetch that value into a Parameter in a downstream job: JobActivityStageName.$UserStatus You will need a simple custom routin...