DSXchange

Howdy! What is the database engine for this? If it is SQL Server 2000, then you would need to give a parameter or something that would segment the data so each job isn't trying to process the same rows. Also, switch to user defined query mode and add 'WITH (NOLOCK)' after each table in the query (pr...

Hi all! One thing I would love to see is right-click capability with the mouse that is consistent with standard Windoze API functionality A N D to have it used consistently (I know, I used the word twice in the same sentence :oops: ) between all the stages in DataStage. Also, one more plug for getti...

:oops: It just dawned on me, MCDBA testing notwithstanding.... How is SQL Server running on Unix?? Do you actually mean that your server setup is as follows (trying to make sure I've understood your messages above): Source system: Mainframe DataStage Server: Server Edition running on Unix ??? Target...

Howdy! When you say 'scratch space', what exactly do you mean? If you mean you don't have enough room for all the files you are unloading or hashed files being created, then set up a directory structure on a different disk or set of disks and use parameters to refer to where you are creating your fi...

Hi again, I received a private email on this, but thought the response would be of benefit to others should this be their situation. Here is the text I was sent: Hi John I am trying to set up an environment where my target DB would be a SQL Server. Basically its a Windows Unix based Environment wher...

Howdy!

Some other things to check:
1. Make sure the OLEDB driver is registered properly
2. Make sure that the DSN is using the proper Ascential SQL Server Wire Protocol driver.

If you are sure you have access to the system, then these are my first suggestions.

Bestest!

Hi all, Samba stated that you could use the Dynamic RDBMS stage to insert data to SQL Server, but I have had no luck with this at all. I was told by a contractor that worked with us when we first got DataStage that particular stage could read data from SQL Server, but could not write to the database...

Hi all, Similar to Klaus' suggesting of cutting out certain fields to work with: Create multiple sequential files from the source putting only a hundred or so fields in each file along with the primary keys for those rows. Have one of the sequential files be the primary source for an insert to the t...

Hi Ken, Since Ray has already beaten us on seconding the second, then I'll just be the first to third it! Anyway, I'm looking forward to having you in Des Moines, IA with us next week. I've learned so much from your documentation and methodology documentation, and I'm hoping to drain your brain of m...

Hi all! Other things to check: 1. Target indexes - if you constantly move data into the target, then the indexes may need to be refreshed/rebuilt. 2. Source indexes - same as above 3. Index structures - if you are using user defined queries, make certain the database optimizer has one or more indexe...

Hi all,

Wouldn't the pivot stage work in this case as well?

Bestest!

Hi again, I did what Ray suggested and then tried to recreate the problem she is having and ended up with the same problem. So then, I created an entirely different project and tried to write the same job from the ground up (Src --> xfm --> Tgt with no transforms - just a straight pull). We even bui...

I found it!! Amazing what a little digging will do - preferably before opening mouth and moving feet freely! I ran the command and it showed lots of information that appeared positive. I am testing the stuff now to see if we have the same problem. I will post again if I have any more troubles. Thank...

Hi Ray, Thanks for the response. I must confess to some ignorance yet as to where certain things are and how to perform command functions. Where would I find the Administrator Client Command window? I wish I had an administrator to go to, but I know more than he does at this point as he has only rec...

Hi all, If I remember right the '*=' notation is not supported per se in SQL Server 2000. It still functions only for backwards compatibility purposes, but I believe I read (somewhere) that notation is not supported in SQL Server 2005. Many things that existed for backwards compatibility have been d...