Search found 19 matches

by datastageETL
Tue Aug 18, 2009 12:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exporting Project
Replies: 13
Views: 5198

Exporting Project

Hi All, I am using the command to export my project for back up purposes. E:\apps\IBM\InformationServer\Clients\Classic\dscmdexport.exe /H=AMRNWLW121 /U=username /P=password PROD E:\Tools\Backup\Prod.dsx user - username is set up as a super operator I can run this script manually or through vbs file...
by datastageETL
Thu Aug 13, 2009 10:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Access violation on phantom job
Replies: 10
Views: 4523

Re: Access violation on phantom job

Just for others information - I solved this issue by changing the entire sql statements in the AfterSQL to a stored procedure. What we noticed was that after 33 lines of sql statements, the job is being aborted with Access violation message. I am not sure if this is a limitation with 8.1 but the sam...
by datastageETL
Thu Aug 13, 2009 9:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Access violation on phantom job
Replies: 10
Views: 4523

Re: Access violation on phantom job

thanks for your quick response
by datastageETL
Thu Aug 13, 2009 8:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Access violation on phantom job
Replies: 10
Views: 4523

Re: Access violation on phantom job

were you able to solve this issue? I am performing exactly the same like you did. Imported jobs from 7.5 to 8.1 My job gets the data from Oracle using OCI connects and inserts into SQL Server using DRS. After the insert is done, I have many update statements in the AfterSQL which are run. It is duri...