DSXchange

Can you please paste all yellow and red messages? This isn't enough information, but the indications are malformed SQL. Is this custom SQL? Have you tested the SQL outside of DS? Do any rows return, meaning does the job run for awhile and then have issues?

It's up to you, technically it all works. If you are just writing a single isolated process, do what you want. If you are designing an ETL standard, then you need to factor in performance, restartability, scalability, maintainabilty, etc as well as setting the path for all other developers to follow...

Try again and instead of project Production try "uv", the administrator account. If you can connect there, then your userid has permission to use the telnet session on the server. Methinks your userid doesn't have permission.

Add a transformer with a constraint check on the key columns. Add an additional output link to a sequential file to catch any rows with null primary key values.

Dynamically growing a hashed file adds overhead, which impedes the flow of data from the database. Writing to a sequential file allows the database to spool as quickly as possible. In turn, reading the sequential file into a hashed file allows the file to populate as quickly as possible. I actually ...

In your client installation directory on your PC.

My opinion is that ELT is just a sales gimmick. Saying ETL is dead is like Bill Gates announcing the end of Unix back in 1986. Yeah, got that one right Billy. One major pitfall with ELT processing is that all hard-core activities occur within the database. Sunopsis sells this as a major advantage, b...

Are you saying you don't like FEB, but want Feb? Try adding OCONV(..., "MCT") for title case, but if that doesn't work you could always substring lowercase the right 2 digits of the month.

Any DOS-level command can be executed using a Command stage or thru a subroutine, function, or Batch job using the DSExecute API.

Look at the columns defined as the primary key. These are the columns that are used in the WHERE clause. If your SQL is valid, these your loading method should work. By not using the primary key column in the SQL, you will leave the row to the database for choosing what to do with it. Choosing Updat...

When access to DataStage suddenly disappears, the obvious thing to do is see if everyone else is still able to connect. If so, then you've probably either unplugged your network cable or your capslock is on. Or, your IP address for the server was controlled via DHCP and it is now reassigned. Since y...

If you state the database of choice, then it will be as simple as using the command line interface to that database. For example, Oracle has sqlplus which can take a .sql script name as an argument on the command line. By generating a .sql script dynamically, you can invoke sqlplus to execute the .s...

Do you have a specific question, or are you asking if someone has developed something similar that you would like to obtain?

Consider building the "Ans" result as a text string during development. When you run the test button, you'll be able to double-click on the results and see a verbase description of results. When finished, change the derivation for "Ans" to just return the appropriate result.

The "load balancing" issue is a tricky question. Is the poster asking for the ability to control and arbitrarily shift cpu resources around, or are they simply wanting to keep one set of processes from hogging the machine. I guessed the poster wanted to be able to "halve" the machine based on the "e...