DSXchange

Thanks Craig!!
...The 2nd URL had what we were looking for.

Hi, We are in the process of upgrading from 7.5 to 8.0 and I was wondering if anyone knows of the minimum client hardware requirements for this version. IBM pointed me to www.ibm.com/support/docview/wss?uid+swg270089 but I could not get to the URL. The only piece I do know is the 2 gig RAM requireme...

Hi, We are currently in the procees of upgrading from 7.5 to 8.0 and we have some consultants working on a project that requires an all or none commit on a few tables on Mainframe DB2. I am aware that we can control this in a given stage by setting the Rows Per Transaction to zero. But is it possibl...

Looks like we had the wrong password from the DBA......working fine now...

Hi, We are attempting to use the MS SQL Server Load stage for the first time in our shop. I am running a simple test trying to load a 4 row text file into an SQL server table. Sequential file====>> Interprocess====>>MS SQL Server Load stage I receive the following warning when I run and don't know w...

What we are looking to do is load around 4 million records and would like to commit every 100,000 records or so.

Hi,
Currently in our designer the "Rows Per Transaction" tab only allows 4 digits(up to 9999). Is there any way to increase this.
Thanks - - John

Good Morning, I am just getting started on a project with a requirement to fail any job that doesn't get a match on a reference table. I currently have SQL using a UDB left outer join that would return nulls for any fields not found on the reference table(set this up before teh new requirement). I a...

Hi, One of teh developers just got this error in one of his jobs. Has anyone seen this before? Thanks - - John Detail..odbcDetail.DSLink2: DSD.BCIOpenR call to SQLExecDirect failed. Statement was:SELECT A.CNTRCT_NUM, B.CNTRCT_TYP_CD , A.ERF_PROC_YR, A.GEN_YR , 'MOVECOUT', A.IYB_AMT FROM NZ9X.DB_ERF_...

I don't think I was being clear......the initial problem was that my transaction log was filling up(Initial error in post). I had it enlarged and am trying to execute my datastage job with various combinations of "Rows per Transaction" and "Parameter array size" and now I keep ge...

The error we are actually getting once playing around with teh transaction handling is consitently"socket closed": Project:ALM (NJROS1BVA0302) Job name:ALM_Load_Int_Assmptn Event #:8 Timestamp:1/4/2008 1:42:36 PM Event type:Fatal User:PRUDENTIAL\X090842 Message: ALM_Load_Int_Assmptn..xfm.o...

Hi and Happy New Year to all!! I have a simple job which is loading 500K rows of data from a flat file to a UDB table using the following Sequential stage====> Transformer=====> ODBC STage Whe I initially ran, I receive the following error message: SQLSTATE=S1000, DBMS.CODE=-964 [DataStage][SQL Clie...

Thank You!!! that was it...I ended teh tablespaces and we are back in business!!

Hi. I am getting the following error for the first time when running a job that is simply loading data from a staging table to the target table...this job has been running for months in dev and we received this error for the first time this morning. Thanks - - John Project:PRS (NJROS1BVA0301) Job na...

Thank you for your input. A follow up question to your suggestion....
Can I do a similar type thing in a sequnce job to control job execution?