DSXchange

Wouldn't it be more appropriate to use DSGetLogDetail for this?

Suggest you search the forum for your error number - it has been discussed here a jillion times. All kinds of information out there on the subject.

You're going to need to find the SYSTEM call that tells you the O/S and then build the command appropriately. Difference would be the actual command used and the direction of the slashes. Primarily.

Exactly.

It's got nothing to do with the where predicate. The problem is in the view itself - it probably makes assumptions about nls_date formats there which is always a mistake.

47shailesh wrote:DUMMY column is not used any where nor it is present in the DB.

Which is - as noted - more than likely your problem. Did you even try what I suggested?

Post the syntax that you tried.

Also, it's always best to explain what didn't work about something, simply saying "it didn't work" doesn't really tell us anything.

Simply a matter of understanding the fact that Stage Variables are executed in order and thus values from previous rows are available until replaced with the current row's value. So the order they are declared on is key. That being said, why would you need 'previous values' to do a running total? Am...

3.0? Oh, my - that's old enough that you haven't seen the 'new' Transformer stage. That came in 3.5 from what I remember. And I don't know if you'll be able to go straight up from your ancient version in one shot. There were some fundamental changes between 5.x and 6.x but that might have only invo...

Since you didn't post it, an ORA-01830 is: "Date format picture ends before converting entire input string" Since there's nothing wrong with the TO_DATE filters you've got in the where clause, I'd dive deeper into the definition of the VIEW you are selecting from. Something with either the syntax or...

The convert, not the trim, is removing the letters for you. Does it cause any potential problems? You'd have to tell us - it only removes upper-case letters from the string, is that enough to solve your particular problem?

I have a requirement of using in bulit routines in the transformer stage You've gotten a bad requirement - if the routines you are referring to are Server routines. While you can use them in a PX job with a BASIC Transformer stage, there are all kinds of restrictions and caveats that come with that...

Just type it in - you are not forced to use the drop-down. From what I recall, it won't show up on that list until you import metadata using it.

So you're asking about null values in flat files? From your post, you give the impression they are already 'NULL' there and you were looking for some off-beat way to store them that way in Teradata. Hence both my and Ray's reply. They are typically stored as 'empty' field in a flat file. Are you cre...

Why the 'trim' function? Why not something more appropriate to the task?