DSXchange

Hi, In our company, we have Dev, QC, and PROD environments for ETL. PROD is the only environment that is scheduled. QA is manually run by the developers based on the jobs they need to kick off. They do a prod data restore onto QC database before running their fixes. We are facing challenges in ETL t...

This is how we have defined and from your response it looks like it will be 1 when success
D:\APPS\Ascential\DataStage\Engine\bin\dsjob -file d:\bmc_jobs\login Stateromsvr -run -jobstatus -param pmEnvironment="PROD" Production RunProc

Hi All, I have a server job in which an ODBC stage is calling a SQL Server Stored Procedure. This job is scheduled thru BMC scheduler. The job runs fine while the BMC shows it as a failure. Looks like the return code is an issue. What would be the return code from the DS job in this case. Currently ...

There could be several reasons why a job hangs. Do you have all your metadata defined correctly, have all the necessary insert/update permissions on the target table, Is your data violating any unique key constraints. I would try to insert one record in the target table manually using SQL and see wh...

Contuinuation to the above, I would imagine the job would abort with the kind of warning mentioned above. It Didnt. I checked with our DBA and he believes there is nothing wrong on the Database side, may be the datastage application isnt responding properly. Any ideas if we need to contact Ascential...

Unfortunately our DBA are busy, but meanwhile i had a similar situation where I got this warning today morning. SQL statement:UPDATE dbo.Product SET Name = ?, ProductKey = ?, TypeId = ?, ReqNotes = ?, UpdateDate = ?, InsertDate = ? WHERE (Id = ?) SQLSTATE=23000, DBMS.CODE=547 [DataStage][SQL Client]...

Thanks for the response. Even I am confused as I never had this issue anytime in the past. I dont see anyone esle accessing that table for any other purpose. I would touch base with our DBA and see if he can give any inputs. Am i correct in assuming that if we try to insert a duplicate into an Uniqu...

Hi, Job is trying to Insert or Update rows based on a Flag I or U. One of the fields on Target table(SQLSERVER) is unique, though thats not a Pkey. When we get duplicates on this field, I expected the job to abort. Instead the job hangs and I can also see a lock on the table. ODBC stage IsolationLev...

I am working on the points you mentioned. Thanks Guru, I will let you know once this is fixed.

Thanks,

1 A AA Start 2 B BB R1 3 C CC R2 4 C DD R3 5 A AA Start 6 B BB R1 7 C CC R2 8 A AA Start 9 B BB R1 10 C CC R2 11 D DD R3 12 A AA Start .... So on I am looking for 1 A,B,c,D,AA,BB,CC,DD 5 A,B,C,AA,BB,CC 8,A,B,C,D,AA,BB,CC,DD I am working on it yet. I am thinking of taking 'Start' as the base. Any inp...

Non Printable characters like this can be handled using OCONV with MCP and MCN options...

RowCount = DSGetLinkInfo(hJob, StageName, LinkName, DSJ.LINKROWCOUNT)

and for the second part you can use a stage variable to store current and previous values.If the current value is greater than the Previous value then store the currect value to the stage variable.

How are you reading these XML files ? Are you using RTI stages or a sequential file

Looks like its running out of disk space.