DSXchange

Mario, There is no function, but you may be able to accomplish it by using the aggregator stage. PM ----Original Message Follows---- From: "Dudley, Mario M" Reply-To: To: "datastage-users@oliver.com" Subject: standard deviation Date: Thu, 16 Aug 2001 14:15:33 -0700 Does anyone know of a function to ...

Its not a warning, its an informational message. Because its been logged from &PH&, probably during a job reset, its tagged as a warning. Its a report from the process that executed the code generated a Transformer stage. The name of the program is DSD.StageRun, the number of your job is 530, the na...

None exists, but its not difficult to write one yourself PROVIDED that you can deliver the count of values, the sum of values and the sum of squared values to the function. This is tricky to do in a streaming environment, as you need to capture "breakpoints" - that is, where the value of the categor...

Hi, all I have some jobs that hash data in Universe tables. Sometimes some of them give me this warning message when it start running: DataStage Job 530 Phantom 11803 DataStage Phantom Finished. [11846] Done : DSD.StageRun 530 StagingFRFOSOperationalSystem.TRANSFORM 77 0/2000 anybody know what this ...

Does anyone know of a function to calculate standard deviation within Datastage?

Thanks,

Mario Dudley

Hi,

Im using the stage ORAOCI to load a file into a ORACLE table. If I use the
options:

Hi, We have just started using the ORABULK control in our DataStage(4.1) jobs. The control file (.ctl) generated by this control always has a double quotes (") around the column names. Because of this, we get an error "Invalid column name.." while loading data. Once I remove the double quotes around...

Apart from killing the main process you will also have to look for Phantom processes. ps -ef|grep -i phantom Also, check netstat -a|grep uv and look for CLOSE_WAIT processes. Killing the phantom processes should clear any close_waits. .. You can also clear the &PH& directory (found under the project...

dsexport.exe has been in the product for quite some time, so you should be able to find it. Its very useful, although it is unfortunately a client side tool. I dont remember exactly when it was first included, but I thought it was prior to 4.2... Ernie -----Original Message----- From: Brundyn, Piete...

Thank you to all who responded regarding how to read signed decimal fields from a mainframe into DataStage. I could not use the routines that were included in the SDK since I read data from the mainframe using the FTP Plugin. As such, it converts the EBCDIC characters to ASCII. Thus, the hex values ...

We are currently using Datastage V4.0 Is there a commandline export utility that will export all jobs/routines etc.. from a project to a file without user intervention? I heard that version 4.2 has an export utility included. To use that export program, do you have to install version 4.2 or can you ...

Try the Clear Status File .. this should work. "Li, Xiong (Corporate Manukau)" on 08/14/2001 09:05:09 PM Please respond to datastage-users@oliver.com To: "datastage-users@oliver.com" cc: (bcc: Lisa Hamilton/COL/OH/NCS_HealthCare) Subject: How to stop datastage job running Hi, All I have a job which ...

Use the other maintenance tool in Director (Cleanup Resources) to determine what is locked (and thus causing the "cannot get exclusive access" message. I am travelling at the moment, so dont have all my usual resources to hand. Contact support to get more information about what error code 40908 mean...

Thanks, Ray. I know "RUNNING" is not the actual status, the issue is I couldnt compile this job even I am surely it had stopped just now. Now, its status has automatically changed to be "Compiled", but I cant compile it, because of "Cannot get exclusive access to executable file for job......", the ...

The job status is not the actual status, but the status the last time the status was recorded. This is a value in the RT_STATUS table for the particular job in the DataStage repository. So the job may actually be finished or stopped (possibly abnormally), but didnt get the chance to update its statu...