DSXchange

Normally I would say no, but since something is clearly wrong it wouldn't hurt to rerun the Oracle client installation to see if that corrects your environment.

Probably better suited to the 'matches' function.

Do you have an Oracle client installed on that server? Note that I specifically said "client" and not "drivers".

Search the forums here for "ETLStats".

Show us examples of your input and your desired output.

I would change it if I had any idea what to put there.

i am passing file name in sequential file and its not liking it i just want to test it before passing parameters /aa/test/latestfile=$(ls *.csv | sort -nt_ -k2.1,2.6 | tail -1) What does this mean? If this is what you put in the Sequential File stage as the filename, you can't do any such thing. Wh...

Start someplace like here:

http://www.oracle.com/technetwork/middl ... index.html

Learn to love ELT and PL/SQL.

Well, what the heck does "not liking it" mean?

I would wager your fate is squarely in the hands of your DBAs for this one.

Andy has already explained how to do that.

Seriously, how can you expect anyone to know your secret rules on how to generate that output? It's nice that you posted what you need it to look like but you also need to explain in words the business rules / methodology you've been given to get there - don't make people guess or have to puzzle it ...

No, it cannot if the goal is to pass the output of the routine into the job as a job parameter value.

No, pretty sure those are both client connection related processes, and I'm sure someone will come along to correct me if I'm remembering wrong.

Those are client connections.