DSXchange

ray, thank you for your response. Can you explain this part of your statement little bit more?

"That is why the option exists to create a Custom stage type - to specify an operator as a DataStage stage"

No meena, this is not a interview question. I have a good job and I am pretty happy about it. I am playing around with the Generic stage after I saw a post on this forum. I am trying to see what its unique capabilities are. My job has the stages I have described. However, 10 records are always being...

I have a sequential file stage, generic stage and data set stage. In the generic stage, I have:

Operator = tail -nrecs 5

However, always 10 records get copied to the data set. The source sequential file has lot more records. Any ideas?

Is there one? I would think that they are the same. Also, why would someone use an Orchestrate oeprator when all the functionality are available through Datastage?

Can anyone tell me what all the codes are and what they mean?

I am trying to learn what MQ Series is so that I can use the MQ stage. I have done extensive search on the web and Ascential's site. No luck. On Ascential's site, there are several articles about MQ Series and what it can do and stuff but there is no beginner's tutorial as to what MQ Series is. The ...

My FRQ file shows: Pattern: Example: -------- -------- ^D+D++T 12300 SW 111TH S CANAL STREET RD However, when I do Standardization Rules Analyzer on the ruleset, it shows: SS: 0000 UP: ^D+D++T UD: 12300 SW 111TH S CANAL STREET RD IP: ^D>D+TT UO: User OverrideFlag If this pattern is unhandled, should...

Thanks ray for responding. From my understanding, Unhandled Pattern tab is for when the Investigate stage cannot handle the pattern, right? I am wondering how would we know what pattern to deal with if Investigate cannot handle it.

When creating an override rule set, in what situation would you use the Input Pattern tab and when would you use the Unhandled Pattern tab?

ray and kris, thank you very much for your posts. ray, can you tell me how I can find out which rows have unhandled patterns? For example, if there are 1 million rows and 3000 of them fall in a pattern, how do I look at those 3000 only? The PAT, FRQ and SRT files don't have that info. Is there a tec...

How do you see the rows which have fallen into unhandled patterns?

I downloaded Kim Duke's EtlStats_20060704.zip. However, I am not sure as to how I should go about installing it. I see a file called ETLStatsInstall.txt and another one called ETLStatsInstall2.txt. ETLStatsInstall.txt starts as follows: "You need to create some files at TCL. Probably DataStage ...

kduke, can you tell me why this job is not a recommended practice? Does it cause any damage anywhere else in the system?

How do I do it?

Arndw, none of the functions that can be run in the Parallel Edition of Datastage is listed in the Parallel Jobs Develop's Guide. This guide has descriptions of all basic stages (no plug-ins) and that's all. Do a search for a StringTo.. function.