DSXchange

Hi John, Seems that you are making a look up on an hash file that doesnt contain all the records of the stream link. Seems also that you have applied a constraint to filter the record on the output link. Isnt it??? Could you pls explain better the process? Maybe will be helpfull to see the constrain...

Hi I have a problem with a Transformer stage. The job it is in has an 2 input stages (ODBC and Hash) and 2 output stages (both Sequential file stages). The Transformer stage sits in the middle, takes data from the 2 input stages, applies constraints, and sends data to one of the two output stages. I...

I have seen a situation where I started four instances of a job, three of them ran successfully while one of them logged an abnormal termination straight away but continued to run. The log and status indicated the job had failed and was not running, the clear processes screen showed the Phantom was ...

Im assuming that this is a user-defined query in your ORAOCI stage, but there is a bug in one version of DataStage that could also cause this. Which version of DataStage are you running? The most likely cause of your problem is that you have a user defined query in a reference lookup or an insert/up...

Hi In administrator of Datastage can i configure DS to send a message (mail, desktop, etc), whit -> a file is exceed same size value -> a message of an DS error -> the space in disk is low Can i have a list of the possible return messages of dsjob ? Rui Soares Rui Soares NOVABASE - Data Quality - QP...

Hi guys,
I have a job that reads from two sources and write to a ahashed file and it always gives this error:

"AhmedTest.DW_CONTRACT_SERVICES_HISTORIES: ORA-01036: illegal variable name/number"

does any one have any idea about this?

Thanks and Best Regards,

Sameh S. Bishara

I see my mistake I looked again at the docs and see that you must specify length unless you specify mask. I was doing neither. I answered my own question, which was posted earlier: > Have I misread the docs on how to specify precision and truncation? I > notice your code samples place a number at th...

Raymond Thanks for your reply. I thought in my code that I included the decimal information: >>FMT(EW.VALUATION_PR, "R50T") FMT(Pano.VALUATION_PR,"R50T") or >>OConv(SQLServer.VALUATION_PR, "MD50T") OConv(Oracle.VALUATION_PR,"MD50T") ...where in the FMT version above, it reads Right Justify, 5 decima...

I have a multiple instance job implemented using DataStage 5.1 which is supposed to overwrite the existing target file and start processing from the first record of source file every time it runs. But for some reason, when rerun the job, it doesnt clear up the file and does resume processing the rec...

Specify the number of decimal places, otherwise "rounding" or "truncation" have no information about where to operate. For example FMT(Link3,CalculatedLoading, "12R3T") or FMT(Link42.Quantity, "10R0T") Ray Wurlod Trainer - Asia Pacific Region IBM Informix Training Department Level 22, 60 City Road, ...

Specify the number of decimal places with the FMT() function, for example FMT(Link3.AvgLoad, "10R2") Ray Wurlod Trainer - Asia Pacific Region IBM Informix Training Department Level 22, 60 City Road, Southbank Vic 3006 Tel: +61 3 9626 6624 Fax: +61 3 9626 6622 Notes: Raymond Wurlod/Australia/IBM Emai...

Thanks Chris > Folks on this list are usually very gentle - they might want > you to start a > new subject for a fresh question though! Yeah, I forgot to change the subject line before sending - my apologies. I noticed it moments after sending but thought posting a follow up wouldnt be necessary. > ...

Hi John, I assume you want to leave the LHS unchanged. Try FMT(whatever,"R5"). Ill leave it to the Universe / Engine Gurus to provide a full explanation of the FMT function ! Folks on this list are usually very gentle - they might want you to start a new subject for a fresh question though! Best Reg...

Hi All Im a list newbie, so I hope youll be gentle. Im using Datastage 4.0 and am trying to perform a data conversion on a Float field coming in from an ODBC Stage querying SQL Server 2000. The conversion Im trying to perform is to truncate the field to 5 digits o precision to the right of the decim...

Thanks Gavin. I could request for more memory. Actually as long as I had a local install of Datastage Designer and Director, I did not face this problem. Now I am executing it from a Network installation. May be that is why? Gavin.Cooke@voda fone.co.nz To: cc: 03/21/2002 07:08 Subject: Array Size in...