DSXchange

Their membership expired. The forum software shows someone as "Premium" if they've ever been one, not if they currently are one, so it can be a little... confusing.

You would do it the same way as a Sequence job is just another job.

You increased it to what? Technically, a NUMBER in Oracle is stored as a Float and can be up to a DECIMAL(38). I've had to specify it as DECIMAL(40) in the past to stop the "truncation".

So what's your "workaround"?

So this is actually a question about Parallel jobs? You marked the Job Type as Server, hence the question.

Then increase the size, see if that causes the error to stop.

How did you define the column in DataStage?

2 what? 88 what? :? You need to be more precise in your questions and replies so people can help you. Does your source table have an unbound number in it? Meaning one like NUMBER rather than NUMBER(15) or any other precision. Does it have a LOB column, like a CLOB or BLOB? Is your database set up wi...

thanks ray, actually yes it is memory issue and repeatable , but there is no process either than this load is running on the server while this server is dedicated for data stage engine .. Just because it's dedicated doesn't mean it isn't overloaded, for all we know it was under-configured. Can you ...

This suggests it is not a data issue.

The 7.x version does not include an XMETA repository, this is just about connecting to an Oracle source/target via OCI. Officially, neither 10g nor 11g are officially supported by your version. If you are having no issues with the 10g client, I don't see any need to change it as you can use it to co...

Of course it can be done via Director, it's just that you would need to manually 'Add to schedule' an entry for each year as far out as you'd need. One at a time.

Don't think there's a need to another variable, as I noted a simple change to the logic you posted should accomplish the goal. Seems to me: If In.Key=svLastKey THEN svGroupNo ELSE svGroupNo+1 becomes If in.Key = "d" and svLastKey = "c" THEN svGroupNo+1 ELSE svGroupNo "Key&qu...

devesh_ssingh wrote:@jwiles--i have tried with folder stage but output is only picking the last corresponds records only.

You said as much in someone else's Folder stage post and some suggestions were made there as to how to solve that. Did you try to follow up on them?

Sorry, thought I did. Which part was unclear?