DSXchange

JoshGeorge wrote:APT_DEFAULT_TRANSPORT_BLOCK_SIZE need to be set to the double of maximum possible message size that is expected

Just curious...What could be the maximum value we can set for this variable?

Can you tell me how to do that in sqlloader? I do not have idea on it..Thanks...

I have a requirement to read a zip file and load in to a BLOB data type field in Oracle DB...Any ideas to do this is really appreciated...

verify the table definition in DB2 for your field...

Have you tried importing without the executables?..i haven't tried this yet..

1. Remove dup stage will work with Same partition if you intended to remove the duplicates based on the key fields you mentioned in link sort. similarly for Join stage also... 2. why don't open the stages and verfiy it? 3. Stable sort - if you want to preserve previously sorted data sets you can go ...

ray.wurlod wrote:The pathname needs to be quoted - Windows O/S thinks the "/" is a switch. ...

Thanks Ray. Its all because of Space in between the -x and the diratory path. I just gave space in between them and i got the output.

Thanks for your time.

Thanks,
Veera

Execute the below command in Unix prompt od -x /DirPath/HshFileName/DATA.30 | head -1 Will give you the following result 0000000 acef 010c 0000 001e 0000 0000 0000 0001 The bold word shows it is a 32 bit hashed file . If it is 64 bit hashed file it will show 020c , insted of 010c Hi all, Sorry to a...

Of course Craig. Actually, I've removed that parameter and hard coded the value too. But still didnt get that. And when i removed the parameter and i compiled the job, I can compile it. But after compilation when i looked into Job Control the parameter name was there. I dont know how... Kindly give ...

Code -3 can only mean what is says - that the parameter name used in the DSSetParam() call is a name that does not exist in the attached job. It may be a mis-spelling, it may be incorrectly cased, it ... I've checked it Ray. Everything is fine. I mean the Case and spelling. What might be the cause ...

chulett wrote:You get this where? Is this a Sequence job or your own job control or ...? Also note there's no reason to "set" a parameter using an environment variable, it will inherit it automatically. That ...

It's a sequence job Craig!!!!!!!

Hi all, I'm facing an error. Kindly let me know how to handle this. This is my error JobContro[@Execute_Job]:Controller Problem : Error Calling DSSetParam[$OS_DBSCHEMANAME],code = -3 [ParamName does not reference a known parameter of the job] Though i've declared all the parameters for that job, i'm...

chulett wrote:Nothing to be sorry about, part of the learning experience of transforms versus routines. I'm sure there's a "full Wurlod" on the subject here somewhere. ...

Ofcourse craig. Anyways, Thanks for your kindful reply. I'm happy about that now.

Again, you have not explained what "not being showed" means. Transforms trump routines so you need to look under DS Transform rather than DS Routine, is that your issue? ... Yes craig. I'm really very sorry. The routine was not being displayed in the derivation. As you said its available ...

chulett wrote:It's already compiled. Sorry, but I don't undestand what "but not in the column derivation" means. Do you mean via the ellipsis (...)? ...

No. When i tried to use that function in the column derivation of the transformer, its not being showed. Could you explain,why?