DSXchange

Wait for Hawk to be released, then update to Enterprise Edition, which includes BLOB support. Otherwise, process a reference to the BLOB and organize your own mechanism (such as one of the ones Ken described) for moving the BLOB when writing to target. Or uuencode the BLOB and move it (with some per...

Create validation stage variables of the kind If test Then " " Else "Column x is bad because..." Note that each has a space character if the column is good. To create a single message with all, simply concatenate these all together, then apply a Trim() function to reduce any extr...

Prevention is better than cure. "They" have allegedly made the deletion process more robust - the justification for removing the functionality. I believe it still exists under the DS.TOOLS menu, however. Even if it doesn't, the command that it used to drive is almost certainly still in the VOC file,...

Please post a separate thread about the OCI - it's unrelated to NLS, and kinda got buried in this post. The default is ISO8859-1 because that's what you (or someone) set it to be (in the Administrator client). ISO8859-1 should, in theory, be able to handle all Latin-based European characters (in par...

Your home directory must be a DataStage project, or your startup script must attach you to a project directory.

vm = VMARK - the original vendor
ds = DataStage
api = application programming interface

Hence vmdsapi.so - it's part of DataStage. Make sure its parent directory can be found in LD_LIBRARY_PATH (or SHLIB_PATH or LIBPATH, depending on your variety of UNIX) as set in the dsenv file.

Step 1 is to read the documentation for this stage. There's some in on-line help, there's some in the PDF (XMLPack_20_Designer.pdf, particularly Chapter 5). Then post any remaining questions that you might have.

You don't actually need to "fix" anything. It's just DataStage alerting you to the fact that you're running a configuration file that doesn't include a pool name of "export" so it's using the default pool (which must always exist) instead. It does not affect operation of your job. If you don't like ...

You could also use an External Filter stage and run the data through awk or sed (or any other stream editing command).

"Pad with null" is unfortunate terminology. It actually pads with the ASCII NUL character (0x00), which is different from null (unknown value). Since C recognizes 0x00 as "end of string", this default is entirely appropriate. If you've put space characters (0x20) into your string, they should be han...

chanthou_2000 wrote:i was thinking that DS PX was able to handle itself the "null" value for the sort stage, so i'm wondering where this error came from ?

If you were the Sort stage, how would you handle null? Can you be more specific about how you think that the Sort stage can handle null?

Exactly; the Sequential File stage is precisely the correct stage type to use. You will need to specify the format as fixed width. The best way to do this is to import the file's "table definition" and specify there that it's fixed width format and the width of each column. From the table definition...

It must generate rows of data that can be received, interpreted as one or more columns, and put onto the stage's output link. For example, I have created an External Source stage to get data out of a UniVerse table. It invoked a shell script that made sure environment variables were correctly set ch...

With the new common connectors, DataStage EE (in Hawk) has been extended to handle BLOBs. This support allows BLOBs to be moved from source to target without paying a huge performance penalty. Only a reference to the BLOB goes through DataStage; the BLOB is not actually moved until the target is wri...

This message suggests that you've used CHANGE_CODE more than once in the setup of your Change Apply stage. Check your work.