DSXchange

Hi , we do not want to use the notification activity in sequencer. Was searching for any routine or code to do it. I was able to do it for a particular job to get the start, end and count for no of rows, but needed it for whole category i.e. all jobs in category. Thanks Thanks Craig. Woah!! needed a...

Gurus ,

I need to take out the report on folder/category with some basic info like job run time , start time and no of rows processed.

I'm able to do it for a particular job but requirement is get the info for all the jobs in the particular folder.

Thanks

Thanks ..where I need to check this on Ascential box in .profile or ...?
As I'm new to admin activities.

Thanks,

rasi wrote:Make sure you are pointing to the right ORACLE_HOME, PATH which includes Libary PATH after migration.

Gurus, We are using DS version 7.1 and many of our jobs are using Oracle OCI 9i stage to insert/ fetch data from Oracle 9i. We are having the upgrade of our DB to 10g and was wondering that would it impact our jobs as we do not have the 10g stage or 9i stage will work fine with 10g database or need ...

Mistake at my end the version is 7.1 and somehow it do not accept $pojdef for encrypted password, if I type the correct password in encrypted form it works but if I default it to $PROJDEF it fails, Thanks, Munish Gurus, I'm working in DS 7.5 and for some reasons $PROJDEF do not work for encrypted pa...

Gurus,

I'm working in DS 7.5 and for some reasons $PROJDEF do not work for encrypted password but if I make the password as string instead of encrypted it works.

Any suggestion , I read before that this is a bug but is there is any patch available for it.

Rgds,

Gurus, I've a sequencer of jobs and I need to populate the start time of 1st job when I start my 5th job. I thouht of storing the start time for 1st job in hash file and then read it from hash when i start my 5th job in sequence but is there is any built in function in DS from where i can grab the s...

Gurus, I've a job which process 500000 rows of data on daily basis. I've a transformer from which one link goes to OCI stage in insert rows w/o clearing mode. My query is if I replace the OCI stages with 4 OCI stages using the link partinioner and insert the data in 4 streams to oracle table will it...

Hi Kim, I imprted the dsx for etlStats. One of the job 'Get_job_Status' works fine but the only thing is its briniging all the information for the whole project. I need to run get status for particular category i.e. job in one folder. I tried modifying the code but its not helping me out. Request yo...

Hi ,

IS there is any DS component in DS_AUDIT for mod date as I want to select all the jobs modifief for today only like

SELECT MODIFIER, DTM FROM DS_AUDIT WHERE DS_JOBS.MODIFIED_ON >= 2004-10-04 00:00:00

the above SQL do not work for where clause.

Thanks
- Munish

Hi, For Audit purpose I need to know the jobs changed for todays date. I'm running the command SELECT DTM, MODFIFIER FROM DS_AUDITS 0r SELECT * FROM DS_AUDITS or SELECT MODIFIER, DTM FROM UNNEST DS_AUDIT ON MODS but it gives me name of all the jobs been modified I need to add the where clause for to...

Gurus, I need to export few jobs from dev to test thro' DS manager import/export utility. Jobs are in different folders in DS. Is there is any option that I import the sequencer and all the child jobs i.e. all other jobs called by the sequencer will be exported in .dsx folder. I do not want to bring...

Hi ,

The version is 7.1

rgds,
munish

chulett wrote:What exact version of DataStage? I seem to recall encrypted environment variables being broken until recently.

Hi, We are facing the problem with password enviorment variable. While moving all the jobs our parameter are been defined as $PROJDEF to pick up the value from project enviorment variables. Password variable is been defined as encrypted and somehow it is not able to pick up the value....But if chang...

I need to export the table definition from manager(repository) to csv or excel file. [quote="LogicDude"][quote="shrey3a"]Hi, I'm trying to export the table definition for individual component in the excel/csv format. Is there is any way to do this as I was unable to find any opti...