DSXchange

I'm guessing here that multiple "spreadsheets" actually means multiple "worksheets" all in a single spreadsheet. While you can read something like that, I don't believe you can write natively to one... other than as separate .csv or .prn files as noted.

Could be wrong.

Ah... that explains why the one I found called "errorlog" was empty. Figured everything was perfect.

You'll need to better explain your issue. "Not available"? "unable to execute? OK... why? What problem / error do you get?

There's errors for 4 jobs mentioned above. And corruption doesn't need to affect all jobs.

Field().

Sounds like your Project has been corrupted, a Very Bad Thing. Any disk problems or space issues where DataStage or the projects are installed?

Typically it means Not Compiled or Already Running. It would guess it is the latter and that you need to check again for that.

You should be able to match that in the job, I believe, that or trim off the 'extra' milliseconds. 2008-09-04 07:57:00.000 would not overflow.

Thought that one would nag you like that. For better or for worse, Oracle doesn't care.

First question is always going to be - did you search here for that message? Did none of the matches found help you out?

craviraj wrote:I have handled 2 and 3 by using convert(varchar(50),<FieldName>)

If that is the DataStage convert() function that's not how it is used.

For the 'SQL Varient' can you cast it to its base data type in the select?

SQL Server includes milliseconds from what little I know. What is the actual target data type for that field in the table itself?

That domain doesn't look correct. See this thread for what I believe you need to do, including the port number. Yes, it's for dsjob rather than dscmdexport but it still applies as far as I know: http://www.dsxchange.com/viewtopic.php?t=128912 And this post for the definition: http://www.dsxchange.co...

To do this inside a DataStage job, you'd need to purchase the Java PACK as far as I know, which would give you a "Java Transformer".

Check the records that did not get inserted, see what the timestamps look like on those records. Use a reject link to capture them if need be, write the timestamp to a varchar there.