DSXchange

You have found the first step of your solution yourself: There is no join to one of the other two tables for parametro, so take the following steps: (1) Use only the first two tables: SELECT TO_CHAR(BALANCE_AS.FEC_DIA_GAS,'YYYY-MM-DD HH24:MI:SS'), PUNTO_SISTEMA.COD_PUNTO_SISTEMA, BALANCE_AS.CAN_EXTR...

Hi amrise, Doing like denzil proposed all derivations which you might have made are also swift away so manualy changing it everywhere may be the better solution. If you have no changed derivations you could do so. One not supported way of changing it would be: Do an export of the relevant jobs Open ...

First Tip: Normaly there is no need to do an update via an routine. Having a Sequentialfile with the Column-Names in the first line is a Standard feature for an very normal and easy DataStage Job. But I suppose you want to create a General DataStage-Job which does a load for all kinds of possible fi...

Hi Raquel,

Let us assume your Datefield in the oracle-Table SOMMER is START_DATUM, in DataStage you have to write in the where-Part an expression like:

to_char(SOMMER.START_DATUM,'YYYY-MM-DD')='2003-10-03'
or

to_char(SOMMER.START_DATUM,'YYYY-MM-DD')='#param_21#'

Good luck,

Wolfgang

use stage variables to save the first line

Hi Tony,

Ray and Raj did it write because they used 1 (one) and not l (lambda).

Wolfgang

Yes, they are available. There are Functions (is suppose something like DSJobLinkInfo..) you can ask for this informations. Have a look in your manual.

Wolfgang

The philesophy of DataStage is to have Stages which are linked via links. Via this link data are flowing. With a Container (shared or local) you have the opportunity to hide one or more Stages within such a Container. If you use your container in a Job you must link the input or the output or both t...

what you should check is the "real" content your source and your target-columns. If you have 12,566 Euro as source this will be display in a 14.2 display as 12,57 Euro. If you add 12,566 Euro + 12,566 Euro + 12,566 Euro you get 37,698 Euro which is displayed in 14.2 as 37,70 Euro If you ad...

Hi, sowmyadevi, if DataStageServer=Windows then you can use ODBC. if DataStageServer=Windows then you can use bye additional ODBC-driver from third party or you save excel-files as csv and load them as sequential file. It is easy to use Excel as input. But Excel is a very flexible tool so if you don...

Hi Dhiraj,

I don't understand what you are doing with you lookup but the way you describe it you seam to do something wrong.

Please give some further detail, what you want to do and what you did for to solve the problem, so that we can help you.

Wolfgang

Hi Hermant,

this may happen from time to time if on a Windows computer too many processes are active at a time. One sure way to solve this problem is to reboot the computer.

Wolfgang

To read Database-like information from Excel is not an easy task. The people who fill the information to excel do have to have a high grade of discipline, though Excel itself is a very flexible tool. Even in some regions the export via a VB-macro from excel and via manual export does look completly ...

try to divide the export-file. *.dsx is a bit readable, you can easily find the beginn and end of ellements. Use the header-part again in all new parts.

Perhaps that may help.

Use parameters for input-files and output-tables