DSXchange

Some UNIXes do care.

Welcome aboard. The first thing you need to know is that this is an all-volunteer forum; people post as and when they can, without being paid. If you need urgent help, you should sign up with your support provider for premium service - we're not here to do "urgent". Secondly, no doubt you have been ...

You still have not reported what the value of the Stmt variable was. Also, what was logged as the "status of SQL" message? Note that you need to call SQLError() to remove information from the handle even if the status is SQL.SUCCESS.WITH.INFO - that is, you still have a "dirty handle" even if it's o...

My years of experience indicate that there are productivity benefits to being well organized. Joining the dots ought to be easier with IBM Information Server, since the business glossary and database design tool (e.g Rational Architect) share the same metadata repository. For earlier releases I can'...

There are two adjacent slash characters in the pathname. My guess is that you are using a job parameter for the directory path of the Data Set control file, have a trailing slash on the value supplied for it, and a slash between the job parameter reference and DataSet.ds in the File property of your...

All zero bits is an invalid representation of a decimal data type, unless you explicitly permit it. This may be what has happened in your case. Try disabling operator combination to be certain that a Compare stage has generated this message.

C++ only.

However, the C++ routine could be an interlude that calls something that you may already have written in C.

You need a DEFFUN declaration for each of the routines that you wish to call. Search the forum or consult the DataStage BASIC manual for more information.

That's correct. The first. Absolutely the first. Oracle reports the first error and stops. You fix the first, Oracle will then report the next, and stop. And so on.

Most database servers, and most application development tools (possibly except compilers) behave in this fashion.

... because, if there's any '&' in your data, the data type must be Char or VarChar, and so will be quoted in the VALUES clause.

1. A table in a Word document titled "source to target mapping" or, ideally, "target from source mapping". 2. It depends on the site. Where available, MetaStage's automatic notification process. Otherwise documented internal processes. 3. Rigorous application of the "thou shalt not modify table defi...

UNIX would consider a raw ampersand to be a special character in the shell (to start a background process), but I am unaware that Oracle uses the ampersand character, particularly in a VALUES clause, in which it would be in a quoted string, as anything special. Would you care to elaborate on what yo...

I haven't used the Oracle driver since version 1.7. Back then you used to have to run a script to rebuild its library. Is that still the case? You can read about it in the readme files in and under the branded_odbc directory.

Good so far. What precisely was the SQL statement - that is, the value of the Stmt variable - when this error occurred? And to what kind of data base is the connection being made (e.g. UniVerse, Oracle, Informix...)?

JoshGeorge, the expired license will give a different error message.

Have you searched the forum? Both your questions have been answered previously. When an OCI stage has an input link Array size is the number of rows sent to Oracle at a time. Transaction size and rows/transaction are the number of rows sent before a COMMIT is sent. One of them (I can't remember whic...