DSXchange

Again... in words? Like you were writing a requirement for someone else to follow? Worst case, write your own C++ routine and call that.

Sorry, doesn't work that way here.

That really explains nothing and you didn't answer any of the other questions.

You need to tell it that's what you want to happen. That's what the Terminator stage is for or perhaps the 'Automatically handle' compiler option.

Please look twice before asking someone to mark something Resolved - they already had when you posted.

What "code" are we talking about? How was it generated? How did your CR/LF terminators go missing in the process?

No, they're not or you'd be seeing all records. You have a metadata mismatch and the "bad" records are being rejected by the stage. Try all Varchar fields and see if that helps. ... Problem got solve actually the view data period was set to 11 now i have changed it to 1 now i am able to s...

nima511 wrote:It could grow to more than 100 over the next few releases.

And?

Shane is wondering about one magic job with RCP, I'd wager...

No, they're not or you'd be seeing all records. You have a metadata mismatch and the "bad" records are being rejected by the stage. Try all Varchar fields and see if that helps.

Is the project Protected? Perhaps you should be making your changes... elsewhere, I would wager you should be doing this in whatever 'source' (dev) project they were originally developed in and re-promoted. They should be "read only" for a reason, not on a whim.

A) It's not urgent for us but I just happen to be up and posting at this time.

B) Why not spell out your requirements in words rather than code? Tell us what you have to do, not how you think you need to do it.

Or just convert it to an empty string rather than a space, save the whole 'trim' part.

Right, was wondering if IPC was actually what was meant - and it's not the Silver Bullet that some seem to think.

Seeing as how you'd need to use TO_TIMESTAMP() rather than TO_DATE() and DataStage is unable to automatically generate the former, you have no choice but to use 'custom' SQL for this.

What exactly does that mean - "showing query in the fields"? Can you post an example, please.