DSXchange

Sorry for digressing. Have you checked your SQL Server documentation for native code 11? The SQL code 01000 denotes a warning in SQL server, if I recall correctly.

Unfortunately HACMP does not continue the job or session.

Actually, it looks like you are getting an Oracle abort and you should check the log file. The warnng on date conversion results in a null result. You can avoid that warning by implementing IsValid() in your transform stage.

ray.wurlod wrote:

chulett wrote:Define "not working" please.

Another word for "not working" is unemployed

Some people define "not working" as being an IT consultant. Actually the full line should be "Not working, but being paid for it."

bobyon, please take a look at your uvconfig file. I've noticed that the MFILES setting at 8.0.1 defaults to 12 - a ridiculously low number. If you have several jobs running and several users developing the system will quickly use up all 12 file units and start "swapping" them. In our devel...

So you entered the UNIX command "/opt/SUNWspro/bin/CC -dalign -O -PIC -librar=iostream -c test.cpp" and created a object file. The object file needs to be linked and then it can be bound into a job and exectued.

Buffering is always a tradeoff - by increasing the buffer sizes you also increase throughput but, in the case of failure, you will lose more data. Since DataStage jobs generally are all-or-nothing there is no benefit in force-writing data more frequently. But if you do require more frequent flushing...

None of those three directories are in the runtime "LIB" path, which explains your error message. Now you need to figure out why your LIB variable is so small. I don't have a Windows installation, but perhaps someone here who does could post their LIB environment value.

We have the HACMP setup this way. Our transactions are processed from (and to) MQ; once a system fails and switches to another DataStage server we can continue where we left off because of the way we use MQ for transactions. In other implementations the running job would abort and, depending on how ...

Umm, just checked the routine. Change to

Accessing SAP isn't normally done through hashed files; so I don't know how to answer your question.

the search function really is your friend.

I used it to find this thread which goes into both V7 and V8 options.

Yes, the square brackets probably prevent parsing of the -fix option.

This is just normal Command Prompt 101 stuff that I guess more and more people have absolutely no clue about having grown up in a completely GUI world. [sigh] You said exactly what I have been thinking! Standard shell (and DOS "CMD" is a shell) knowledge should be a prerequisite of any ty...

ascen, you just replied to a thread that has been dead for over 2 years. And I don't understand how what you did post applies to median calculations?