DSXchange

Well... there's probably fewer people here that are familiar with QS than you might think, especially in version 8. I'll be the first to admit that I, for one, know jack about it. As in squat. Zip, zilch, nada. You'll either need to (continue to) be patient and see if anyone can help or if it's real...

Hmmm. What operating system you gots?

(sorry, couldn't resist)

Hmmm. What operating system you gots?

Those are shared memory segments, not processes. Assuming a standard itag installation such as yours, you should be able to find them with this:


Still curious what you see when you grep all processes for client connections?

Ray has explained the difference between the two in the past but I don't remember the gory details, just that it reinforced my decision to not use it.

Please mark your issue as Resolved using the green button at the top of the screen.

ps. However, that error is a little bit of a wild goose chase as you don't seem to have a reserved word problem but rather a syntax problem that makes it think you have a reserved word issue.

(remove the comma after the :12)

No clue, but I avoid that particular function and use the 'operators' instead - square brackets. So, Field[1,20] would get the first 20 characters. Perhaps they will work more better on your gigantic field?

You can google for ORA errors as well as I can, I'd wager. For example:

http://www.techonthenet.com/oracle/errors/ora01747.php

In that case, a search for "All available licenses in use" should answer your questions.

Try it without the quotes, or with the quotes around the entire list not each individual filename. One of the two should work, I would think.

I honestly don't know how to do timestamp math in PX. I was just hoping to lay the groundwork with some basic questions so that when the PX people who actually use the product and know what they're doing wander by, they can get right to work. You may end up needing to break the date from the time an...

OK, so your columns and parameter markers match in quantity and order, and you've marked the correct one as a Key. Structurally it's fine, so we're down to just bad column names for the tables involved. Post the actual unedited ORA error message so we have some clue what "x" it is complaining about.

So... you've added a new field in a transformer for the result of this calculation and made it Numeric 10. What is your derivation? What are the datatypes of the fields used?

Subtracting two timestamps would give you the difference in seconds, so you'd need to multiply the result by 60 and decide how to handle any fractions. What have you tried so far and what happened when you tried it?

This really isn't all that difficult.

Please post your exact unedited sql and a list of the columns defined in the OCI stage - in order. And make sure you Disable Smilies when you do.