Search found 19 matches
- 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...
- 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...
- 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
- 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...