DSXchange

Are you using any hash files that exist on server 1 but not on server 2? How about a table definition?

Just a thought...

Aaron

First, this is a really great and (for me) timley thread - thanks to everyone who has chimed in and provided great information. Second, what are the down-sides to interprocess row buffering? Why would you not want it turned on at a project level? I understand the concept of what this is doing, I'm j...

Ray,

What standard practice would you recommend for purging log files? What is your best practice for this?

Thanks!

Aaron

Check the position column on your hash file table definition. The key columns i nthe hash file cannot have a value other than 0. This may be the cause of your issue.

Good luck!

Aaron

We use Version Control for promotion to QA and Prod. We also use Named Batches in this process. However, we only use named batches when it makes sense to do so. For example: We set up a named batch which includes all jobs necessary for a phased release of ETL. Once we have this named batch set up if...

Hello all,

Anyone have any ideas on how to properly move a version control project to a different server? We are moving our entire dev environment to a new server and need to move all DataStage projects (including Version control) to this new box.

Anyhelp would be great.

Thanks!

Aaron

All, I'm having issues setting permissions for my different users. It seems, no mater what I do, anyone has access to datastage jobs. I have set up the three NT groups as described in the admin guide, assigned the correct users to those groups and assigned the correct roles to the groups in Administ...

Its not a delimiter problem i reran the job with a dilimter that was not in the data "|" and it still failed. I havent seen the option of omit newline so im sure i didnt check it. like to know where it is though so that i can check to be certain. i dont think i have a <CR> or <LF> in the ...

Thanks for all the help! I like the poem.

--Aaron

All, Does the selection of 'Clear the table and Insert rows' in the ODBC stage send a Truncate statement to the DB or does it do somekind of Delete logic. I am working with my DBA to get appropriate rights for the user we will be using to run our jobs and this will make a difference. We run SQL Serv...

Dick,

Why don't you send me an email at aaronej@yahoo.com and I will forward you some documentation I have on this process. This may be the most helpful to you.

Thanks!

Aaron

OK, sorry for the confusion. All I really want to do it use an ODBC Stage to call a Stored Procedure which returns records and writes them to a sequential file for later processing.

Any help would be great. Again, sorry for any confusion.

Thanks!!!

Aaron

Can someone please help me with this? I am being told by Ascential support that calling a Stored Proc (SQLServer 2000) through an ODBC stage and returning data to a sequential file is NOT SUPPORTED. Can this possibly be true? Support told me that the only way Stored Procs are supported is if you are...

Can someone please help me with this? I am being told by Ascential support that calling a Stored Proc (SQLServer 2000) through and ODBC stage and returning data to a sequential file is NOT SUPPORTED. Can this possibly be true? Support told me that the only way Stored Procs are supported is if you ar...

Can someone please help me with this? I am being told by Ascential support that calling a Stored Proc (SQLServer 2000) through and ODBC stage and returning data to a sequential file is NOT SUPPORTED. Can this possibly be true? Support told me that the only way Stored Procs are supported is if you ar...