DSXchange

Slave.

As noted, the software is on the Client cdrom. If you have a later version of DataStage (7.5.x I believe) it will be an option on the autorun menu along with all the other choices. Earlier versions made you 'browse' the cdrom to find the Version Control directory and then you'd double-click on setup...

You don't find it, you just use it.

Sometimes it just doesn't matter. I asked a similar question a couple of years ago. NUMBER(6) would allow six digits max. I think that may mean 6 total including decimals, so you could have 4 before the decimal and 2 after, but not more than 6 total. No, not really. NUMBER(6) is syntactically identi...

Bastardo!

Not in 7.x at all, not sure about 8.x but I doubt it.

If I knew for sure I would have told you. At this point just fishing for more information so more smarter people (hopefully) find it easier to help you.

Sheesh, no other takers? Ok, I'll try again. What are the two formats expected by SQL Server and Informix? How different are they? Perhaps another generic attempt using varchar and a custom routine that formats the date appropriately? Pass in the date string and database type, pass back out what is ...

Apples and Oranges. The XML parsing is Java under the covers (Xerces based, IIRC) and not all that speedy. Be happy with your 9 minutes, there is plenty of 'logic' involved.

him121 wrote:My idea is, is it beacause of Job Logs. If that is the case I have cleared all the logs also.

Nope. I've seen this when internal resources are gone, lock table fills, fun stuff like that. Unless you've got an advanced degree in 'Universe' internals, do as Ray suggests.

No idea, really. What's different between the two environments?

Not sure, as I've never installed two different versions of Version Control, let alone mixed Windows and UNIX flavors. It will depend on how it handles the registry, I would think, more than likely only the second (most recent) install would function correctly. Why would you need to do that? Typical...

fk4u wrote:While checking Plugins Installation guide i come to know that oracle oci 8i plugin is not supported with linux.

I find that hard to believe. Please cite the text where it states that.

Answered in the other thread you hijacked.

Yuck... Fully Generated. You don't need to switch to User Defined, but to the other generation option, whatever it is called in your version (the name changed): 'Column Generated' or the ever so long 'Generate SELECT list clause from column list; enter other clauses'. You'll be fine there using the ...