DSXchange

Did you give the WaitForFile stage a shot? :? Don't use 'find' as the command, try using something like 'test' instead. Check your man pages. yes i try with WaitForFile stage this success for file exits if file is not found i need to run another job. here in trigger what value do i need to check be...

You could also investigate the WaitForFile stage, which actually doesn't have to wait at all. You can use it as a file existance checker, for example, and branch accordingly. i am using find #path#/Test.txt in execute command in sequence how do check the status.. if file found i need to do one proc...

How to check file is found in a specific direcotry using datastage sequence.

There are two fields on the Command tab in an Execute Command activity. In the first (Command) you put simply the rm command itself. In the other (Parameters) you put anything else that needs to appear on the rm command line. This can include references to job parameters, for example -rf #path#/#fi...

ray.wurlod wrote:Use an Execute Command activity with rm as the command. The command arguments field can contain options (for example -fr) and a job parameter reference to the parameter containing the name of the file to be deleted.

Please can you give example?

ArndW wrote:Veni,

are you aware that you can call up UNIX commands from sequences and jobs? This will allow you to take care of your file deletion.

may i know how to call unix command from sequences...
i know the rm $filename how to give this command in sequences.


Thanks
Krishna

hi,

how to delete a unix file from datastage job.
datastage job should find test.txt file in unix server if it is exists then i should delete that file...! i want to use this process in a datastage sequencer.

Is OCI bulk load will support the nano second , because in this stage date default option nano second is not available

I tried with the Oconv and substrings fuctions but none of them is working.

Please guide me .

Hi I have a input text file which have timestamp in this format (yyyymmddhhmiss+nano sec ) value is like this (200512161015222323). My requirement is how t move this value to the oracle timestamp attribute. Which function i should use in transformer My output should be like - 16/12/2005 10.15.22.232...

After making all Nullable ='Yes' also i am getting same compilation error.

Please suggest me .

Still i am facing same problem and i check in my transformer all the expressions are correct (no red mark)

In the metadata of all output columns those who are decimals with precision&scale=0 DataStage has converted automatically those in Integer by default and other those are Decimal with precision&scale >0
thats is in Decimal format.

Is this is the problem with Meta data ?

Thanks in advance

When i try with the 300 fields , its working fine but when i am trying to use the same expression with 1220 filed in a singletransformer .I am getting this error The expression which i used is (if trim(field_Name)='.' then SetNull() else StringtoDecimal(field_Name) ----------------------------------...

Do we have any limitation on writing expressions in Parallel Extender Transformation Stage ,because when i am using 300 colums with same expressions my job is working fine and compliation is also fast but when i am using all 1220 colums in single transformer , its throwing lot of errors -(Error when...