DSXchange

You probably need an extra -l option in APT_LINKER_OPTIONS to refer to your shared object.

You could investigate dsexport.exe command.

There is nothing on the server.

Post the exact message. The variable is named. It may be a stage variable, it may be a column name. It may be a redundant reference to a column in a constraint expression or in a stage variable initialization expression. Find it (the variable name) in your job design.

Are you referring to the Key Expression on second (and subsequent) reference input links, or subsequent fields on the (only) reference input link? The latter do not need to change; they are not qualified by link name on the reference input link itself. However, some of your stage variable, constrain...

Welcome aboard. You have explored the entire range of tools - there is no general server-side import tool. The dsjob command, as you have noted, can only import job executables. The rest must be done from the client.

When you originally specified dsjob we understood that you meant to do this from the command line. Oconv() is not available at the command line. What you have done is appropriate within a DataStage job but, if you're going to do that, why incur the overhead of invoking dsjob command? There are perfe...

Thorough analysis, cogent design, comprehensive implementation. Identify all possible causes of warnings in the development phase (unit testing) and code to prevent their occurrence. Then, in production, any warnings that do occur are not the fault of the ETL process, and may be regarded as genuine ...

The log will contain any error message generated by the database server. This may or may not contain the name of a column. It may, for example, contain the name of the constraint that was violated. It's then up to you to examing the column values (also logged) to determine which value(s) caused the ...

ByteLen() is available. It may stay red (because it is not in DSParams file) but it will compile and it will run.

If Left(InLink.TheString,1) = '"' And Right(InLink.TheString,1) = '"' Then InLink.TheString[2,Len(InLink.TheString)-2] Else InLink.TheString You may choose to strip leading and trailing white space first, perhaps in a stage variable, if there is white space outside...

It is possible. Whether you can write the code to execute faster than that written by the experts depends on how good your programming skills are, and whether you can avoid some of the compromises they necessarily must take (for example you might only handle particular data types; they must accommod...

Sounds like you need to get your Oracle DBA on board, and maybe your network administrator as well, to find out whether it's Oracle that's raising the SIGPIPE signals and, if so, for what reason (for example unexpected delays). That Oshexecuter.sh has core dumped may indicate that something at the D...

What is different between the good and bad runs? Are there any before-job subroutines or different paths through job sequences involved where the environment settings might be changed? Look at the log event called "Environment variable settings..." for each kind of job. Try to elucidate where they m...

It depends (as always). If the grouping columns are supported by indexes, then it may well be faster to do it in the database. If you have sorted data, then it may be faster to use an Aggregator stage. Is the database local or remote? If remote, it may be better to aggregate in the database, because...

This is some new meaning of "superior", then?


Do you know what this port number is used for?