DSXchange

Narasimha,

Thanks for the suggestion. I did it, but to no avail as the stages are still missing.

Thanks,

kris007, If I go to the Customize palette option under the View menu option within Designer, not displayed within the listed Repository items for Sequence are the missing stages. Again, I am not sure why they are missing as they exist for all of our other projects. This project is newly created, but...

All, I am developing a sequencer within new DataStage project, but I have an issue. The Terminator Activity, EndLoop Activity, StartLoop Activity, and UserVariables Activity stages are missing from the Sequence palette. What makes this strange is that I can open up other projects using the same Desi...

Ray, Ok...I have gotten it to work but with strange behaviors. If I define the Notification Activity parameters as follows: Senders email address: #AbortingJob# Recipients email address: #SupportEmail# Email Subject: #RoutGetMessages.$ReturnValue# Email body: I receive the following email: From: J_C...

Ray, The job parameter values for UtilityEmailMsgsSeq.J_FAA_Clear_Hash_Files as reported by the DataStage log look good: SupportEmail=chris.simms@mkcorp.com AbortingJob=J_FAA_Clear_Hash_Files SubjectLine=Job J_FAA_Clear_Hash_Files aborted within Main_FAA And if I execute the following script within ...

Hello, In an effort to add additional event notification to production support for our ETL processes, I added calls to the Utility routine UtilitySeqEmailAndAbort in our sequencers. It was working fine and then a few days ago quit. When I look at the log for the sequencer UtilityEmailMsgsSeq and for...

All, The DSR stage is executing the truncate table command and the table is being truncated. According to our DBA, no locks are being maintained on table which is good but the session is listed as inactive which is bad. It appears that Oracle is waiting for DataStage to close the connection but Data...

DSguru2B and kris007,

Yes, the table successfully truncates under Toad. I do need to check with our DBA as the Truncate only Update action is truncating the table as well. However, I need to see if the thread is actually being released or is holding on for whatever reason.

Thanks,

All, First, the database user has truncate permissions. I can do this under the user in a tool such as Toad. The job hangs though using the Truncate only option and I am not sure why. I have been at places where the script method was employed, but I am trying to keep the solution strictly within Dat...

Kris, The SQL is as follows: TRUNCATE TABLE STAGING.#J_TABLE_NAME#_SNAP_KEYS I am attempting to not use the Truncate then Insert rows Update action as I do not want to define a particular column as the table name is dynamic. I have tried to use the Truncate only option which looks like it would work...

All, This may sound silly, but what is the cleanest method to have a job truncate a table only. That is the job does not also insert rows afterwards into the table and does not require a driver table or file to kick off the process. Currently I am using a transformer stage with a stage variable to d...

Chuck,

What I mean by not being able to select it is that while I can choose the option, the DataStage client will not remember this selection. When the stage is reopened, the Insert new rows only Update action is defined.

Regards,


Chris

Hello, I am attempting to use the Dynamic RDBMS stage within a DataStage server 7.5.1 job, but an odd thing is happening. I want to use the User-defined SQL Update Action and the stage does allow me to select it. However, after I press the OK button and then open the stage back up, the Update Action...

Hello all, I have a situation where I want to within a Modify stage: a. Suppress a leading edge character. b. Right-justify the resulting string Column meta-data is as follows: input - ColY Varchar (64) output - ColX Char (15) Test input value - "ggggggreen" Specification = ColX:string[15]...

Hello, I am new to EE programming, so please bear with me. Is there a source of EE function documentation, those functions that are pre-packaged and can be accessed within the Transformer stage, that is complete with full explanations of argument/return values? This information seems to be missing i...