DSXchange

The copy of DataStage I'm currently using does not have an Ortacle stage. But it sounds like it orta.

I think you'd need to parameterize the StartLoop properties.

If these APIs are exposed as Oracle functions or stored procedures, then the answer is yes out of the box.

If it's a C-callable API, then the answer is yes but only via customization - either a parallel routine invoked from a Transformer stage or a user-written stage type.

If you read the other posts on this "issue" you may be aware that the complete specification has not been given. There are MORE rules that invalidate all our suggestions. The other rules prohibit adjacent (and leading and trailing) otherwise-allowable non-alphanumeric characters. But, we argue, we a...

While it looks like an assertion, it was actually a guess based on experience - and I have not had any experience with version 7.5.2. So it may indeed be a '7.5.2 versus The World' kind of thing.

You also need to have your business rule documented - where is the "century pivot"? Read about date format strings, particularly "%2000yy". Do you have the other date components? Is your source data type a string or a date?

Search the forum for a post on using uvbackup command to determine whether any of the Repository tables is corrupted. If they are not, then you can safely proceed with the reindexing. If they are, then your recovery process will be a lot tougher - it may be worth deleting the project then restoring ...

If you don't have statistics how can you assert that "it reduces performance a lot"?!

Depending on the data volumes it may be better (easier) to use a server job.

Are you sure that the server routine's functionality could not be migrated to a parallel routine or BuildOp stage?

So your non-reject links lead into other stage types that process them, while your Otherwise/Log link leads somewhere (a Sequential File stage perhaps, or a Copy stage with no outputs) where nothing happens. Or, if you simply want to discard these input rows, have no Otherwise/Log and no Reject link...

Yes, in fact that's the property I meant. (I don't have access to DS at the moment.)

Must've re-booted...

Does this mean that this thread is now resolved? If so, please mark it thus.

1) The Peek stage has properties that determine how many rows will be logged. Amend these. 2) This job may have had only its executables exported, so that the import will have no design-time information. Or it may be that the job has become corrupted. If you have an export of the job design, try imp...

It loads generically. Visit the Layout tab in your table definition, and choose one of the other formats. Level will not be displayed - though it's always stored, because that is an accurate description of what was imported. Or you can right click on the Columns grid and choose Properties from the m...

That message says that DataTypePicS9 is being sought as a user-written routine, with a DSU prefix. But SDK routines are not cataloged with a DSU prefix. Thus, if you want to invoke the SDK routine your routine will require an appropriate DEFFUN declaration. Note also that Transforms can not be invok...

All of the 81xxx codes relate to the RPC mechanism. Using your Administrator client command window, or a telnet connection to DataStage on the server, execute the following command. Note that the error codes must be six digits. SELECT * FROM SYS.MESSAGE WHERE @ID = '081015'; Identifiers are case sen...