DSXchange

richdhan wrote:In which case how would I define the metadata of the target hash file.

I'd suggest building your complete formatted output record and then putting it in the hash as a single "data" field of a fixed length.

Why would you "not believe" in the UNIX date? Which ones are you checking? I'd suggest (assuming dynamic hash) dropping into the hash directory and checking the dates on the DATA.30 and OVER.30 files themselves.

Phillip, this is exactly what Ken told you to do last week in your first post with this question. No 'OConv' needed as the DB2 stage expects the date in internal format.

You need to remove the terminators before you land the data. Probably the simplest way is to use the Ereplace function to either turn them into spaces or remove them all together. Depending on if you are removing LFs or CR/LF pairs (or whatever), you could do it a couple of different ways: EReplace...

I would think there should be some way of calling multiple statements in a transformer derivation. I would be surprised if I cant. Surprise! You can't. At least not in the derivation directly. If you need to do something like that - create a custom routine and, as I said, pass back out the value yo...

I would like to call a function as well as pass a value through at the same time. You can't, at least not like that. What does your function do?? Can you modify it so that one of the input arguments is the value you want to "pass through" and return that as the Ans? Either that or let us know what ...

Hold it in a Stage Variable and only increment it under the same conditions that you use to pass out a row.

Sure, it's just more fun. FWIW, I usually do your "Single Supplier" scenario in one job, making use of multiple streams and aggregators to produce the individual files and then cat them together after job. What I've done in the past for your other situation is to stage intermediate results into a Ha...

Not really. I've seen times where it would say that it was starting and then nothing. The outermost Status view would not change, still showing the last successful run stats, but inside you'd see the new starting info and then nothing. That was a bug, apparently. This... Are you managing your Phanto...

Did you find a solution as well, or just the problem?

Well, you could write a simple job to read from a sequential file and write to your hash. Build the file with as many records as you wanted to load.

You marked this as Server but posted it where PX questions are normally posted, so I'll answer from a Server standpoint. No clue if the answer changes for PX. Simply mark the file as "Fixed Width" in the Sequential File stage and tell it that "Line Termination" style is "none". It will then use your...

Is this like... a quiz, Kim?

The other classic problem you are running into is trying to use different sets of columns in the same link, which is only an issue when you switch to User Defined SQL. If you have 18 columns defined in your link, you must have parameter markers for all 18 columns in the SQL statement. If you need to...

They've added something. Now I'm wondering if this problem may be specific to HP/UX. I'd be curious if anyone out there is using 7.5 on UNIX platforms (HP or otherwise) and is not having or did not have any problems with sendmail? Did you need to do anything different with this version to get it to ...