DSXchange

chulett

We are using autosys here. When we try to say -param $myparam=2007-04-15 autosys subsitutes '' for $myparam because he can't find $myparam in his env. Just curious, did you try something like: -param '$myparam=2007-04-15' or -param \$myparam=2007-04-15 So that the dollar sign passes as a literal?

chulett

Now change the sql to look like this:

Code: Select all

select owner, sum(bytes) from dba_segments 
where owner = ?
group by owner;

And put 'ACCT_HIST' as the value of the Key Expression in the lookup link. This assumes you only have these two columns defined in the ODBC stage.

chulett

Welcome to the Dark Side! Have a cookie.

chulett

Because Oracle dates carry time information with them.

chulett

The square brackets:

Code: Select all

YourField[1,28]

chulett

Yes, you do. Search the forums for 'DEFFUN' for many examples. I believe there is a FAQ as well on the subject.

chulett

And the xsd for your target file? Or a sample of the desired output?

chulett

Perhaps something as simple as 'hard-coding' two dates one day apart onto the front of the times to create complete timestamps to compare?

chulett

I would guess your XPath expressions are no good, can you post them?

chulett

First suggestion would be to search for your error message "Fault type is 11" and see if that helps.

chulett

What's wrong with 80-90% CPU utilization on a server? An idle CPU is a wasted CPU.

chulett

How is upgrading 'not possible'? Those initial 7.x versions were quite buggy and you are missing out on a number of cool things in 7.5 and up.

chulett

You could always define it in the Administrator if you want it set for all jobs. Or set it to $ENV there and specifically override it in your single job.

chulett

Two columns - a hard-coded key value and then count_val as your single data column.

chulett

No question asked.

However, you did manage to say "Deployment without using Director" three times. Great.

Search found 42189 matches