DSXchange

What he said. Telling us simply that it "did not work" doesn't help us help you troubleshoot the problem.

Can't you just set the extended properties to 'packed' (or signed/zoned decimal?) and let it convert that overpunched sign for you automatically? Don't recall the gory details but didn't think you needed to manually code this conversion.

Let the stage generate the SQL so you can see an example of what it needs to look like in your file, specifically the numbered bind parameters that it uses.

kamesh_sk wrote:Aslo can you please let me know what the 'leading edge on the index' means?

I just mean that for a composite index, those three fields would have to be first in the included fields for your update to use the index.

As far as I know, all that is supported are SELECT statements. Where are you doing this, on the target side? If it is letting you use that option there, you'd still need to bind all of the columns in the stage to the sql...

Sorry but you've already shown us what it is like, I was hoping to see the actual, real live derivation. Cut and paste it here unedited, please. If you are certain that all of your input columns have been mentioned (and only once) in the derivation and they only have a plus sign between them, then s...

OK, should be simple enough... post your actual derivation, please.

For the official 'Load from file' option, leave off the {FILE} part, just include the true pathname. That prefix is for stages that don't support the 'Load from file' option directly.

Since your index names mean nothing to us, I have to ask... do you have an index over the three columns in your where clause? (ACC_SOC_SEQNO, ACC_ACCOUNT_NO, ACC_SUBACC_NO) Are they on the 'leading edge' of the index? If yes, have you or your DBA checked that it is actually being used while the job ...

Didn't answer my 'valid numeric question' question. Can you explain to us what was 'not correct' about the summation you are doing? I think one sample would be good to get us going, an example of all of the field values you are adding plus the result that you got along with the result you expected. ...

Are you certain that all of the fields contain valid numeric data? Are any of them... 'empty'?

I'm pretty sure that bascially all of the stages support loading their source SQL from a file, either from a specific 'SQL File' option or by using a specific tag... {FILE} perhaps? It is documented.

You mean they have posted something now.

Honestly I have no idea how Oracle's EPM product will present itself (never having used it) but I would imagine whomever your company bought it from would be happy to explain all that.

Nothing happens on the client, it all happens on the DataStage server. And what you need to configure depends on how you plan to connect to the Oracle database. Going to use ODBC? Configure the ODBC drivers on the Server. Native Oracle connectivity? Install an Oracle client along with the proper ths...