DSXchange

Hi. I have a question about jobs that contains multiple join stages and their partition... Actually, I have a PX job that contains 2 join stages (left outer join). I've set the partitionning on both stages to Hash... The first Join has 5 keys... Key1,Key2,Key3,Key4,Key5 on the two input links. I use...

Hi. Does anyone know what command are sent to the DB2 database when we use the DB2 UDB Enterprise stage with this setting: Write Method: Write Write Mode: Truncate Does it send an "Import Replace" command to DB2? Does it send a Delete statement?... Or an Import /dev/null? We want to reload...

Hi djoni. Well, first, you need to define the parameter (name and type) in the job properties. Second, you can pass the value of the parameter with the dsjob utility (at the prompt). dsjob -run -param param_name=param_value -param param_name=param_value... -wait project_name sequencer hope it helps

Hi r. Can we have a little bit more detail about your job... From what I know, I schema file is used by a Column Generator or a Row generator... I've never seen the option "Schema file" or "Schema" in a surrogate key generator... What looks like your mapping? Is Surrogate_Key_Gen...

Hi rgn_g. In the sequential file stage, there is an option named: "First Line is Column Names = False". Change it to True. And in the Format tab of this stage, you can specify which delimiter you want. You can choose "None", "Comma"... or you can even type it is the lis...

Hi ArndW

I am curious... I am currently looking at the column generator stage...

How do you define the constant value? Is there any option to specify the value?

Thanks in advance.
Mathieu

Hi
As far as I know, I think so...

But if your source is a database... maybe you could hardcode it into your SQL statement at the beginning...

You probably want to avoid the transformer stage for performance reason isn'it?

Hope it helps.
Mathieu

Hi,
What I am saying is if you input is something like '27292223455' (Varchar(15)), then you could define your variables as BigInt and convert it to a number by using the DecimalToString function...

Is this what you try to do? or if your input have the 2.72922e+11 format as well?

Mathieu

Why don't you use a real integer variable? You could convert your string input field to an integer by using the StringToDecimal function.

Mathieu

Hi... I think I know what you're saying now. You have a multiple set of records that contains detail records and one trailer record that resume the detail records of your set. And you want to validate that the trailer record summarized correctly the detail records... Then, to do so, I would use a tr...

Hi.
Sorry but, can u explain us exactly what sequence you want to verify... I'm not sure of what exactly you're trying to do???

Thanks

Hi.
In the server edition, look at the IConv and OConv option. With these 2 function, you can convert string to datastage date format. Look at the IConv's help for the format...

Mathieu.

U can use IsValid as well for number... it should work... but I never tried...

Hi. I think when you read an empty string, datastage does not replace the empty string by a Null... I think you'll have to check if Trim(Var) = '' then... For the amounts, the transformation should be like if trim(Var1) <> '' then if num(var1) = 1 then StringToDecimal(Var1) else null else null For d...

Hi. Make sure that your parameter is set to a Date data type. Also, make sure that the default format of your job is really %mm-%dd%yyyy.... If it still does not work after, try to pass a string data type... just to make sure that the parameter is well passed. I did the exact samething for a number....