DSXchange

You can aggregate your sorted data on the key and choose "last" option for your date. This will function the same as a remove duplicate stage.

Quickest way to fix this problem is turn the trace off. You can do this by editing the .odbc.ini setting Trace=0 under [ODBC] category

I dont know why you'd want to install on HACMP, but if you do, the process on v8 is as follows: login to master node which should be pointing to node 1, change the hostname to nodeMaster using smit do a standard install of datastage as per documented instructions and then change hostname back to nod...

Try a type 1 hashed file. Key the hashed file as customer number and call the hashed file EXT/CUST

Had the same problem in UNIX and the notify stage which limits DS functionality. Needed to remove the linefeed so command now looks like:
Note that you have to change LF to something so a space ' ' is ok for 1 line of data.

You can simply use a sequential file stage in combo with a transformer. I'm assuming that this is a CSV file rather than fixed width. Either way you can use your transformer to constrain any rows that begin with the string SEPDI. i.e. DSLink.Type[1,5] <> 'SEPDI'

Nice one Craig, in one foul swoop, you've established yourself as the XML guru. I initialised the data element to XML and simply surrounded the output value in the transformer with the necessary strings i.e.

'<![CDATA[' : in.legal_name : ']]>'

Thanks for the reply.

We have a requirement to output XML in character only format as opposed to HTML markup e.g. 1) <legal_name>G&M NV</legal_name> instead of 2) <legal_name>G&M NV</legal_name> Our intention is to use a CDATA marked section to display the text verbatim. So the output looks something like: 3) <le...

That diagram is excellent. If you look at Chapter 7 of parjdev.pdf, it explains that the lookup file set creates one file for each partition. It follows that if you specify "entire" partitioning that you will get duplication. You must specify the key that the file will be lookup up on. I w...

Ok, but is your file set partiioned on your lookup key? Also, are you running with RCP?

I'm very sorry to hear that you've discovered the DB2/UDB Enterprise stage. Please forget about it, it will only cause you trouble. However, if you insist on using it, try to do so sparingly. The DB2/UDB Enterprise stage allows a parrallel partitioned load into your DB2. It is much quicker than your...

Did you compile your job after importing it?

Stage variables are non-nullable.

Babylon is nice this time of year.

Stopping and starting your datastage services will not necesserally unlock your jobs. This is because the datastage client server connect is persistent. What you need to do at UNIX is: netstat -na|grep 31538 This will tell you which processes are connected to the engine and what state they are in. I...