DSXchange

For the record, this poster did read history before starting this topic. This is why the original post was qualified with a 'without having to make a copy and compile'. Yep, for which I publicly showed I went back to my most recent reply, corrected myself (see EDIT), and even did the redfaced emoti...

Chapter 1 of the Administrator guide, section Permissions (page 1-17 in the version I have in front of me) covers this in detail, which is where the previous quote originated.

So, have you configured PX for Oracle? Is the Oracle client installed? What have you done? Was there an issue following the setup guides in your documentation? Can you post those error messages as well?

Yeah, you can't do 2 statements. It's fundamentally not the way it works. There's a tabular stream of data going into the ODBC stage, the SQL is then prepared. Your 2 statements don't work. The delete works because it doesn't care about the stream, the second works because it does. Together, it can'...

Document all of the configurations, from DSN's to tuning parms in UVCONFIG. Make sure any database client software is put back exactly. DS is the easy part, import all the job designs back into their respective projects. Any persistent hash files should have been backed up or moved somewhere safe, t...

Are you restoring the entire machine, or just selected directories? If reinstalling Windoze, you're going to need to install DS exactly the same way it was installed before, including the directory paths. That gets you back all the registry stuff. It's worth a stab at doing a full recovery and seein...

Yeah, but if you look here: m It's exactly what was needed. I don't like to give the easy answer or spoon feed people. Why post at all, why not give out phone numbers and voice answers? The history is here to be used. Our first answer to most questions that can solved via the Search facility should ...

hint hint

Per your DS documentation available to everyone under the Start button

Have you looked up the answer?

Per your DS documentation available to everyone under the Start button: When you first install DataStage, the Everyone group is assigned to the category DataStage Developer. This group contains all users, meaning that every user has full access to DataStage. When you change the user group assignment...

Check out the excellent search facilities on the forum. Here's one I found in about 15 seconds:

http://www.dsxchange.com/viewtopic.php? ... hlight=dsu

Two passive stages directly link have a hidden active stage. Putting an IPC stage between two passive stages will make a performance difference, but would only be measurable depending on the nature of the stages. Imagine a job like: SEQ --> XFM --> OCI. An IPC stage won't really make a difference, b...

A pseudo column: select 'I am not a real column' "NOT_REAL_COLUMN", max(primary_key) "MAX_KEY" from your_table" will return two columns of data: NOT_REAL_COLUMN and MAX_KEY in your result set. A pseudo column is a literally defined column that doesn't exist in the un...

Use a pseudo column with a literal value as the key in your select max query. Now do the lookup using the literal value.

The trick is to ICONV a date, then OCONV the date and verify that the same month comes back.

For fun, try 2-28, 2-29, 2-30, and 2-31. See what happens. Fun with dates!!!

Sorry Craig, but even I wouldn't try to do this. I know the three amigos go waaaay back to Prime/ARev/MickeyD box days, and would know how to do this. Everyone else would probably be trial and error. I'm sure you'd give it a good run.