DSXchange

Or link a standalone Transformer to it to perform the Clear. Create a stage variable so it will compile, use the proper metadata (doesn't matter what's in the derivation, I use @NULL) set the constraint to @FALSE and enable the 'Clear' option. It will run first and clear the hashed file.

Actually, I gave a specific example for that. Format Cells, Number, Custom. Scroll through the 'Type' list to see all of the ones there by default, manually add one if need be. The '0' means you want to preserve any leading zeroes in that position. So if I type in '123' but I need it to be '000123' ...

1. Yes, that is exactly the difference.

2. Possible, probably yes. Good idea? No.

1. Yes, the default type of hashed file is a 'Dynamic' or Type 30 hashed file. It is stored in a directory of the same name with the three files you've noted. Of course, there are other 'static' types as well but the vast majority of what you do will be with dynamic hashed files. 2. That depends. If...

Did it work? There's nothing magic or different about DataStage, a query is still a query. If you can make it work there, it will work here.

Excellent! Now you just need to mark the post as 'Resolved'.

Honestly, no, I've never heard or seen that term before.

Can you post the entire quote and let us know where you found it?

Sam Ting.

np

The SP2 patch is for problems with Sequence jobs, not the DRS stage. Are you the only one having this problem? If so, I'd suggest you completely uninstall the DataStage client and then re-install it. And by 'completely', I mean with extreme prejudice: 1) Uninstall. 2) Remove any leftover Directories...

For example:

http://www-306.ibm.com/software/data/u2 ... ry/96univ/

My assumption was the leading zeroes are significant and the target field was thus some flavor of a string field. I have that 'problem' all the time with Excel, the 'business' supplies data in spreadsheets and the values should be something like '003287', but Excel will drop the leading zeroes unles...

More better link:

http://www-306.ibm.com/software/data/conf/overview.html

Change the column's format to Text or use a custom mask to force Excel to preserve the leading zeroes: '000000' for a six digit number, for example.

Time. Dimension. Seriously.