DSXchange

I corrected that error. Now I have: #02:decimal[15,3]=decimal_from_decimal(#02); #03:decimal[15,3]=decimal_from_decimal(#03); #04:decimal[15,3]=decimal_from_decimal(#04); #05:decimal[15,3]=decimal_from_decimal(#05); #06:decimal[15,3]=decimal_from_decimal(#06); #07:decimal[15,3]=decimal_from_decimal(...

Morning / Afternoon / Evening folks I'm using the MODIFY operator to change 950 columns which are decimals at their source. The precision is decimal(31,3) whereas I need them in decimal(15,3) The syntax I'm using in the MODIFY stage is: #ZF:decimal(15,3]=#ZF; #ZG:decimal(15,3]=#ZG; #ZH:decimal(15,3]...

Morning / afternoon / evening ladies and gentlemen As stated in the subject line, I have a table of around 1000 values for a composite key. This looks somewhat like this: KEY1 KEY2 KEY3 COL VAL AAA BBB CCC A1 1 AAA BBB CCC A2 2 AAA BBB CCC A3 3 ... ... ... AAA BBB CCC A1000 1000 I need to pivot this...

I have this same issue. I need to use RCP since I'm using a generic job and thus my transformer has certain columns defined, i.e. those that I'm programming specifically. Over and above, I need to copy the columns present in the dataset and thus I select RCP. I get warnings for the columns not defin...

The environment variable APT_CONFIG is set to default.apt which is a file owned by the user dsadm. No I'm not passing APT_CONFIG_FILE to my job and thus the question of it being blank does not arise. However if I do pass it also at the job level and enumerate it to the same file (default.apt) along ...

Thanks for the replies guys. For further info. I'm NOT on a grid environment so that solution doesn't apply here. Ray - I'm not sure I quite understand what you mean. Its the same file with the same privileges. So how does defining it at job level make it easier for DataStahe to be aware of the valu...

My Datastage server has its apt.config file owned by the user 'root' which is not a member of the group dstage. I understand that this should not be the case and ideally the owner of this file should be a memebr of the dstage group. Thus an idea owner should be dsadm. From what I gathered from anoth...

Hello Paul

Thanks for your reply. however its not the parameter set I'm after but ONE parameter defined in the parameter set.

Any ideas?

Thanks again

Tony

Guys I have a parameter set with a big number of parameter sets. I also have around 500 jobs developed by someone else who has used some or all of these parameters all over the 500 jobs. Is there a way to find out where (which job) a particular parameter is used? I couldn't make much headway using t...

In case you are looking for the values that you've attributed to a parameter set you should be able to find them at: /opt/IBM/InformationServer/Server/Projects/<PROJECT_NAME>/ParameterSets/<PARAMETER SET NAME> This contains a flat file for each value file for the said parameter set. On my system thi...

I'll try the first solution definitely.

Reading as VarChar and using convert on one field for one file will result in me having to create one particular job for this file, whereas I'm using a generic job to validate 30 files each having its own schema file.

If you guys mean changing the Default collation locale for stages in the NLS tab for the local job's properties, I just tried that.

I changed it from Project (OFF) to fr_FR

Nothing changed though. The value is still read upto the 1st space.

No one?
Craig / Eric ? :p

Actually in this case the decimal separator is a dot. Don't ask why. Sometimes the French like to behave differently from the norm.

I guess I need to define an NLS locale just to signify a thousands' separator.

Morning / Afternoon / Evening all I'm going to bore you guys once again with the infamous schema file. Just when I thought I was getting the hang of it, voila, Datastage has just thrown me a curve ball. I basically have decimal values of 20 significant digits including 9 decimal places which I'm rea...