DSXchange

ray.wurlod

Silly me. I assumed you had done that.

ray.wurlod

The explanation given in the manual appears quite clear to me. You do need to regenerate DataStage after changing uvconfig - did you do that? And there will be an extra daemon (the disk cache manager daemon) running if you enable public shared cache by this means. I can't tell you whether 512 will b...

ray.wurlod

We have a server job which runs daily. Normally it takes approx 7 minutes to complete. But the yesterdays run of this job is still in running state. No warnings whatsoever. We are not accessing any Databases. Only seq files and hash files. All the files required are in place and have the proper rig...

ray.wurlod

Is this when you do a View Data on the hashed file? Can you list the dictionary of the hashed file, at least for the fields in question, and post the results here?

ray.wurlod

Welcome aboard.

The first thing you need to do is post your question in the parallel jobs forum. By posting it here you'll get server job answers, which won't help at all, and will be misleading.

ray.wurlod

Does Teradata allow for SELECT in the SELECT clause?

Code: Select all

SELECT (SELECT COUNT(*) FROM table) AS COUNTS, 'sourcename' FROM table;

ray.wurlod

It's a very vague question you've asked! There is a "programming" chapter in each of the Developer's Guides, but beyond that there doesn't appear to be much apart from what you can learn by looking in bin and lib directories. This site is more geared to specific questions such as "is there a way to ...

ray.wurlod

Probably the only solution to this particular requirement is to read the file as a single VarChar column and parse it yourself within the job.

ray.wurlod

One of the report options in the dsjob command.

ray.wurlod

Lack read permissions? Corrupted hashed file header?

ray.wurlod

I have no idea what you're talking about, because I have yet to have any hands-on experience with version 8.

ray.wurlod

What is your default date format string (set in Administrator, on Parallel tab)? The date format you specify in handle_null must match this string.

ray.wurlod

... which means that all the nodes named in the configuration file with which it was created must be accessible under the new configuration file's regime. The control file (blah.ds) contains the locations of the data files, though not readily in human-readable format.

ray.wurlod

Yes.

The job sequence did finish successfully. What is its STATUS (from Status view)?

ray.wurlod

DataStage.

Code: Select all

Convert(Char(0), " ", InLink.TheString)

UNIX

Code: Select all

tr '\0' ' ' < infile > outfile

DSXchange

Search found 53125 matches

Re: Job in Running State