DSXchange

chulett

I agree, unless you are timestamping your dataset names and need to prune out the older ones, why bother? They get overwritten the next day, what do you buy by deleting them temporarily?

chulett

So you didn't try what was suggested if you left out the whole 'stage variable' part. Have you played much with stage variables yet? Do you understand that they are evaluated in order, top to bottom, and can thus be used to store the value from the previous row for use in the current row just be ord...

chulett

Something else you might investigate - get the internal job number for that job name by querying that from DS_JOBS and then see if any structutes exist under the project directory for that job number.

chulett

Typically, from what I've seen here in the 8.x releases, that indicates an 'out of sync' condition between the legacy repository and XMETA. To resolve that you need to contact your official support advisor and get their help cleaning up whatever needs cleaning to get things back how they belong.

chulett

As noted, it depends on how it is doing this "outputting"... you could do something "After Job" to force a conditional abort. Anything after that would be too late, so I don't really see how a Sequence plays into this unless perhaps rather than aborting you needed to send out an ...

chulett

srivalli_b wrote:RDBMS code 2646: No more spool space in tdadmin.

Take that error to your DBA.

chulett

I don't see anything obviously wrong. What happens when you run the job?

chulett

Show us exactly what you tried.

chulett

'Bulk' is not a term typically associated with sourcing data but rather loading. Unless this is a Teradata specific thing?

chulett

That's what happens when you REINDEX with active connections / processes in the project. You need to rerun it but ensure that nothing (other than you) is 'connected' to it - if you have to bounce DataStage to do that, do that and then make sure you REINDEX before anyone gets back on.

chulett

You are missing a fundamental point, the one Ray pointed out. To check your sorting, run the output to a flat file - tables have no 'sort' to them. If you want data out in a certain order, use an order by.

chulett

Start by posting your own topic with the gory details of your issue.

chulett

Post a count of the number of files in the &PH& (Phantom) directory in each of your projects. running ls -l | wc -l returns a count of 211 - that's 210 files. OK, then something you can cross off your list of potential suspects. If this number were signficantly higher, then perhaps it was a...

chulett

One thing - make sure you don't try to attach to the job that is running this routine, that will cause a hang.

chulett

vincyTing wrote:UDA-SQL-0107 A general exception has occurred during the operation "prepare".[IBM][CLI Driver][DB2/NT] SQL0551N "DB2ADMIN" does not have the required authorization or privilege to perform operation "SELECT" on object "SALES_REGION.REGION2".

DSXchange

Search found 42189 matches

Re: Error on Creating Report