DSXchange

It's a key, it must be unique. Repeating rows with the same key will overwrite.

Make sure to source dsenv first.

Split your jobs into two separate jobs. One is just database to a sequential file and then run it. You will see the performance pulling the data. Then, have the second job read that file and send the rows to the database. Now you'll see how fast rows can load using your given DML.

What are the stages (ODBC, OCI, database please) and can you view data (connections are proper) and what is the SQL action?

Your script should source the dsenv file. Put ". ./opt/dsadm/DataStage/DSEngine/dsenv" above the dsjob line to get the environment variables loaded.

There is a maximum number of characters the GUI will display, something quite large. You probably have a row with a column thousands of characters wide.

What is the error message when running this command.

There are plenty of examples on the forum, use the Search facility.

I suggest you look at the code for ExecSH and copy it to a new Routine, modify it to behave as you desire, and then use your new one.

I can't tell but a I am assuming you are using a single quote, a double quote, and then a single quote in the statement. What your statement is doing is if the first nine characters of link column DSLink12.F1 is the text "QUOTECHAR" then append your quote to that entire link column value, otherwise ...

Ahhh, an enterprise scheduler would be handy to coordinate things.

You really can't just copy, because you have to find all of the files installed everywhere, such as the engine directories, project directories, and startup directories, etc. Then, there's the gotchas with internal files in the engine holding specific values that indicate the server on which it's in...

Not really. There's row counts and then there's file sizes. I think you're probably more interested in filesize. The easiest way is to peep the project folder and use a shell script to get the file size listings. The issue is the correlation to the job name via the job number. There's no supported m...

The table or partitions being loaded have some exclusive lock on them. Maybe there's an open SELECT processing or a previous INSERT/UPDATE/DELETE/TRUNCATE command is still processing. You'll have to get a DBA to look at the situation with the table. DIRECT path requires exclusive access to a table o...

For our friends down under, he was a popular guy here in the states as well. As my wife said this morning, he went out doing exactly the thing he loved doing.