DSXchange

Hi,
I see no real reason for this.
are you having no lookup found and your output converts null values to | ?
or perhaps outputing a fixed width file with| as the pad character?

maybe more detailed info regarding this issue might help

IHTH,

Hi, My cheep solution is having a central job control that runs all jobs and hold encripted passwords for all DBs required. any change of them means changing that job and promoting it indeed, but nothing else - no other job needs any change. the mentioned job naturally also get the parameters list f...

Hi, I can't recall if it was already asked for so here goes: I wish..... we could define special objects as share able between projects. large organizations tend to have several projects yet implement the same business rules. having several source codes of the same routine in several projects is a p...

Hi,
You got the idea, I think SQLServer also has the ability to update 1 table with a join to another one.
I just can't remember the syntax it was about 2 years ago.

ask your DBAs or check with the help.

IHTH,

Ray has premenition abilities explains why some refer to us as meer mortals when comparing to him guess after my last sig they'll use sane people when comparing to me just in case I'll change it in the future: recent thoughts: (talk about imagination...) January 10th 2010 DSXchange sumIT featuring R...

Chances are by the time your rechecking all is well so try the uv -admin -start again, you should be fine.

won't hurt checking for zombie phantom jobs in case you had any abnormal terminations.

oops forgot no they are not relevant you need to check for *.dsrpc entries

Hi, was already posted in previous posts. read the manuals for more insight. if there are active connections dsrpcd will not restart till they are removed. sometimes there is a 5-10 minute timeout for client connections (check using netstat | grep dsrpc) a good practice is always bring ds service do...

Hi,
I don't have the code for Iconv, but it can be tested.
though it might not get priority you might want to ask your support for official behaviour.
I'm not sure one was ever posted.

If you do get an oficial reply please post it so others might benefit.

IHTH,

Hi,
It seems the engine decided that it must repartition to get the job done for some reason.
In order to give a reason we'll need more info regarding the job design.

hmm, version 6 still doesn't have restartable fomr fialour point capabilities so you might need to use control job to get it done.

IHTH,

Hi,
did you sort acording to the stage requirments?
look in the help for it.

_________________
Vignesh.

"Choose a job you love, and you will never have to work a day in your life

I guess that's part of why some people turn to the sex industry as well j/k )

Hi,
Do they have a forum like this one? (must have a weight in my opinion )

Hi,
If my memory serves me this discution was already covered, search for it.

by the way what is the scale of this large volume?

Hi, there should not be one that I'm aware of. this might be caused by environment or precision issues. Take a look at the ../branded_odbc directory (form you dshome directory) there should be text file regarding all kinds of ODBC problems and work-arounds, you might find something there. IHTH,

Hi, Not 100% sure but your table might not be parallel load able, does it run sequentially with upsert mode (run sequentially = in the DBstage execution mode pick the sequential option). check with you DBAs they can have this info and might even shed light on why you'r getting this as well in case i...