DSXchange

An exact search for 'cutter' will turn it up.

In their dsenv file I would imagine. Or you could define it in the Project as user-defined with a value of $ENV and then override it in a specific job, if that's the only place it is needed.

StringToDate() still works, check the documentation for the proper format mask. If your target is not a DATE then use DateToString() afterwards to get it back out in the format you need.

... and by string I of course meant a CHAR field.

That works too.

After converting to timestamp, use TimestampOffsetByComponents() and add three hours. That or TimestampOffsetBySeconds() and add 10800 seconds.

Ah yes, 8.1... getting a little long in the tooth and you're right, doesn't support that 'direction'. Later versions correct this.

Ack... didn't notice the forum. Moved.

That decimal data type is reserving a space for the sign. AFAIK you'll need to convert the decimal to a string in the file so you have full control over that.

mandyli wrote:we are using Datastage 9.1 and imported same job in Datastage 8.0.

Also note that doing this is completely unsupported.

We saw these same "ORA-02396: exceeded maximum idle time" errors when our connection user had a timeout and the query didn't start returning records within that window. Solution? Remove the timeout.

1 Crore is 10M. You'll also see Lakh mentioned here which is 100,000.

As noted, it's a display notation and could just be a setting in whatever tool you are using to display it. For example, Toad defaults to having Scientific Notation enabled for values like that. It doesn't necessarily mean the data isn't populated correctly.

Similar doesn't work for a reply but it does as your own question, so I've split you out and linked back to the original just for grins. Note that I had to guess at your particulars (version,O/S) as you've yet start your own topic.

I don't think so. I doubt it connected at 5:56:53 and before another second ticked by it output 4.3 million records. But I'll let others that know IA continue the conversation, I was just trying to get some clarifications on the issue.