DSXchange

Based on Pongal's message I assume that the job is running on UNIX platform, because the pathnames are UNIX pathnames.

Please also check spelling in your job design. For example, I note in your post that the stage is called 'Alimentaion_Table' while the module is called Alimentation_Table (not the additional "t" in "alimentation"). Could you perhaps have a similar discrepancy in your design? (The names recherche and...

Can you connect with the Administrator client (which uses a slightly different paradigm)? If not, please post the full error message. If you can connect, what happens when you select the Projects tab? In the dssh environment (as per Arnd's previous post), execute the command LIST UV.ACCOUNT PATH and...

There's a second form of the SLEEP statement, that sleeps until a particular time. Note the following code fragment. * Wake every five minutes to check whether any notifications. Now = Time() PrevTime = Now * Exit loop when two hours have elapsed. ExitTime = Now + 7200 If ExitTime > 86400 Th...

What Sainath is saying is that you require a statement of the form UPDATE schemaName.EMPLOYEE SET END_DT = :2, POST_DTS = :3 WHERE (EMPLOYEE_NBR = :1) for Oracle, or UPDATE schemaName.EMPLOYEE SET END_DT = ?, POST_DTS = ? WHERE (EMPLOYEE_NBR = ?) for ODBC and most other databases.

Strange as this suggestion may seem, go back to Chapter 3 of the Parallel Job Developer's Guide , and find the table where all the stage types are listed. (Don't have access at the moment, or I'd be more precise.) I've found that seeing the groups of stages together makes it easier to understand wha...

It's a roundabout way of saying simply that you haven't filled in a required value in one of the fields in the stage. A common field to forget is the table name field. All stages and links are objects. You can't affect their methods, but when you edit you're setting values for their properties. Henc...

This is a very annoying message to get for DataStage; it's actually from the UniVerse transaction logging daemon (uvlogd), which wakes during startup to determine whether logging is enabled. It never is for DataStage, but it checks a few things anyway. UV_LOGS is the file where information about Uni...

You've just discovered why it's not best practice to use long periods of SLEEP.

Re-code the job so that it wakes up occasionally to determine whether any signals or other notifications have been received.

Use Director.

Project > Print

In the Print dialog, check "print to file".

Hi, When iam trying to load the data to oracle table it throws the error xyz..Transformer_1: ORA-01438: value larger than specified precision allows for this column. But i have checked the datatype and length of that field and it is Decimal and Precision 9. When i tried to insert the '1' also it th...

Do you actually HAVE categories for your shared containers, or have you just put them all in the "root" category? That is, when you open a shared container's properties, is there anything in the Category field? If you have not specified any categories, there will be none displayed. You can verify th...

There's a README that ships with each new release.

If you have QS 7.5, read that. If you don't, you can get it from your support provider or from Ascential.

The limit for a log is 2GB. It's not possible to state that in terms of log entries, because these vary so widely in size. However, a full log does not prevent access to the Engine. It will corrupt the log (hashed) file, and thereby prevent access to that particular job, but it will not prevent acce...

That's what you had to do. The "create" stage has not closed the file, and chances are that it had not actually created the file (rows had been buffered in memory) before the "append" stage was activated and therefore determined that it, too, must write to a new, empty file. With sequential files, t...