DSXchange

Hi all,

I have an aborted job due to this error:

" Exception raised in GCI subroutine:
Access violation. "

Is this an ETL tool error?
Does anyone have encountered this before? How can I prevent this?

thanks,
Susan

Here here What DS does is great, but very primitive in the coding department. In fact notepad is better to edit in than the DS windows. The ability to set break points, step code and trace variables would also be huge productivity enhancements as are available just about everywhere else these days. ...

Hi All, It is essential that we have a proper code editor or IDE in DataStage for Routines and Job Control if we are to cut development time for large projects. The current built-in editor of DataStage is little better than Notepad. We need something with formatting, syntax checking and aware of sys...

Larry, We find that is helpful when migrating ETL code between Environments. (Not just the jobs, but the dependencies like routines, etc.) Specifically, we have dates where we move code from Development to Test or From Test to Production. We also store all our production code in the Version Controll...

Theres a lot to it, Larry, but from a high level, Version Control: 1) Helps manage and keep track of all your DataStage related assets (jobs, routines, tabledefs, etc.) 2) Keeps them ordered, which at its simplest, saves you if you have to go back to an older copy of a job or transform [because it w...

Thanks Sara, that did it! Now if only I could figure out what Version Control is really good for! Larry -----Original Message----- From: Sara Kessler [mailto:sara.kessler@osioutsourcing.com] Sent: Wednesday, June 12, 2002 12:27 PM To: datastage-users@oliver.com Subject: RE: Version Control Project I...

You can change the "VersionProject" value with REGEDIT. The PATH is: HKEY_CURRENT_USERSoftwarePMVERSIONDefault Ben "Sara Kessler" cc: (bcc: Benoit Murray/MTL/DMR/CA) Subject: RE: Version Control Project 06-12-2002 14:26 Please respond to datastage-users I had the same problem. I fixed it by using th...

Larry, Create the repository project for Version first, then when you start Version mistype the password and it will take you to the standard DataStage login, at which point you can select another project. Version Control sets the default project in its login to the last one you use so it will remem...

I had the same problem. I fixed it by using the wrong password at the logon screen. That brought up the full logon screen that you get with other DataStage products. From there, you can select the correct project. -----Original Message----- From: Bos, Larry E [mailto:lebos@sandia.gov] Sent: Wednesda...

Does anyone know how to get Version Control to use a different project for its repository? The first time I started Version Control, I mistakenly selected the wrong project and see no way to get it to use my VERSION project. Thanks all. Larry Larry E. Bos Sandia National Laboratories Albuquerque, NM...

Also try recompiling the job after clearing status and re-running it. It helps sometimes. Thanks! Komal >>> lreichel@psu.edu 06/12/02 09:15AM >>> In the Director, highlight the batch name and click on "job" then "Clear Status File". >>> DenzilS@mxgroup.co.za 06/12/02 05:06AM >>> Hi all Im running Da...

In case anyone is interested, I called Technical Support and they helped me to figure out that the problem was local to my workstation. An uninstall and re-install of the DataStage client fixed the problem. Scott >>> Scott Brooks 06/11/2002 9:48:56 AM >>> Hi All, Im doing a DSExport on a project and...

Its not a real answer, just some ideas. Its probably a problem with father and child processes on unix (couldnt explain more as Im not very comfortable with unix - ask your system manager). Another reason : any after-job routine or somethingg like that in your batch? Kasia At 10:06 12/06/2002, you w...

In the Director, highlight the batch name and click on "job" then "Clear Status File". >>> DenzilS@mxgroup.co.za 06/12/02 05:06AM >>> Hi all Im running Datastage 5.1 on unix and I am encountering the following problem: I have a batch job which is running, and when I try to stop it, it doesnt. the jo...

Hi Julie Try the function TRIM, i.e. TRIM(Expression). This function will delete all leading and trailing spaces, also to many (more than 1) between words. Regards Peter -----Original Message----- From: Julie.Jarrett@ing.com.au [mailto:Julie.Jarrett@ing.com.au] Sent: Wed 12.06.2002 03:29 To: datasta...