DSXchange

Hi,

You can design Sequence instead of Job Control. It is possible to call a external routine from Sequence.

Regards
Amitava

Hi,

You have to handle null by using different inbuild functions. For example, you can use this logic:

If IsNull*<Field-Name>) = 1 Then space(<Length of the Field>) Else <Field>.. This will work.

Regards
Amitava

Hi,

If your referenced data is high in volume then it is always better to use "Join" stage.

Regards
Amitava

They are mutually exclusive because DataStage will read Sequential file in sequential mode.. Row by Row.. Only one node will be used to read the entire file.

Regards
Amitava

Hi,

After defining a BuildOp, just click on the "Generate" button. Compilation will be done automatically.

Regards
Amitava

Hi,

You can use the "Upsert" feature of DataStage.

Regards
Amitava

Please look the OSH table definition of the input file. This should match with what you see by clicking the stage.

Regards
~Amitava

lory,

Use NVL function of Oracle in the select clause. It is best to handle null there.

Regards
~Amitava

ds_is_fun,

Set the APT_STRING_PADCHAR parameter to "space". You can do it from Administrator.

Regards
~Amitava

Hi,

The default date format in DataStage is yyyy-mm-dd.. But your input format is yyyymmdd. So you have to mention the input format as
"%yyyy%mm%dd" in the StringToDate function.

Regards
~Amitava

Hi,

What is the Partition logic you have used and what is the number of Node ?

Regards
~Amitava

Benny,

Are you sure a Null is there or Space ? For both of them you can use the following code,

If (IsNull(X) = 1 Or Trim(X) = "") Then <Action1> Else <Action2>

To check whether Null is coming or not you can use a Peek stage .

Regards
~Amitava

T42,

Please try to give your answer politely. Somebody may ask some basic question and if you have problem with those, then simply avoid them.

:D

Regards
~Amitava

LearnPX,

IsNull() function should work on character field. Sometime it may not work on number field. Then we need to sue NullToZero() function. Also sometime IsNull() = 0 does not work. So better to use IsNull()=1 or IsNotNull() = 1.

Regards
~Amitava

Hi,

First convert all the dates in Date datatype. i,e if the datatype of the dates are String then use DateToString function to convert into Date datatype. After that simply use

(If Date > Date1 And Date < Date2) Then <Action1> Else <Action2>..

It will work.

Regards
~Amitava