HPL and blobs down a pipeline?
Posted in 2012
Hi Folks, I have to move around a terabyte of a blobby table (not TEXT or BYTE) to another machine. I'm trying without success to make the HPL emit the blobs into the pipeline stream but getting nowhere. The source does not have enough space for the local /tmp/blob*.* file HPL wants to use. The local "rules" deny allowing an NFS mount between the machines so I can't go there. The "Ext Type String" and similar types seem to /sound/ like they should go inline, but it's not happening. If I use the "Ext Type String Length" with a Fixed ASCII format, then the length is written in, but the /tmp file is still created. The slightly-inadequate HPL user guide seems to suggest that each blob should end up in a "variable length" part at the end of each fixed-length record, but it just ain't happening. What am I missing? Can it be done?
Ping? Is Jack Parker around?...