DSXchange

You can't send a space to a DATE field.

If the field is required, you need to send it some kind of legitimate date, even if it's one that represents "no date". You need to find out what they are expecting... usually it's something like '9999-12-31'.

The SQL did NOT give an error while executed through TOAD and SQLPLUS. It wouldn't... or I should say shouldn't. This is an issue with OCI. I'm guessing Ray just wanted to make sure your SQL was correct and that there wasn't another issue lurking here. I am using ORACLE 8i and in that the fields ar...

The question still remains - specifically, how are they defined in Oracle? In DataStage? Heck, what version of Oracle are you connecting to? For example, if the column in Oracle is defined as a NUMBER, rather than say NUMBER(12), you can't define it with a size of 38 as you might expect. You need to...

This post, while kind of long, addresses your issue. I've linked you to the second page so you can skip the first few acts of the play, scroll down until you find Ken Bland's reply about how to properly populate date fields in DB2. You might also want to post your transforms in their entirety, as t...

The simplest way is to have two output links with the appropriate metadata and write these two record types to two different files. Then, after job, issue a 'cat' command to stitch them together.

Double-check everything, as those are the patented answers to this problem. What kind of problematic fields are included in your table? NUMBER? LONG? Perhaps if you listed the Oracle fields and how you have them defined in DataStage, people could help spot the problem child.

Are there any logs in datastage in which we can know which user deleted those jobs. And it makes me wonder if there is, any situation in which jobs can be deleted by datastage automatically. I'm pretty sure the answers to both of your questions are 'No'. I don't recall any kind of situation where D...

You might want to post the error in its entirety, that may help. I would guess that either one server has NLS installed and the other doesn't or they are not setup with the same code page.

Oh, come on Tony. Not feeling very punny today, eh?

Oh... 'Data' is your input parameter? Remember that parameters are passed by reference, not value so you really shouldn't manipulate them in the routine itself. Use a different local variable for the result of the trim and reference it later on, then you'll be ok. NewData=Trim(Data," "...

There are a couple of 'Built-In' Transforms you can look at to get some ideas:

MONTH.FIRST
MONTH.LAST

Both use ConvertMonth(), you could either leverage one of these or write something new to do what you need.

You need to 'LOGTO UV' before the command will work.

Out of curiousity, where did you find them?

By 'highlight' do you mean you want it to be bold ? I don't believe that you have any control over that, but that doesn't mean it can't be done. You may be able to embed the control characters that tell Notes to do that. Of course, you'd need to know what to embed... and if that would even work... i...

No problem. Glad you got it working for you!