DSXchange

Thanks Abhi.

That was the solution I adopted. It worked fine but...I still would like to know what's the cause of this situation ( besides bad development of course)

Regards
Ricardo

Hi guys! I'm facing a somewhat curious situation and I would like to know if someone ever faced this before. I have a very simple job: FlatFile ---------> OCI --------> FlatFile2 Inside the OCI stage, on Inputs, I'm declaring table XPTO with 2 columns and using pure insert: cod_x Char 2 dsc_x Char 5...

Hi ArndW. Thanks for your quick answer. I already knew that a large modulus takes more time because e pre-allocates disk space. But even knowing that doesn't help me explain why the link start with 500 rows/sec and almost at the end it bursts to 4000 droping in the end to 500 again. Correct me if I'...

Hi guys. I've been doing some searching (using the forum) on the best way to build hashed files and how to make their creation faster. I ran against some posts that explained the method to calculate the minimum modulus. I even used the Hashed File Calculator developed by Ray. I've been faced with a ...

Look at the bright side Craig. You also typed faster than I did... :D

Thanks guys.

Ricardo

Thanks Kenneth.

You've been a great help :D

Hi guys! I'm modifying a project in order to make it faster. In this project we have a DataStage Job built in a way that doesn't make much sense to me. That's why I would like to ask your opinion. The job is quite simple. ORAOCI ---------> FlatFile ----------> HashedFile When the job ends, the flat ...

Hi murali. There are several ways of doing what you ask. I think the easiest way is creating a file like this: param1=value1 param2=value2 etc... You can put the file in your file system. Then create a small script which receives a parameter and returns it's value. Then grab the value and pass it to...

Hi bandla.

If you try searching the forum you'll find many posts on this topic.

Here's a small clue on how to achieve what you wish:

Ans=OConv(IConv(<your_date>,"D DMY"),"D/YMD[4,Z,Z]")

Best regards
Ricardo

Hi,

Does your file have a separator character?

if it doesn't check the sizes of the columns that you are passing to DS.

they must match the size of the file.

Hope it helps

Ricardo Soeiro

I think that what chullet is trying to say is:

1.Activate the Filter command box.

2.Write in the box something like --> tail +2 <your input file name>

3. There is no 3....it's done :D

Hope it helps

Ricardo

I would use a very simple unix command:

tail +2 inFile > outFile

then pass the outFile to Datastage...

Hope it helps

Ricardo

I've got it. It's kind of strange but it has to do with my first line of the routine. Data=Trim(Data," ","B") I'm not sure but I think it does somenthing to the file (locks it somehow) and it freezes the job. I took it out and it worked nice. Thanx for all your help. Ricardo Soei...

The tmp_table is just a database table. The exact same DB than the final table. I havent tried with an hash file but I expect it should work.

Ricardo

Tony, I've already tried that. And the DBA told me trhere are no locks on the table. In fact when I change the job and load the file to a tmp table and, only after that, I use the routine it works just fine. The job only hangs when the input comes from a seq file. I'm confused. You say that you loa...