DSXchange

This one usually means that the value being passed into the INSERT via a parameter marker doesn't fit. For example you're trying to insert 15 characters into a Char(10) column, a number larger than 64K into a SmallInt, or something like that. Either make the column wider, or have your ETL job trunca...

Congratulations to the Bland family on the recent arrival of their new baby (noted buried in one of the posts in this Forum).
:D

When a CASE construct is compiled it generates exactly the same code as the equivalent nested IF construct. I expect, therefore, if your conversion is exact, that you will still get the same result. And, thus, will need to re-examine your actual logic. Only the first CASE in a CASE construct for whi...

Typing in incomplete dsjob commands generates a usage syntax. For example, try dsjob alone, and dsjob -run.

I have implemented many of these in BASIC, and it's NOT necessary to leave the controlling job running indefinitely. In fact, in every single site where I've done this, the job runs until 23:30 and shuts down. It is scheduled to re-start at 23:45 (subject to other control factors) and can be started...

Yes.

dsjob began life as an example of how to use the DataStage C API.

Check it out in Server Job Developer's Guide.

... but only with dots!

The EREPLACE function (or its approximate equivalent, CHANGE) can be used in an expression. For example: EREPLACE(TheLongString, CHAR(13):CHAR(10), " ", -1, 0) In this example, I've replaced each CRLF pair with a single space. A TRIM function could be used to reduce...

The two dates, whether from different sources or the same source, must be in compatible format. It does not matter what this format is, provided that it is compatible! You do need to be aware, however, of implicit conversion, for example if you set the Data Element to Date and you use an ODBC stage.

It is always unwise to release locks unless you know it's safe to do so. Why do you think they are there? Being unable to export a locked component is expected behaviour; the component is potentially in the middle of being changed. It is only safe to UNLOCK the lock if you can be 100% certain that t...

There's nothing really different than passing parameters to one shell script from another. Put them on the command line in the caller, and refer to $1, $2 and so on in the called script. One minor gotcha (search the archives of this Forum) is that ExecSH or DSExecute has been known to strip quotes.

Nah, it was just that there were a lot of them in today's reading. The pint sounds like a nice idea though! Mine's a Guinness.

Hi, How can I find out the number of rows present in a hash file Can any body help me out in this:?: Thanks in advance Girish Oak Use the Administrator client's Command window, or a telnet session. Execute either of the following commands. COUNT hashedfilename SELECT COUNT(*) FROM hashedfil...

Can folks please learn correct English? In particular, can you be more careful with "ITS" (versus "IT'S") and "LOOSE". It's "it's" only when it's "it is", otherwise it's "its" (with no apostrophe) when it's a possessive pronoun. "Lose" and "loose" are very different verbs. Please consult dictionary.

Did you also purchase DataStage XE/390? This provides you with a similar design paradigm, but instead of generating BASIC programs to be run on the DataStage server, it generates COBOL (and JCL for compiling and running it). Thus all processing can be done in the OS/390 environment. DataStage XE/390...