DSXchange

Another thing to consider with the hashed file is that it has an upper limit. If you are processing 10 million rows into a hashed file with 150 columns per row, depending on the size of the data, you could be shooting yourself in the foot. Are you using a dynamic hashed file specification? If so, ma...

Just a thought: in your database structure, are there any foreign keys assigned against your TRAN_ID? If so, then CASCADING DELETES had to have been defined if RI is enabled (for most RDBMS's anyway). The error message about not being able to delete the row due to FK issues may not be making it back...

In Matt's case I have simply used the Dynamic RDBMS Stage to connect to the SQL Server instance I need, set it for User-Defined SQL and issue an 'exec sp_whatever'. The connection is already created by DS so I don't have to worry about passing authentication to the server.

To fire off a DSJOB run statement, I believe you also have to have your 'dsenv' set, which can be set in a script. What I would do is to create a script that runs the job correctly on machine B and once it works from there, then you can use a remote connection to just fire off that script as an isol...

Hopefully, my comments here are not going to start a 'flame war' because that is not the intent. I do want to get some information for clarification of who the parties are involved in this thread (ray.wurlod, ArndW, and ag_ram). You have Ray Wurlod, who has 28,143 posts (at this moment in time) to t...

Since the is SQL Server 2000, I don't have ALTER SESSION available to (at least not that I know of or can find in the documentation). I think the main problem is that I don't have a way of setting the required values on both sides of the connection. I can do it locally, but that doesn't account for ...

Is there a way in DataStage to issue a SET ANSI_NULLS ON & SET ANSI_WARNINGS ON before the processing of my job? I would assume that if it is possible, I would then just do the same thing to reverse the settings.

Is this possible?

Thanks in advance!

Thanks, Ken. I will give that a try and let you know what I find.

Hi all! I am finding myself in need of your expertice again. Here is my situation: I am trying to speed up my data transfer process as it's performance is sub-par. Currently have have the following steps set up as individual jobs: Step 1 - Pulls source data keys plus binary_checksum(*) for each row ...

I agree with Ken that most likely it will not work. If you want to try it, open your .dsx file with your favorite text editor and look at the header for the file (if the structure for v8 has not changed then what I put here should be available). The end of the header should have a line that begins w...

Please pardon my ignorance, but is it wise to replace a quote character with a 'nul' character (not NULL). I believe I heard Ray comment on that once and wanted to make sure I understand for my education as well. Are you doing the replacemant a Transformer Stage in a derivation or something else? Yo...

Well, it was worth a shot. You probably do need the NLS stuff enabled then, but I'm clueless there.

Toodles!

If I remember IBM's hype about the Ascential purchase correctly, the whole purpose of the acquisition was to add a top-tier ETL tool to their databasing arsenal. Top-tier (IMHO) means top three or four products in the market based on functionality, quality, usability and ROI. I have a white paper on...

Does the sequential file you wrote to have headers in it? If so, then you need to skip the first line (or stop the headers from being created). Also, is that value the only value in the file or are there more pieces of information. One more thing to consider is how your code that creates this file i...

What datatypes are these fields defined as in your mapping? They should be something like 'NVarChar' to allow for the expanded ASCII characters. In all honesty, I don't have a system set up with NLS enabled, so I can't speak to whether this suggestion is worth it's salt at all. Hopefully, that helps...