DSXchange

In most databases use of reserved words is prohibited. DataStage tries to conform to SQL CAE Access Group standards, where use of reserved words is likewise prohibited. There are two possibilities. One is to use quoted identifiers - to enclose the column names in double quote characters. The other i...

Can you do a DESCRIBE on each table so as to see what differences there are "natively" as it were? There has to have been something that caused the importer to behave differently.

Were you to ask your support provider, you would be informed that Windows XP is not a supported platform for DataStage server. Since it works on one machine and not on another, the obvious question to ask is what's different between the two machines? Re-installing the client may be worth attempting....

Only the ODBC and UV stage types have this option.

Time to mark the thread as Resolved?

By what mechanism is your Windows machine working with UNIX files? For example are they mounted via Samba or some similar utility? Somewhere in there the permissions are not right. It could be the authentication to the UNIX machine, it could be the file system permissions on the UNIX machine. You ha...

Kim Duke's free ETLstats package collects information into a database table, which you can then query to your heart's content.

Yes, you really should start a different thread. Please do so.

The short answer is to have DataStage (or some other utility such as sed) pre-process the file so that each pair of lines becomes one.

Also check ODBC.H in the include folder for DataStage Engine. This decodes the data type codes; for example -9 represents SQL.WVARCHAR (which one assumes to be "wide VarChar", or NVarChar: different vendors use different terminology). Negative numbers in this list represent unsupported data types. T...

Imagine, for a moment, that you are not using DataStage, but need to read parameter values from a file to supply to some other application. How would you go about that? The answer for DataStage is pretty much the same. In a job sequence you would do whatever it is you plan to do to read the file, an...

You can certainly write subroutines. If the header or trailer is simple enough you could also use one of the supplied subroutines to use a command such as echo with a redirection operator to append to the file. In such a job design you would, of course, need to set the Sequential File stage to appen...

...it throws an err. plz help What is "an err"? Did you mean "an error"? That, alone, is insufficient information to attempt a diagnosis. Please post the exact text of the error that is thrown. Perhaps, for example, you have not licensed these components. The adverb you sought for your final senten...

Whale got a SIGSEGV, not a SIGBUS signal.

Are source and target both OCI stages? Was the table definition imported via the OCI plug-in for both or was one, perhaps, imported via ODBC?

7.5x2 is a special release. It is not the same as 7.5.2.

No. But you can have multiple switch values directing onto the same output link. However I suspect a Switch construct (whether in C or in the stage) would not be all that efficient with tens of thousands of discrete values. Prefer a Filter or Transformer stage, in either of which you can specify com...