DSXchange

Hi I have the following setup on a parallel job: SEQ ---> TFM ---> XML OUTPUT The XML OUTPUT creates multiple XML files when the trigger column changes. This is good. I then add the MQ stage: SEQ ---> TFM ---> XML OUTPUT ---> MQ When the job is run and the recipient of the Q reads the data, the &quo...

Thanks for that advice. I tried the Folder stage and unfortunately it did not work sending the zipped file.

Well, after searching for related topics I found this http://www.dsxchange.com/viewtopic.php?p=361392#361392 I want to send a zip file to MQ but am struggling to define the source to the MQ stage. If it's a compressed file, what do I specify in the sequential stage for the metadata? (original file i...

You could always zip the XML. That would be binary. :wink: Man am I glad I found this! :D I want to send a zip file to MQ but am struggling to define the source to the MQ stage. If it's a compressed file, what do I specify in the sequential stage for the metadata? (original file is XML, but larger ...

Hi guys I was asked today if it was possible to comment within a constraint or derivation. The answer is of course no, but wouldn't it be nice to have /*comments inside the constraint or derivation */? How are you guys going about documenting complex derivations/constraints at the moment? Is the ann...

when importing the table defintion of a view where does the metadata come from? I ask because while importing the view definition column lengths far exceeded the column length on the table. The CAST being done within the view is also not as wide. Does Datastage go down to table level via the view de...

nope.. multi-category does not work. mutliple definitions in a category does though
seems its going to be a manual process.

thanks - but the multi-select as per windows is not working, unless i'm mistaken.
i'll try again..

Hi Over time our development environment table definition area has become quite messy, is there a way to delete multiple categories at once using for example command line utilities? On this point, what strategies do you guys follow (ones that work), to keeping the table definition house in order? th...

RESOLVED - turned out the dsenv and lib links weren't set up properly.

thanks - it's working now.
:D

Just researching an error i am getting: "Error loading "orchoracle": Could not load "orchoracle": Could not load module" In the previous response the reference to: probably you do not have the link for orchoracle in your library path $DSHOME/../PXEngine/lib I have check...

thanks Craig I'm not sure on the character set but the data is viewed fine via TOAD. the plot thickens.. We have now created a Server version of the job on the same server, used the same ODBC settings and the data reads fine. This is a workable workaround but now the question.. what is the differenc...

Hi Guys Today a colleague asked me to look into a job for her that (1) takes a flat file and loads using ODBC stage into an oracle database. This works fine, 100%, no errors, no warnings just the green green icons of success. The ODBC stage uses a defined DSN in the .odbc.ini file. 2 columns in the ...

Hi Had an interesting discussion today with a colleague around the best practice when reading a file that includes header, detail and trailer records. The question was "when i use 3 output links from the source file and pass each through a FILTER stage, am I reading the file 3 times?" I su...