DSXchange

From what I've seen, 'normally' it's either loaded from a spreadsheet or there's a stored procedure of some kind that generates the data.

I've just recently had to figure out the same thing, thanks for posting that so we all know now and I can safely forget again.

Please mark this post as Resolved using the button at the top of the page.

Oddly enough, that is documented. On the off chance that you need more specific help than that, what database(s) are we talking about here?

Fixing the problem with your job would be a Resolution, dropping the constraint falls squarely into the "work around" category, IMHO. Not to mention something that wouldn't fly in most shops. If it does there, more power to you.

The documentation installs with the client. You should have a Web Services Pack Guide pdf available to you as the place you should start.

For that you will need multiple source stages and some way to homogenize the data before you funnel it all together... unless your file struture will support multiple record types.

Then it would seem your column metadata in the stage don't match what the SQL is delivering. I've done this without issue in Oracle but I have no clue if DB2 adds any 'special restrictions' to this process.

In my first post, I took your intention to "connect to the database" quite literally rather than thinking you meant running a sqlplus session from the command line. There are a whole suite of BCI (BASIC Call Interface) functions for connecting to and running sql from external databases and...

Is the only difference the space after the "IN" verb? No, that makes no difference, both are equally valid.

We know. If you enable the "Disable Smilies" option in that post, that would fix that.

That's an odd 'conversion'. Is your installation NLS enabled? What is your default characterset in both environments?

Of course a union would require the same number (and type) of output fields between all of the sql statements, that's how it works. Can you pad them out so they all are similar, selecting NULL or "" or 0 for the 'missing' columns? And no, loading the sql from a file won't make any differen...

Then perhaps there's another constraint or you aren't really sending the "6" that you think you are. Any chance it's something silly like a "6 " coming in?

Error checking command line sqlplus sessions is always problematical if you've never done it before. Even when you get the syntax correct and things work normally, you need to be able to detect and handle the "abby-normal" things that can and will happen.

But, i want to know which is the cause for this ERROR!! Any idea :idea: :?: You violated a check constraint, nothing more and nothing less. Talk to your DBA if that is still unclear for some reason. You need to know what check the constraint is enforcing before you'll have a clue what the actual &q...

Or you can do that. Still falls into the "ugh" category for me.