DSXchange

Thx, guys, I will check out the LastErr.

Hm... That gave me some idea. Thanks.

Hey, just wondering if anyone tried to extract the Oracle ORA-? Description within a server job during insert/update. I know it's found in run Log, but anyone has tried to do it within the job itself? The best I found it is the Code itself use the DBMSCODE in the Link Variable Outputs. But it is jus...

Haven't been here for awhile, but what happened to the searchable archive for all the tricks, tips and faq?

kduke wrote:All they want to do is help us become better developers with DataStage. Better developers should equate to happier customers. Right?

Right!

Just one word... BellSouth

No matter how good we are, they were not happy with what we did.

Not sure this would help performance wise, but I would design my job this way. So both files do not have match keys, I am assuming you are comparing the dates row by row. 1 row compare with 1 row. I would generate a new seq file and a hash file with generated keys (row 1 = key 1, etc). While I gener...

Yea, modification dsx is another way to modify all jobs at once if you know the specific item that you wish to change.

The Ascential guys told me to convert the remote directory location into an account. I'll see how that turn out.

Ray:
To answer you, it is streamed. Also, for some reason I am not seeing dictinoary D_hashname created on the remote directory when I use mkdbfile. I am using 7.1

After searching the forum, I found out that you can create the file dictionary content without coding by validating the job. So that is what I did, but I still can't get the selection tab in the hast file stage to be active.

Also, how I verify if the dict content is created by validating?

Any idea?

All: I researched a lot of people's post about mkdbfile, setfile, and hash file, but I got bits and piece of info. So I am posting to see if anyone can help me understand this a bit more so I can enable the selection tab in the hash stage for Remote Hash File without too much manual process. The bac...

Thanks for the input.

I was using the 7.1 designer and noticed that I got real time stages and have xml input output and transformer.

I never use them before, but can I use these stages to access an url to download files or they just convert xml codes?

Hi All: Been awhile since I have time to drop by, but I am back to get help where I know I will get one when I needed. :) The challenge is that I got a few csv seq files on an url. I can not get ftp access to them so I have to do it via http so anyone has any idea how to do this without using RTI we...

This is what I think you are trying to do: Record A1-1 A1-2 A1-3 A1-4 Record B1-1 B1-2 B1-3 B1-4 Record B2-1 B2-2 B2-3 B2-4 Record B3-1 B3-2 B3-3 B3-4 Record C1-1 C1-2 C1-3 C1-4 Into A1-1, A1-1, B1-1, B1-2, B1-3, B1-4, C1-1 A1-1, A1-1, B2-1, B2-2, B2-3, B2-4, C1-1 A1-1, A1-1, B3-1, B3-2, B3-3, B3-4,...

If not transform or routine for an over million row in DS, what else? Is there something option or way to able to call a rountine or function without it being called and cleaned up for each row? I can probably code a routine that actually process each row within that routinue, but that defeats the p...

Not an expert on licensing or multi-threading, but after an interesting interaction with Asc. about my company's licensing issue, I don't have an overall warm and fuzzy feeling toward Asc's licensing policy. In my opinion, I don't think someone should charge me extra for using the more powerful hard...