DSXchange

Or dsimport.exe available in clinet.

If that doesn't work, check if the scheduling services are running in the server. You can check this by Control Panel --> Services or Administrative tools-->services based on the version of windows. Check for a entry called Scheduler or Schedule or Task Scheduler. If that is not started, start it.

u r right Ray, the field is having the value like $17250.00 and i need to convert it to 17250.oo means i need to suppress the $ sign. Rohit, Ray is asking you to check the length of the input and output field compatibility. And please avoid SMS type language("u", "r"), not everyone understand this.

balajisr wrote:May not be the case Kumar. Transformer sometimes internally calls modify functions.

Really??!! I never experience this. Im not use PX recently.

The information given was related to V8. But the same holds good for the V7.5.1. The setup.exe can be found in client Cd ..\Ascential DS Client v7.5.1\DataStage Client\MultiClientManager

What if you write it directly as Dfloat (without any conversion to string)?

Try from different client or directly from the Client where the server is installed. AS mentioned try to execute the following command from the command prompt, "AT 16:35 vmdsr_sched.exe e:\Ascential\DataStage\Projects\SMDM_dev HF_AVG_SELLING_DAY 0/50/1/0/0 3" This is the one which utilizes the AT sc...

chulett wrote:Or maybe just "Me too!".

You just getting too hilarious, Craig.
I couldn't imagine many "Me too.." post, and the make OP to confuse whether to give the same rating for that supplementary post too.

Because the function decimal_from_ustring that you have used is a Modify function and you are trying to use transformer. StiringToDecimal function that been mentioned can be used.

It is Job Sequence not sequencer. Check the log for the first job 'Extr' for the actual process happening in the server.

Write the dataset into a sequential file and check for the value of the data.

Thanks for mentioning the option that you going to use. So its time for you to mark the topic as resolved.

If "/" is used for commenting, "*" can be used.

There is orchdbutil utility but not orchdbadmin.

Hi Mohan,

No need a procedure just for Truncation. You can use "Truncate Table Before insert rows" update action available in OCI stage. If you tend to just truncate, you can do in Before/After sql as well. Or you can even pass some blank records with this option.