DSXchange

Are you attempting to write to the table while still selecting from the same table? This can lead to a self-deadlatch situation.

Why DateToString()? There's nothing in the (implied) original specification that specifies a string type to be output - everything there suggests that the output column should be of type Date.

Is there a before/after stage/job subroutine that copies the file into place before the job moves a second set of records to it. What are the link row counts reported? You chose not to reveal this vital piece of information. In the parallel job it might occur, for example, if you used Entire partiti...

What's reported in the install.log file?

Will the indexes are also preserved if we backup the hash file by simply copying it from its source directory? Thanks in advance for the reply. Thanks, Pavan. Indexes will NOT be preserved. By default a hashed file does not have any indexes, so that's not a problem. If you have created index(es) yo...

vpauls wrote:Yes I have and I can when importing table metadata, but when trying to import stored procedure definitions it wants to have a dns and it isn't provided from the server.

/Elin

Thanks for your answer!!

Do you mean DNS (domain name server) or DSN (data source name)?

I can sense a DataStage (ODBC stage) enhancement request coming on. Who'd like to be first? There's a forum here for exactly that - all posts are forwarded to IBM, and we can guarantee that they are looked at there.

Check for null first. There is no ElsIf and there is no End If. Generate null using the SetNull() function - there is no "NULL constant".

Is the target column TIMESTAMP(6) ? Does the date format string for this column in your record schema include ".6" at the end?

There's nothing out of the box. Design your algorithm (incorporating your business rules, such as what happens if the date is January 31 and you add one month) and create a routine. Or get a database query to perform it.

The "why" is that, when Oracle is interrogated as to data types, it returns DECIMAL(38,10) for unbounded NUMBER types.

Did you search the forum? Some of the compilation of a job sequence takes place on the client machine. You may not have write permission there.

Welcome aboard. :D As far as Oracle is concerned, a DataStage job is just another client application. If the diagnosis is "connection dead" the only thing you can do is find out why. The Oracle driver has been successfully invoked by DataStage - you can tell by the square-bracketed entries in the er...

Why not just run this particular job with a warning limit of 1?