DSXchange

ray.wurlod

Is the Teradata client software (TUF) installed on the DataStage server machine?

ray.wurlod

There were three questions...

ray.wurlod

Probably. What are the differences between the users' profiles? What permissions might be affected? Did you execute the dsenv script before running from the command line?

ray.wurlod

Or, for the truly paranoid function developer. FUNCTION Doze(aInterval) Begin Case Case UnAssigned(aInterval) Or IsNull(aInterval) NULL ; * do nothing Case Not(Num(aInterval)) NULL ; * do nothing Case aInterval <= 0 NULL ; * do nothing Case @TRUE * We have a positive number as the argument SLEEP aIn...

ray.wurlod

Even better is to leave out the Perform statement.

Code: Select all

FUNCTION Doze(aInterval) 
SLEEP aInterval 
Ans = 0 
RETURN(Ans)

ray.wurlod

That's because you are in an account that is not a project, therefore there is no DS_JOBS table. LOGTO any project account and you will find that the query succeeds. It works in Administrator because there you have already chosen (and invisibly connected to) a project. Quoting the entire SQL makes n...

ray.wurlod

Commands can not be executed from the Transformer. If you need to sleep while in a Transformer then you need a Routine that the Transformer stage can call.

Code: Select all

FUNCTION Doze(aInterval)
Perform "SLEEP " : aInterval
Ans = 0
RETURN(Ans)

ray.wurlod

The problem has occurred slightly after line 148 (line numbers can be out by a few particularly if INCLUDE directives appear in the code). It has occurred while trying to close the connection to the database (DSP.Close is an internal routine used by stage types that employ ODBC protocols.) There's n...

ray.wurlod

DataStage Director.

Disable Show Folders in the View menu.

Sort by Status.

(You can use the Filter to exclude Not Compiled.)

Print to file.

ray.wurlod

Type the command in upper case.

Code: Select all

SELECT * FROM DS_JOBS;

The parser has actually reported it incorrectly; the problem is with the table name, which is case sensitive. Reserved words from SQL are not actually case sensitive. So the following would have worked.

Code: Select all

select * from DS_JOBS;

ray.wurlod

And, if that works, please mark the thread as Resolved using the green button at top.

ray.wurlod

Are you the same person? If not, can you please post the script so that Apotluri may have an answer to the original question?

ray.wurlod

Please delete your duplicate post before anyone responds to it.

ray.wurlod

Does your PATH environment variable when the job runs include the parent directory of the sqlldr command?

Does the executing user ID have write permissions to whatever directory you specified for the control and data files, and to the scratchdisk (where the log and bad files are written by default)?

ray.wurlod

Curiously one of my clients also ran out of space for XMETA yesterday. However it was DB2, auto-extend was ON. They actually ran out of disk space. So they'll be adding 30GB to that file system overnight.

Search found 53125 matches