DSXchange

Great thanks Ray!

I've now purchased the premium membership and as i don't know when it will become available to my dsaccount I cannot read your entire post just yet. However its impossible that some of these files have valid jobs since the oldest job (run/compiled) i can find is from februari and some files are from...

I am trying to run the command (changed #Project# and #JobName# to actual values and tried it in the unix prompt) ../../DSEngine/bin/dsjob -report #Project# #JobName# XML >./KimD/#JobName#.xml I am sure that i am typing the correct names and using the correct caps, but i recieve the following messag...

Hi, I browsing through the project folder on our produktion machine and i am seeing thousands of job directories that hasn't been run for over a year. We recently removed alot of unused jobs using manager but i am afraid that the RT_LOGSxxxx, RT_BPxxxx, RT_BPxxxx.O, RT_CONFIGxxxx, DS_TEMPxxxx. I wis...

In the log there will be a short message after you reset saying from previous run ... doubleclick on it and paste the response here. It may contain the reason for failure. Maybe you are using some pre-job routine or custom made code in jobcontrol....

The problem here is that you are probably partitioning you target table based on the identity column, hence the parallel engine will try to partition your input stream based on the same. And since that column is not present in the input stream any partitioning is impossible. The solution to your pro...

one way to do this is to add an transformer before your seqential file stage and convert all columns to one column with fixed length and pad each field and then concatenate them togheter and within that stage add two new records first in your output and than a trailer record at the end. When you've ...

i think the general recommendation is 1 node per core, so if you have 4 dual core cpu you should run with 8 nodes config. However it all depends on your job design and hardware support...

should work with decimaltostring and the supress_zero command, but you need to put in in quotes as in the example given by datastage... Furthermore if you use trim you need to convert the decimal to string first. so if the zeros are not remove when using decimaltostring the shhould be removed by tri...

Shouldn't you really do is to check if the string itself is ok, not convert it and then check it. That will fail because the date is not valid... Youre doing it in the wrong order. First check and if it is ok then you can convert it. You need to change your format on the string ... from your format ...

Shouldn't you really do is to check if the string itself is ok, not convert it and then check it. That will fail because the date is not valid... Youre doing it in the wrong order. First check and if it is ok then you can convert it. You need to change your format on the string ... from your format ...

if your string is formatet 20070101 then you need to specify that format in StringToDate(InLink.DateCol1, '%yyyy%mm%dd')

You cant do parrallel insert or load to a source table if your source table has the partition key as a sequnce number which you generate at insert... Datastage will try to partition on the same column its missing (hence your error message). So it can only run in sequncial. If your partitiong key is ...

in your example the negation mark (-) is at the end of the string. Try flipping it to the front of the string, or just remove it and add if after conversion via a mathematical function

you need to trim your input string and/or remove/change any unwanted characters.... Maybe your decimal point is invalid for example....