DSXchange

The internal connection that is usually established is the one supporting the localuv data source (and implicitly the system variables @HENV, @HDBC and @HSTMT). It should be unrelated to telnet, as it uses BCI and UCI as its interfaces. It would be affected if the dsrpcd daemon were not running, but...

Beware that the DataStage data browser manifests the kind of behaviour that Ken described, for exactly the same reason; it's driven by the metadata definitions. Always check with a different tool, such as sqlplus or TOAD, when you suspect that some rounding is happening; the DataStage "rounding" is ...

In the Columns grid in the Sequential File stage, scroll to the right and find the properties "contains line terminators" and "incomplete column". Read the help on this stage type, and experiment with various settings until your file becomes readable.

Try doing the SQLBindCol call before the SQLExecute, so that there is information in the statement environment about which variable is to be bound to the result column.

You can also get this behaviour if the source file is accessed through a Sequential File stage with the "first line is column headers" property set.

I recently worked at a site that renamed the exiting export file, then exported. They rely on nightly Windows backups if they ever need to go back more that two nights. They've never needed to thus far.

Beware that quoted arguments may have their quotes stripped. Search the forum for examples.

DSD.BCIxxxx function names are from the BASIC SQL Client Interface library. I was as surprised to you to see them from the DRS when the access protocol was specified as "Oracle"; my understanding was that it uses the OCI in such cases. Hmm... You can find more about BCI by searching this forum, part...

... or you have have your UNIX administrator explain it to you. Forcefully!

No, it's an Americanism: "nouning" verbs and "verbing" nouns is a trait primarily encountered between the North Atlantic and Pacific oceans.
Ostensibly this is in the interests of efficient language. I disagree, and feel that they abase the language.

Does it handle CITY = "NEW YORK" ?

Yes, UPDATE. No, not DB2, Oracle, through Dynamic Relational Stage. Interestingly, even though the access protocol was set to Oracle the error message came from the BCI. DetectClaimFileFormatErrors..ProcessError0040.Count0040: DSD.BCIPut call to SQLExecute failed. SQL statement:UPDATE "hfFileFo...

Ascential bought the company called Vality that wrote the tool called INTEGRITY. That tool has now been incorporated into the Ascential product suite and is called QualityStage. There are essentially four phases to data cleansing: investigation (find out what's there, which can be character-based, w...

DataStage is perfectly happy to work with a non-logging Informix database. However, the warning that Informix generates to alert you to the fact is detected by DataStage and logged accordingly - the message coming out if Informix has "warning" severity, and there's unfortunately nothing you can do a...

Probably the easiest is to use remote execution (rexec), remote shell (rsh or remsh) or remote login (rlogin), depending on which of these your UNIX administrator allows. Check, too, whether the Windows-based scheduler has any of its own functions for invoking programs on other systems. If so, it ma...