DSXchange

In addition to the uninstall program, I would remove all directories and then check your Windows registry and remove all DS related entries. I am not sure under which heading they come, it might still be "Ardent" or "Ascential".

Could you post your SQL, please?

Ok, I think I might understand. I'll have to keep this thread and use it to justify my increased rates.

Do you have enough space to copy the install directory to a local disk and run it from there; that might work for you. I haven't had this happen on DS but with other products and it might have something to do with how the drive is mapped.

vkhandel - that would abort if the field were null, and I thought that the field was a "date" type, which cannot be trimmed in any case.

Craig - that would make a lot of sense, since I never noticed that path before with server jobs.... yep, you are correct, I just checked a job sequence and it didn't modify any of the search rules.

I have cross-checked on AIX and Solaris and the jobno is there - so it would seem to be specific. I assume that the object directory is added because it is required, so I am surprised that HP-UX doesn't have it. Perhaps the addition is an artefact that will disappear at some future release.

Craig, don't worry, it is just that Prof. ag_ram has put his seal of approval on your answer.

Perhaps I misunderstood what you would like to do. Could you explain what you want to write when the date is null?

If the IsNull() function does not return TRUE, then you don't have a null value in the column. Try a test job and set a date to a null value using SetNul() then test it again with IsNull() and you will see what I mean.

do a "df -k" and see if any of your disks are 100% or almost full. Also, attach to "/opt/IBM/InformationServer/Server/Datasets" and see if you can "touch testfile" (then "rm testfile" if successful).

perhaps - is this a new project or installation? Have you checked your APT_CONFIG file ?

Depends upon the limitations for simultaneous connections in the database(s) you wish to connect to; other than that the limits will come from your OS settings, not from DataStage.

ag_ram - I didn't state that either Craig or yourself were wrong, just that using documented methods is preferred over undocumented ones. veera24 - I neglected to finished the details in my original post. Open up the 3rd log entry, where the ENVironment is displayed, and the LD_LIBRARY_PATH will hav...

looks like the disk is full if all users are now affected. Have you tried checknig with "df"?