DSXchange

I've figured out the last problem..., a semicolon in the final of string...

thanks for your helping!!

meena wrote:Can you say me whether it is a DS job or sequencer.

sequencer

I've tried to use a command like that in functin DSExecute.
But the "|" doesn't work fine. It seems to execute only the first command.
example:

"ls | grep PBRCT"

It only execute the "ls"

Is there another function to do that?

thanks!

Hi! I have the following problem: In a directory I have many files to process, they have to begin with PBRCT*. To solve this problem, I've used a unix command (ls dir/PBRCT*) and then I mount a list to process each one of them: /xxx/xxxx/PBRCT.1.TXT;/xxx/xxxx/PBRCT.2.TXT and so on.. but, when I use ...

Hi all! Anyone knows if there's a limitation in Agreggator, cause, everytime in my job, when the number of records to agregate is greater than 4 million, the job is aborted... Message: "Abnormal termination of stage agregator_Job..Aggregator_0 detected". My job is simple.. SEQ FILE ------>...

Yes, I know that!

But my doubt is about the warning message..

When I am trying to create a hashed file in another directory , I am doing that: 1. mkdbfile <dir>/aaa.hash 2. setfile <dir>/aaa.hash But , when I execute the setfile commad , the following warning apears to me: The DICT file pathname <dir>/D_aaa.hash does not exist Pointer aaa.hash was established ...

I solved this problem using
. /1a01/datastage/Ascential/DataStage/DSEngine/dsenv

I'm trying to execute the mkdbfile command, but when I run it, that message appears: /.dshome or DSHOME environment variable is invalid or missing I already tried to configure that DSHOME, but without success... my command is in directory: /1a01/datastage/Ascential/DataStage/DSEngine/bin/mkdbfile An...

Hi! I am creating a 64BIT hashed file, following the steps of others topics... And i have these doubts about it.. 1. What is a VOC file and where can I learn about it?? 2. To modify a file to 64bit I used: "RESIZE hash_filename 18 3937501 1 64BIT" *What is the meaning of modulo: 3937501 ?

Thanks!

Anyone knows if there's a problem if my hashed file is greater than 2GB?

I hear something about it... Is it true? Or i can create hashed of any length...

I was with this problem of performance.

This problem happens when I do some search directly from databases.

To solve my problem , I put all my database that I need in hashed files before processing or sequencial file (depends for what I need)..

No DSGuru,

gateleys is right. That's I want to do...

I don't want use job parameteres...

I am trying do what he said at this moment!
thanks!

This is my problem: I have the following file(sequencial or hashed): cod: 1 2 3 And I need to do a select based on these numbers.. for instance: select * from table where cod = ? <cod> comes from my file (it's an index). and so, I will put these results in a file. How can I built somethig to do that...